x
Space 2 November 2009

"Could not insert new word matches

DEBUG MODE

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

Comments

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.

(y)

x

User login