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: "There was an error while processing a database query" .. what does that mean?  (Read 2838 times)

0 Members and 1 Guest are viewing this topic.

lisbizzz

  • Coppermine newbie
  • Offline Offline
  • Posts: 5

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!
Logged

Joachim Müller

  • Dev Team member
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 47844
  • aka "GauGau"
    • gaugau.de

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

lisbizzz

  • Coppermine newbie
  • Offline Offline
  • Posts: 5

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)
Logged

ecto

  • Supporter
  • Coppermine frequent poster
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 144
    • My very incomplete gallery
Logged
Pages: [1]   Go Up
 

Page created in 0.016 seconds with 20 queries.