functions_search.php error

Hangin' Around Joined: Mar 27, 2006 Posts: 27

I keep getting errors like this when I try to edit or delete posts. Any suggestions?

Code:

Could not insert new word





DEBUG MODE





SQL Error : 144 Table './minne004/nuke_bbsearch_wordlist' is marked as crashed and last (automatic?) repair failed





INSERT IGNORE INTO nuke_bbsearch_wordlist (word_text, word_common) VALUES ('11th', 0), ('14th', 0), ('28th', 0), ('9th', 0), ('august', 0), ('com', 0), ('dates', 0), ('details', 0), ('forest', 0), ('four', 0), ('getting', 0), ('july', 0), ('june', 0), ('lake', 0), ('mastercraft', 0), ('midwest', 0), ('minnesota', 0), ('motor', 0), ('process', 0), ('right', 0), ('sports', 0), ('stops', 0), ('sweeeet', 0), ('tba', 0), ('tour', 0), ('trust', 0), ('verified', 0), ('wakeboarder', 0)





Line : 235


File : functions_search.php

Posted: Fri Feb 02, 2007 7:02 am

Your nuke_bbsearch_wordlist table is having issues. You will need to go into your control panel and use something like phpMyAdmin to perform a "repair" on that table.

Site Admin Joined: Jun 04, 2004 Posts: 6433

First, you can try to repair the nuke_bbsearch_wordlist table via phpMyAdmin. If not, you may have to recreate the table. I think there is an SQL or may even an admin function to rebuild the table.

Posted: Fri Feb 02, 2007 7:17 am

Great minds think alike! killing me

We're even in perfect harmony...

Posted: Fri Feb 02, 2007 8:50 am

When I go "Repair Table" it tells me the table is already up to date. Then I go to the table and it gives me:

Code:

#144 - Table './minne004/nuke_bbsearch_wordlist' is marked as crashed and last (automatic?) repair failed

It's almost like I repair it and then it crashes again shortly after. Or maybe its not fixing it. Any suggestions?

Posted: Fri Feb 02, 2007 1:12 pm

If I Repair the table, do I also need to Repair the database? If so how do I repair the database? I know for repairing the table it is "REPAIR TABLE 'table name'

How do I recreate or rebuild it?

Posted: Fri Feb 02, 2007 4:04 pm

Nevermind, it was a host problem. Their server crashed and corrupted some tables, but I got them to fix mine.

Thanks for the help!

Posted: Fri Feb 02, 2007 4:13 pm

Thanks for following up...