1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

XF 1.2 Table 'xf_search_index' is marked as crashed and should be repaired

Discussion in 'Troubleshooting and Problems' started by mono, Feb 27, 2014.

  1. mono

    mono Active Member

    Hello. Actually can't say what may cause this error. So here it is:

    Zend_Db_Statement_Mysqli_Exception: Mysqli statement execute error : Table 'xf_search_index' is marked as crashed and should be repaired - library/Zend/Db/Statement/Mysqli.php:214
    #0 /.../library/Zend/Db/Statement.php(317): Zend_Db_Statement_Mysqli->_execute(Array)
    #1 /.../library/Zend/Db/Adapter/Abstract.php(479): Zend_Db_Statement->execute(Array)
    #2 /.../library/Zend/Db/Adapter/Abstract.php(734): Zend_Db_Adapter_Abstract->query('?????SELECT sea...', '+POI +(_md_cont...')
    #3 /.../XenForo/Search/SourceHandler/MySqlFt.php(291): Zend_Db_Adapter_Abstract->fetchAll('?????SELECT sea...', '+POI +(_md_cont...', 3)
    #4 /.../library/XenForo/Search/SourceHandler/Abstract.php(152): XenForo_Search_SourceHandler_MySqlFt->executeSearch('POI', false, Array, Array, '', '200', Object(XenForo_Search_DataHandler_Post))
    #5 /.../XenForo/Search/Searcher.php(111): XenForo_Search_SourceHandler_Abstract->searchType(Object(XenForo_Search_DataHandler_Post), 'POI', Array, 'date', 0, '200')
    #6 /.../library/XenForo/ControllerPublic/Search.php(228): XenForo_Search_Searcher->searchType(Object(XenForo_Search_DataHandler_Post), 'POI', Array, 'date', 0)
    #7 /.../library/XenForo/FrontController.php(337): XenForo_ControllerPublic_Search->actionSearch()
    #8 /.../XenForo/FrontController.php(134): XenForo_FrontController->dispatch(Object(XenForo_RouteMatch))
    #9 /.../index.php(13): XenForo_FrontController->run()
    #10 {main}
    After that I've tried to rebuild search index and after got that:

    Mysqli statement execute error : Duplicate entry 'post-246834' for key 'PRIMARY'
    [*]Zend_Db_Statement_Mysqli->_execute() in Zend/Db/Statement.php at line 297
    [*]Zend_Db_Statement->execute() in Zend/Db/Adapter/Abstract.php at line 479
    [*]Zend_Db_Adapter_Abstract->query() in XenForo/Search/SourceHandler/MySqlFt.php at line 110
    [*]XenForo_Search_SourceHandler_MySqlFt->_pushToIndex() in XenForo/Search/SourceHandler/MySqlFt.php at line 119
    [*]XenForo_Search_SourceHandler_MySqlFt->finalizeRebuildSet() in XenForo/Search/Indexer.php at line 125
    [*]XenForo_Search_Indexer->finalizeRebuildSet() in XenForo/Deferred/SearchIndex.php at line 74
    [*]XenForo_Deferred_SearchIndex->execute() in XenForo/Model/Deferred.php at line 208
    [*]XenForo_Model_Deferred->runDeferred() in XenForo/Model/Deferred.php at line 331
    [*]XenForo_Model_Deferred->_runInternal() in XenForo/Model/Deferred.php at line 284
    [*]XenForo_Model_Deferred->run() in XenForo/ControllerAdmin/Tools.php at line 147
    [*]XenForo_ControllerAdmin_Tools->actionRunDeferred() in XenForo/FrontController.php at line 337
    [*]XenForo_FrontController->dispatch() in XenForo/FrontController.php at line 134
    [*]XenForo_FrontController->run() in /.../admin.php at line 13

    Xenforo version 1.2.2. Besides that there are no visible problems with the intallation. Thanks for help.
  2. Brogan

    Brogan XenForo Moderator Staff Member

    Try truncating (emptying) the table and rebuilding the index again.
    CivilWarTalk, mono and TBDragon like this.
  3. borbole

    borbole Well-Known Member

    Can you try to repair the table marked as crashed and see if it would solve the error?
  4. TBDragon

    TBDragon Active Member

    this is the only solution that work with me for this issue ^_^
  5. mono

    mono Active Member

    Yes, it helps. Thank you!

Share This Page