XF 1.4 Server error - Unable to post

[ineedhelp]

Hi

I need an urgent fix for the code below.

Thanks in advance.

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

 

[Paul B]

Rebuild the search index via the ACP.

 

[ineedhelp]

Rebuild the search index via the ACP.

This didn't work, still gives error.

The repair needs to be done in the database I think.

Can you tell me what I should do.

 

[Mike Edge]

This didn't work, still gives error.

The repair needs to be done in the database I think.

Can you tell me what I should do.

Try selecting all tables in phpMyAdmin and then use repair in the pull-down options menu.

 

[Mike]

This didn't work, still gives error.

You need to choose the option to the delete the index as well.

 

[Alan Hollis]

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]

It is caused by MySQL not being shutdown properly or a hardware issue (causing writes to not happen correctly).