SQL Error : nuke_bbsearch_wordmatch' is marked as crashed

Discussion in 'Mixing' started by Space, Nov 2, 2009.

Tags:
  1. Space

    Space Well-Known Member

    Joined:
    Jun 26, 2007
    "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 Chris Well-Known Member

    Joined:
    Mar 20, 2000
    Location:
    BC, Canada
    Home Page:
    problem fixed.
     
  3. audiokid

    audiokid Chris Well-Known Member

    Joined:
    Mar 20, 2000
    Location:
    BC, Canada
    Home Page:
    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)
     
Similar Threads
  1. shezan
    Replies:
    1
    Views:
    1,322
  2. Doomith
    Replies:
    2
    Views:
    1,588
  3. Gerkass
    Replies:
    3
    Views:
    1,694
  4. Treva
    Replies:
    3
    Views:
    1,728
  5. JoaoSpin
    Replies:
    7
    Views:
    260
Loading...

Share This Page