forum.coppermine-gallery.net

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

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