Print Page - [Solved]: database error

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

QuoteWhile 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.

coppermine-gallery.com/forum

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