I'm getting DB errors when trying to post (VPS)(Bluehost)

[tekboi]

I recently ran out of space storage space with my DB client, causing my xenforo forum to crash. I've resolved the storage issue, but now i'm getting erros when I post.

Mysqli prepare error: Table './................../xf_search_index' is marked as crashed and should be repaired
[LIST=1]
[*]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 Tinhte/XenTag/XenForo/Search/DataHandler/Post.php at line 18
[*]Tinhte_XenTag_XenForo_Search_DataHandler_Post->_insertIntoIndex() in XenForo/Search/DataHandler/Abstract.php at line275
[*]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 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 745
[*]XenForo_ControllerPublic_Forum->actionAddThread() in Tinhte/XenTag/XenForo/ControllerPublic/Forum.php at line 28
[*]Tinhte_XenTag_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 /................................../index.php at line 13
[/LIST]

I'm new to dealing with Server Side and DB issues, so I would appreciate any guidance that I can get regarding this issue.

 

[Paul B]

You will need to either repair the xf_search_index table or truncate it and rebuild the search index.

 

[tekboi]

I was able to fix it using the phpadmin tool in my cPanel. Thanks for the guidance @Brogan.