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: Error showing in database log  (Read 1345 times)

0 Members and 1 Guest are viewing this topic.

kdmiller45

  • Coppermine newbie
  • Offline Offline
  • Posts: 7
Error showing in database log
« on: January 10, 2022, 11:15:58 pm »

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

Logged
Pages: [1]   Go Up
 

Page created in 0.015 seconds with 19 queries.