Advanced search  

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

Pages: [1]   Go Down

Author Topic: MySQL query error  (Read 1776 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.017 seconds with 20 queries.