MySQL query error MySQL query error
 

News:

CPG Release 1.6.26
Correct PHP8.2 issues with user and language managers.
Additional fixes for PHP 8.2
Correct PHP8 error with SMF 2.0 bridge.
Correct IPTC supplimental category parsing.
Download and info HERE

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