Print

[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