"There was an error while processing a database query" .. what does that mean?

[lisbizzz]

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!

[Joachim Müller]

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

[lisbizzz]

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)

[ecto]

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