Error - mysql query

[doRm]

There's an error in my gallery - http://gallery.exweb.org. In czech "Vyskytla se chyba při databázovém dotazu." and in english it's something like that: "There's an error with mysql query". Do you know what it is?

[Sami]

enable debug mode and post the actual Error

[Joachim Müller]

http://coppermine-gallery.net/tutorial/debug_mode.php

[doRm]

hi,

While executing query "SELECT count(*) FROM cpg132_pictures as p, cpg132_albums as a WHERE p.aid = a.aid AND approved='YES' AND category >= 10000" on 0

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

[Sami]

Your cpg132_picture is cruppted
Eiher use phpmyadmin to repair that table or use repair option under mysql database section of your hosting control panel (if you have)

[Joachim Müller]

FAQ-thread: Typical Error: Can't open file: 'cpg131_pictures.MYI'. (errno: 145)

[doRm]

ahhh :-) Thanks!!! 

[Joachim Müller]

In the future, search for your error message.