Error showing in database log Error showing in database log
 

News:

CPG Release 1.6.29
During HTML5 upload, keep pseudo blank code 200 messages from triggering error condition
added Russian language
correct failure to use theme menu icons in album manager
minor vulnerabilities mitigation

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