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

[mono]

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'

[LIST=1]
[*]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.

 

[Paul B]

Try truncating (emptying) the table and rebuilding the index again.

 

[borbole]

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

 

[TBDragon]

Try truncating (emptying) the table and rebuilding the index again.

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

 

[mono]

Try truncating (emptying) the table and rebuilding the index again.

Yes, it helps. Thank you!