Error message 1016

My guestbook can no longer accept entires. When clicking on "sign guestbook" .....(addentry.php) I get the message below:

MySQL Error : Query Error
Error Number: 1016 Can't open file: 'book_captcha.MYI'. (errno: 145)

plus some url info:

Date : Tue, December 9, 2008 18:39:18
IP : 66.29.173.2
Browser : Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8.1.1

Gecko/20081029 Firefox/2.0.0.18
Referer : http://removed/index.php
PHP Version : 4.3.11
OS : Linux
Server : Apache
Server Name : removed

Any idea how to fix this. I'm hosting this on godaddy and they can't figure this out.

Any help appreciated. I have 1000s ofe netries and don't want to lose them.

Thanks in Advance

Tom

To be honest that says a lot about Godaddy's incompetence. MySQL stores it's data in files and the error is saying it cannot open the book_captcha.myi file possibly because the permissions have been changed on the server, it has run out of disk space or the file is somehow corrupted. You should be able to safely delete book_captcha and make a new one since it is only used to store the captcha characters.

Thanks Carbonize for your quick reply,

Excuse my incompetence but how do I make a new book_captcha.myi file if that what it comes down to.

Thanks in advance

Tom

tom56700 wrote:Thanks Carbonize for your quick reply,

Excuse my incompetence but how do I make a new book_captcha.myi file if that what it comes down to.

Thanks in advance

Tom

And where is this file suppose to live?

Can't seem to locate it.

Tom

You won't have acces to the file in question. Given that MySQL cannot touch it possibly it cannot delete it neither. Just pass my suggestion on to your hosts to deal with.

Ok..will do.

I'll remove the "incompetence" part for faster response

Tom

Ok..finally got a reply back from GoDaddy (please see below)

I would appreciate your input to what my next step should be.

Any input on the syntax reference?

Thanks in advance

Tom

Thank you for contacting Hosting Support.

The difficulty you are encountering is likely an indication that the book_captcha table has become corrupted. We would recommend that you repair that table. You can run the repair table command from within the phpMyAdmin interface for the affected database by clicking on the SQL tab after logging in to phpMyAdmin. If you are unsure of what syntax to use for the repair table command, you may wish to do a web search on the command and/or the error being generated.

Please let us know if there is anything else we can assist you with.

If you have phpMyAdmin simply go to the database that holds the guestbook tables and tick the book_captcha table. Then below the list of tables you will see the With selected: drop down list. Select Repair table.

Thanks again Carbonize for quick responses.

I did what you suggested and unfortunately it did not make a difference.

Still get: 1016 Can't open file: 'book_captcha.MYI'. (errno: 145)

Should I try optimize or FLUSH?

I can tell I'm not alone with this, when pasting this string into google I see lots of similar pages with the same issue.

Any other suggestions?

Tom

As I stated earlier your host really needs to delete the file in question so you can remake it fresh. Wonder what they did to screw it up.

I'm sorry to keep this going for so long, but I want to make sure.

After I ask them to delete it, how would I create a new one? Or do they do that?

Can I delete this in phpadmin?

Thanks again

Tom

You can try deleting it in phpMyAdmin then I can give you the query to run in phpMyAdmin to recreate it.

It appears I can't delete it. I will ask Godaddy to do that and if they can't recreate it I will ask for your query.

Thanks