Gallery not working

[strokesfan]

I hadn't been to my gallery in weeks and I finally go to it and it says:

There was an error while processing a database query.

Then I put it in debug mode and it said this:
While executing query "SELECT count(*) FROM cpg_pictures as p, cpg_albums as a WHERE p.aid = a.aid AND category >= 10000" on 0

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

Can anyone help? Thanks

[Tranz]

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

For future reference, plase search on error messages as it is likely others have encountered the same thing.

[strokesfan]

how do I know what my table name is?

[Tranz]

from your error message: cpg_pictures

Hope that helps.

[strokesfan]

thanks it worked!

[Tranz]

Good to hear. Thanks for letting us know.