MySQL syntax error after install MySQL syntax error after install
 

News:

CPG Release 1.6.27
change DB IP storage fields to accommodate IPv6 addresses
remove use of E_STRICT (PHP 8.4 deprecated)
update README to reflect new website
align code with new .com CPG website
correct deprecation in captcha

Main Menu

MySQL syntax error after install

Started by siicis, July 14, 2009, 10:56:25 PM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

siicis

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?

siicis

Sloved this problem: first character of table prefix MUST be char, not number. For example: a123_ ir good, but 2009_ is bad.