Error showing in database log Error showing in database log
 

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]

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