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: Critical error There was an error while processing a database query  (Read 36993 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.017 seconds with 20 queries.