1. Register NOW and become part of this fantastic knowledge base forum! This message will go away once you have registered.

SQL Error : nuke_bbsearch_wordmatch' is marked as crashed

Discussion in 'Vintage Analog Gear' started by Space, Nov 2, 2009.

  1. Space

    Space Well-Known Member

    "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?
     
  2. audiokid

    audiokid Staff

    problem fixed.
     
  3. audiokid

    audiokid Staff

    For others around the world that ever experience this problem:

    Code:
    [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)
     

Share This Page