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

XF 1.4 Server error - Unable to post

ineedhelp

Well-known member
#1
Hi

I need an urgent fix for the code below.

Thanks in advance.

Code:
Mysqli prepare error: Table './ubar_625866_0001/xf_search_index' is marked as crashed and should be repaired
Zend_Db_Statement_Mysqli->_prepare() in Zend/Db/Statement.php at line 115
Zend_Db_Statement->__construct() in Zend/Db/Adapter/Mysqli.php at line 381
Zend_Db_Adapter_Mysqli->prepare() in Zend/Db/Adapter/Abstract.php at line 478
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 82
XenForo_Search_SourceHandler_MySqlFt->insertIntoIndex() in XenForo/Search/Indexer.php at line 44
XenForo_Search_Indexer->insertIntoIndex() in XenForo/Search/DataHandler/Post.php at line 61
XenForo_Search_DataHandler_Post->_insertIntoIndex() in XenForo/Search/DataHandler/Abstract.php at line 275
XenForo_Search_DataHandler_Abstract->insertIntoIndex() in XenForo/DataWriter/DiscussionMessage.php at line 760
XenForo_DataWriter_DiscussionMessage->_insertOrUpdateSearchIndex() in XenForo/DataWriter/DiscussionMessage.php at line 739
XenForo_DataWriter_DiscussionMessage->_indexForSearch() in XenForo/DataWriter/DiscussionMessage.php at line 585
XenForo_DataWriter_DiscussionMessage->_postSave() in XenForo/DataWriter.php at line 1409
XenForo_DataWriter->save() in XenForo/DataWriter/Discussion.php at line 477
XenForo_DataWriter_Discussion->_saveFirstMessageDw() in *******/Credits/DataWriter/Discussion/Thread.php at line 90
*******_Credits_DataWriter_Discussion_Thread->_saveFirstMessageDw() in XenForo/DataWriter/Discussion.php at line 426
XenForo_DataWriter_Discussion->_postSave() in XenForo/DataWriter.php at line 1409
XenForo_DataWriter->save() in XenForo/ControllerPublic/Forum.php at line 730
XenForo_ControllerPublic_Forum->actionAddThread() in XenForo/FrontController.php at line 347
XenForo_FrontController->dispatch() in XenForo/FrontController.php at line 134
XenForo_FrontController->run() in /var/www/blahblah/blahblah/httpdocs/index.php at line 13
 
#6
Do guys have any idea what causes this? I run into this on our staging environment quite a bit, and it always worries me. Touch wood as yet it's not happened on live, but I'm struggling to do anything which can constantly reproduce the table crashing. I'll keep searching :)
 

Mike

XenForo developer
Staff member
#7
It is caused by MySQL not being shutdown properly or a hardware issue (causing writes to not happen correctly).