forum.coppermine-gallery.net

Support => cpg1.4.x Support => Older/other versions => cpg1.4 miscellaneous => Topic started by: lisbizzz on December 24, 2005, 10:16:54 am

Title: "There was an error while processing a database query" .. what does that mean?
Post by: lisbizzz on December 24, 2005, 10:16:54 am

My gallery used to be working fine. Now all of a sudden I get an error and I can't view any of the pictures anymore.
I can't figure out what I did wrong, last night it still worked, and I didn't add/change/remove things then.. so I can't figure it out.
The error is: Crictal Error: There was an error while processing a database query

Does anyone know what that is, and perhaps know how to solve it?
I can still log in as admin, and change configuration and such, and all the albums and categories are still there ..  I dunno what's wrong.

Please help me!

Title: Re: "There was an error while processing a database query" .. what does that mea
Post by: Joachim Müller on December 24, 2005, 01:19:48 pm

enable debug mode in coppermine's config to get the actual query that failed. Post it here (the error message, not the debug_output)

Title: Re: "There was an error while processing a database query" .. what does that mean?
Post by: lisbizzz on December 25, 2005, 12:13:03 pm

OK, I did it, this is the error:

While executing query "SELECT count(*) FROM cpg_pictures as p, cpg_albums as a WHERE p.aid = a.aid AND category = 2" on 0

mySQL error: Can't open file: 'cpg_pictures.MYI'. (errno: 145)

Title: Re: "There was an error while processing a database query" .. what does that mean?
Post by: ecto on December 25, 2005, 04:11:00 pm

http://forum.coppermine-gallery.net/index.php?topic=10409.0