SQL Error : 1016 Cant open file: nuke_bbsearch_wordmatch.MYI

Client Joined: Dec 04, 2004 Posts: 757

Hello all, just out of the blue today members on my battlefield 2 site cant post? they including me get this error

Could not insert new word matches

DEBUG MODE

SQL Error : 1016 Can't open file: 'nuke_bbsearch_wordmatch.MYI'. (errno: 145)

INSERT INTO nuke_bbsearch_wordmatch (post_id, word_id, title_match) SELECT 1973, word_id, 0 FROM nuke_bbsearch_wordlist WHERE word_text IN ('test')

Line : 252
File : functions_search.php

I decided to do a back up of a few days ago when the site was 100% but I am still getting this post error?

any help much apriciated
thanks
mrix

Site Admin/Owner Joined: Aug 27, 2002 Posts: 17088

Your bbsearch_wordmatch table's index got hosed, which sometimes happens (to any table). nuke_bbsearch_wordmatch.MYI - The MYI is the MySQL Index file. Whenever you see that you need to go into phpMyAdmin and you will see a message when it tries to list your tables. In this case, yours said in use. So, you select that table by checking the check box to the left and then select REPAIR from the drop down box. I did this for you this time but you can take care of it if/when it happens again Smile

Also, please select a better subject for your posts that will more easily explain, at a glance, what the post is about Wink

I will change yours from Cant understand what has happened? to SQL Error : 1016 Can't open file: 'nuke_bbsearch_wordmatch.MYI'. (errno: 145) or something similar.

Posted: Wed Nov 09, 2005 4:19 pm

many thanks for that as you can see by many of my posts I always put good titles normally, but with this one I was desperate to be honest Smile

thanks
mrix

New Member Joined: Feb 11, 2005 Posts: 4

same problem & mine says "in use" as well, but i don't see the "REPAIR" option... maybe i'm blind.

Posted: Fri Nov 11, 2005 4:00 pm

Quote:

So, you select that table by checking the check box to the left and then select REPAIR from the drop down box.

Check the box beside the table. Then scroll down to the bottom of the tables listing and select REPAIR from the drop down list.

Posted: Fri Nov 11, 2005 4:06 pm

aha, like i said.. i'm blind.
grazie