[Solved]: database error

[Drew3178]

While executing query "SELECT count(*) FROM cpg11d_pictures, cpg11d_albums WHERE cpg11d_pictures.aid = cpg11d_albums.aid AND category >= 10000" on 0

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

this totally came out of the blue.. I havent changed any configs or anything, and I suddenly get this error..

any clues?

[Drew3178]

BTW, this is integrated with Invision power board (same database even) and it is working fine, its just coppermine..

edit: I just repaired the table via mysql, but im still wondering WHY this happened?? I really dont want to have to repair the table all the time.

[hyperion]

Happens for many reasons. If the server went down or the process was terminated in the middle of writing to the database, you will get a corrupt table.