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

XF 1.5 Server Error with Tables?

Daphonic

Active member
#1
I'm getting this Error, what do I need to do to Fix this? It's happening on all my forums, when you try to reply or edit.

Server Error

Mysqli prepare error: Table './lethalitygaming_forums/xf_search_index' is marked as crashed and should be repaired

  1. Zend_Db_Statement_Mysqli->_prepare() in Zend/Db/Statement.php at line 115
  2. Zend_Db_Statement->__construct() in Zend/Db/Adapter/Mysqli.php at line 381
  3. Zend_Db_Adapter_Mysqli->prepare() in Zend/Db/Adapter/Abstract.php at line 478
  4. Zend_Db_Adapter_Abstract->query() in Zend/Db/Adapter/Abstract.php at line 661
  5. Zend_Db_Adapter_Abstract->delete() in XenForo/Search/SourceHandler/MySqlFt.php at line 170
  6. XenForo_Search_SourceHandler_MySqlFt->deleteFromIndex() in XenForo/Search/Indexer.php at line 105
  7. XenForo_Search_Indexer->deleteFromIndex() in XenForo/Search/DataHandler/Post.php at line 99
  8. XenForo_Search_DataHandler_Post->_deleteFromIndex() in XenForo/Search/DataHandler/Abstract.php at line 315
  9. XenForo_Search_DataHandler_Abstract->deleteFromIndex() in XenForo/DataWriter/DiscussionMessage.php at line 986
  10. XenForo_DataWriter_DiscussionMessage->_deleteFromSearchIndex() in XenForo/DataWriter/DiscussionMessage.php at line 847
  11. XenForo_DataWriter_DiscussionMessage->_postDelete() in XenForo/DataWriter.php at line 1793
  12. XenForo_DataWriter->delete() in XenForo/Model/InlineMod/Post.php at line 125
  13. XenForo_Model_InlineMod_Post->deletePosts() in XenForo/ControllerPublic/InlineMod/Abstract.php at line 125
  14. XenForo_ControllerPublic_InlineMod_Abstract->executeInlineModAction() in XenForo/ControllerPublic/InlineMod/Post.php at line 56
  15. XenForo_ControllerPublic_InlineMod_Post->actionDelete() in XenForo/FrontController.php at line 351
  16. XenForo_FrontController->dispatch() in XenForo/FrontController.php at line 134
  17. XenForo_FrontController->run() in /home/lethalitygaming/lethalitygaming/index.php at line 13
 

wang

Well-known member
#2
Repair the xf_search_index table and it should fix the problem. If it happens on a regular basis, it would be a good idea to talk to your host about it.
 

wang

Well-known member
#4
You can select that table from phpmyadmin and then click the Repair options from the list of options. Or you can run this query too:
Code:
REPAIR TABLE xf_search_index;