If you are not registered or logged in, you may still use these forums but with limited features. Show recent topics
  [Search] Search   [Hottest Topics] Hottest Topics   [Members]  Member Listing   [FAQ]  FAQ 
[Register] Register / 
[Login] Login 
Error message 1016  XML
Forum Index » Advanced Guestbook Forum
Author Message
tom56700
Beginner

Joined: 10/05/2006 19:05:48
Messages: 14
Offline

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
Carbonize
Master
[Avatar]

Joined: 12/06/2003 19:26:08
Messages: 4292
Location: Bristol, UK
Offline

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.

Carbonize
I am not the maker of the Advanced Guestbook

get Lazarus
[Email] [WWW] [Yahoo!] aim icon [MSN] [ICQ]
tom56700
Beginner

Joined: 10/05/2006 19:05:48
Messages: 14
Offline

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
Beginner

Joined: 10/05/2006 19:05:48
Messages: 14
Offline

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
Carbonize
Master
[Avatar]

Joined: 12/06/2003 19:26:08
Messages: 4292
Location: Bristol, UK
Offline

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.

Carbonize
I am not the maker of the Advanced Guestbook

get Lazarus
[Email] [WWW] [Yahoo!] aim icon [MSN] [ICQ]
tom56700
Beginner

Joined: 10/05/2006 19:05:48
Messages: 14
Offline

Ok..will do.

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

Tom
tom56700
Beginner

Joined: 10/05/2006 19:05:48
Messages: 14
Offline

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.
Carbonize
Master
[Avatar]

Joined: 12/06/2003 19:26:08
Messages: 4292
Location: Bristol, UK
Offline

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.

Carbonize
I am not the maker of the Advanced Guestbook

get Lazarus
[Email] [WWW] [Yahoo!] aim icon [MSN] [ICQ]
tom56700
Beginner

Joined: 10/05/2006 19:05:48
Messages: 14
Offline

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
Carbonize
Master
[Avatar]

Joined: 12/06/2003 19:26:08
Messages: 4292
Location: Bristol, UK
Offline

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.

Carbonize
I am not the maker of the Advanced Guestbook

get Lazarus
[Email] [WWW] [Yahoo!] aim icon [MSN] [ICQ]
tom56700
Beginner

Joined: 10/05/2006 19:05:48
Messages: 14
Offline

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
Carbonize
Master
[Avatar]

Joined: 12/06/2003 19:26:08
Messages: 4292
Location: Bristol, UK
Offline

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

Carbonize
I am not the maker of the Advanced Guestbook

get Lazarus
[Email] [WWW] [Yahoo!] aim icon [MSN] [ICQ]
tom56700
Beginner

Joined: 10/05/2006 19:05:48
Messages: 14
Offline

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
 
Forum Index » Advanced Guestbook Forum
Go to:   
Based on the open source JForum