Advanced search  

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]

Pages: [1]   Go Down

Author Topic: Need help  (Read 6787 times)

0 Members and 1 Guest are viewing this topic.

SaraBailey

  • Coppermine newbie
  • Offline Offline
  • Posts: 1
Need help
« on: November 25, 2019, 10:35:17 am »

For some reason when I go to the 2nd level categories I get a critical error -
There was an error while processing a database query. When I put it on debug mode it says this:

-----
While executing query 'SELECT a.aid, a.title, a.description, a.thumb, a.keyword, category, visibility, filepath, filename, url_prefix, pwidth, pheight, a.owner  FROM cpg_albums AS a  LEFT JOIN cpg_pictures AS p ON a.thumb=p.pid  WHERE a.category = 37   ORDER BY  LIMIT 0,1' in index.php on line 778

mySQL error: 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 'LIMIT 0,1' at line 1

File: /home/public_html/pictures/include/functions.inc.php - Line: 272
------

Thanks for any help you can give me!
Logged

ron4mac

  • Administrator
  • Coppermine addict
  • *****
  • Country: us
  • Offline Offline
  • Posts: 2026
Re: Need help
« Reply #1 on: November 25, 2019, 07:23:36 pm »

Try changing the default album sort order.

Config -> Album list view -> Sort order for albums
Logged
Pages: [1]   Go Up
 

Page created in 0.018 seconds with 20 queries.