Advanced search  

News:

CPG Release 1.6.26
Correct PHP8.2 issues with user and language managers.
Additional fixes for PHP 8.2
Correct PHP8 error with SMF 2.0 bridge.
Correct IPTC supplimental category parsing.
Download and info HERE

Pages: [1]   Go Down

Author Topic: MySQL syntax error after install  (Read 3298 times)

0 Members and 1 Guest are viewing this topic.

siicis

  • Coppermine newbie
  • Offline Offline
  • Posts: 2
MySQL syntax error after install
« on: July 14, 2009, 10:56:25 pm »

Hello!
After install I got this error in debug mode:
##
While executing query "delete from `GIFAFFI2009`.2009_sessions where time<1247599382 and remember=0;" on Resource id #6

mySQL error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '.2009_sessions where time<1247599382 and remember=0' at line 1
##
This error also is in login file.
My gallery - http://www.rsp.lv/caps/gifaffi1_2009/
That I need to do?
Logged

siicis

  • Coppermine newbie
  • Offline Offline
  • Posts: 2
[Solved]: MySQL syntax error after install
« Reply #1 on: July 27, 2009, 12:24:23 pm »

Sloved this problem: first character of table prefix MUST be char, not number. For example: a123_ ir good, but 2009_ is bad.
Logged
Pages: [1]   Go Up
 

Page created in 0.014 seconds with 19 queries.