Print Page - Datbase error

Title: Datbase error
Post by: colinmann on March 15, 2005, 10:18:17 PM

When i go to my photos site @ www.colinmann.com/photos, i get this...

"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)"

Things were working fine earlier today. Please don't tell me it means I've got to rebuild what I've done. I've tried to repair the database... but it says:

"error : Can't open file: 'cpg11d_pictures.MYI'. (errno: 138)"

Have you please got any other ideas?

Title: Re: Datbase error
Post by: Joachim Müller on March 15, 2005, 11:47:33 PM

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

Title: Re: Datbase error
Post by: kegobeer on March 16, 2005, 03:19:40 AM

If you still can't access/repair the table, you might be out of luck. Do you have a recent MySQL database backup handy?

Title: Re: Datbase error
Post by: colinmann on March 16, 2005, 10:11:54 AM

i was unable to restore the database, so i restored it from december :-(. Still an amazing application.

Title: Re: Datbase error
Post by: kegobeer on March 16, 2005, 01:00:55 PM

Here's more MySQL repair information:

http://dev.mysql.com/doc/mysql/en/repair.html

coppermine-gallery.com/forum

Support => Older/other versions => cpg1.2 Standalone Support => Topic started by: colinmann on March 15, 2005, 10:18:17 PM