Skip to main content

"Could not insert new word matches


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

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

Line : 252
File : functions_search.php"

The problem is no one here is looking for anything...making any sense yet?

Topic Tags


audiokid Tue, 11/03/2009 - 11:22

For others around the world that ever experience this problem:

[root@server yourdatabase]# myisamchk -r -f nuke_bbsearch_wordmatch
- recovering (with sort) MyISAM-table 'nuke_bbsearch_wordmatch'
Data records: 13202406
- Fixing index 1

[root@server yourdatabase]# mysqlcheck -r -u root -p yourdatabase nuke_bbsearch_wordmatch
Enter password:
yourdatabase.nuke_bbsearch_wordmatch OK
[root@server yourdatabase]#

Big Thanks to OC3 Networks, problem fixed.