MySQL query error MySQL query error
 

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