Advanced search  

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]

Pages: [1]   Go Down

Author Topic: MySQL query error  (Read 1478 times)

0 Members and 1 Guest are viewing this topic.

Krys

  • Translator
  • Coppermine newbie
  • **
  • Country: fr
  • Offline Offline
  • Gender: Male
  • Posts: 15
MySQL query error
« 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 :

Quote
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!
Logged

Krys

  • Translator
  • Coppermine newbie
  • **
  • Country: fr
  • Offline Offline
  • Gender: Male
  • Posts: 15
Re: MySQL query error
« Reply #1 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.
Logged
Pages: [1]   Go Up
 

Page created in 0.025 seconds with 21 queries.