MySQL query error MySQL query error
 

News:

cpg1.5.48 Security release - upgrade mandatory!
The Coppermine development team is releasing a security update for Coppermine in order to counter a recently discovered vulnerability. It is important that all users who run version cpg1.5.46 or older update to this latest version as soon as possible.
[more]

Main Menu

MySQL query error

Started by Krys, September 24, 2014, 08:12:38 PM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

Krys

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:

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

Thank you for your help!

Krys