forum.coppermine-gallery.net

Support => Older/other versions => cpg1.2 Standalone Support => Topic started by: Drew3178 on April 19, 2004, 11:14:22 pm

Title: [Solved]: database error
Post by: Drew3178 on April 19, 2004, 11:14:22 pm

Quote

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?

Title: [Solved]: database error
Post by: Drew3178 on April 19, 2004, 11:23:37 pm

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.

Title: [Solved]: database error
Post by: hyperion on April 20, 2004, 01:07:19 am

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.