coppermine-gallery.com/forum

Support => cpg1.5.x Support => cpg1.5 miscellaneous => Topic started by: Krys on September 24, 2014, 08:12:38 PM

Title: MySQL query error
Post by: Krys on September 24, 2014, 08:12:38 PM
Hello,

Having enabled logging in Coppermine, there is a MySQL that I find sometimes in the database log :

QuoteSeptembre 24, 2014 at 01:10 AM - While executing query 'SELECT COUNT(*) FROM cpg15x_pictures AS p
            INNER JOIN cpg15x_albums AS r ON r.aid = p.aid
            WHERE (1)
            AND approved = 'YES'
            AND (ctime >
            OR ctime =  AND pid > 27045)' in include/functions.inc.php on line 2160 the following error was encountered:
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 'OR ctime =  AND pid > 27045)' at line 6

Strangely, there is no value to compare against the "ctime" column.

Do anyone have an idea of the reason of this error?

I am running Coppermine 1.5.30 with the following plugins:

Thank you for your help!
Title: Re: MySQL query error
Post by: Krys on September 24, 2014, 08:15:50 PM
Sorry, this is a duplicate topic: http://forum.coppermine-gallery.net/index.php/topic,77787.0.html

You can close this one.