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: Critical error There was an error while processing a database query  (Read 37021 times)

0 Members and 1 Guest are viewing this topic.

timetrek

  • Coppermine newbie
  • Offline Offline
  • Posts: 2

Critical error

There was an error while processing a database query.

I get this after updating to v1.5.22
I have enabled debug for everyone but not sure what do do from here
Help Please!

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 = 0   ORDER BY  LIMIT 0,17' in index.php on line 795

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,17' at line 1
Logged

Αndré

  • Administrator
  • Coppermine addict
  • *****
  • Country: de
  • Offline Offline
  • Gender: Male
  • Posts: 15764
Re: Critical error There was an error while processing a database query
« Reply #1 on: February 22, 2013, 02:41:44 pm »

Run update.php, as described in the upgrade docs.
Logged

timetrek

  • Coppermine newbie
  • Offline Offline
  • Posts: 2
Re: Critical error There was an error while processing a database query
« Reply #2 on: February 23, 2013, 08:42:31 am »

Thanks Andre, that fixed it. I did the update through my host as a app and didn't see anything about running update.php. I clicked on update now button on the app and when it finished it said update successful.
Thank you again
Billy
Logged

Αndré

  • Administrator
  • Coppermine addict
  • *****
  • Country: de
  • Offline Offline
  • Gender: Male
  • Posts: 15764
Re: Critical error There was an error while processing a database query
« Reply #3 on: February 23, 2013, 09:35:06 am »

Please
tag your answer as "solved" by clicking on the "Topic Solved" button on the bar at the left hand side at the bottom of your thread.
Logged
Pages: [1]   Go Up
 

Page created in 0.019 seconds with 20 queries.