Print

[Krys]

Hello,

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

Septembre 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:

• custom_thumb v 1.6
• theme_switch v1.0
• cookie_consent v1.0

Thank you for your help!

[Krys]

Sorry, this is a duplicate topic: http://forum.coppermine-gallery.net/index.php/topic,77787.0.html

You can close this one.