Error showing in database log Error showing in database log
 

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

Error showing in database log

Started by kdmiller45, January 10, 2022, 11:15:58 PM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

kdmiller45

Was trouble shooting an upload issue and read the database log and found this multiple times

Jan 09, 2022 at 06:36 PM - While executing query 'SELECT r.pid, r.aid, filepath, filename, url_prefix, pwidth, pheight, filesize, ctime, r.title, r.keywords, r.votes, pic_rating, hits, caption, r.owner_id FROM CPG_pictures AS r
WHERE ((aid = 4 ) )AND approved='YES'
ORDER BY filename DESC, pid DESC
LIMIT 0 ,-180' in include/functions.inc.php on line 1436 the following error was encountered:
1064 : 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 '-180' at line 4

O/S Ubuntu 20.04 Server
PHP Version 7.4.3
Coppermine Photo Gallery 1.6.16 (stable)

Keith