forum.coppermine-gallery.net

Support => cpg1.4.x Support => Older/other versions => cpg1.4 install => Topic started by: siicis on July 14, 2009, 10:56:25 pm

Title: MySQL syntax error after install
Post by: siicis 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?

Title: [Solved]: MySQL syntax error after install
Post by: siicis 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.