Error, I dont know whats it :D

Yiit

Member
Me and all of the other members get this error while trying to post something on the forums. Anybody know why and how can I solve it?

Zend_Db_Statement_Mysqli_Exception: Mysqli prepare error: Table '.\tcraft\xf_search_index' is marked as crashed and should be repaired - library/Zend/Db/Statement/Mysqli.php:77

#0 /home/turkcraft.net/httpdocs/library/Zend/Db/Statement.php(115): Zend_Db_Statement_Mysqli->_prepare('DELETE FROM `xf...') #1 /home/turkcraft.net/httpdocs/library/Zend/Db/Adapter/Mysqli.php(381): Zend_Db_Statement->__construct(Object(Zend_Db_Adapter_Mysqli), 'DELETE FROM `xf...') #2 /home/turkcraft.net/httpdocs/library/Zend/Db/Adapter/Abstract.php(478): Zend_Db_Adapter_Mysqli->prepare('DELETE FROM `xf...') #3 /home/turkcraft.net/httpdocs/library/Zend/Db/Adapter/Abstract.php(661): Zend_Db_Adapter_Abstract->query('DELETE FROM `xf...') #4 /home/turkcraft.net/httpdocs/library/XenForo/Search/SourceHandler/MySqlFt.php(142): Zend_Db_Adapter_Abstract->delete('xf_search_index', 'content_type = ...') #5 /home/turkcraft.net/httpdocs/library/XenForo/Search/Indexer.php(105): XenForo_Search_SourceHandler_MySqlFt->deleteFromIndex('post', Array) #6 /home/turkcraft.net/httpdocs/library/XenForo/Search/DataHandler/Post.php(73): XenForo_Search_Indexer->deleteFromIndex('post', Array) #7 /home/turkcraft.net/httpdocs/library/XenForo/Search/DataHandler/Abstract.php(267): XenForo_Search_DataHandler_Post->_deleteFromIndex(Object(XenForo_Search_Indexer), Array) #8 /home/turkcraft.net/httpdocs/library/XenForo/DataWriter/DiscussionMessage.php(878): XenForo_Search_DataHandler_Abstract->deleteFromIndex(Object(XenForo_Search_Indexer), Array) #9 /home/turkcraft.net/httpdocs/library/XenForo/DataWriter/DiscussionMessage.php(738): XenForo_DataWriter_DiscussionMessage->_deleteFromSearchIndex() #10 /home/turkcraft.net/httpdocs/library/XenForo/DataWriter.php(1645): XenForo_DataWriter_DiscussionMessage->_postDelete() #11 /home/turkcraft.net/httpdocs/library/XenForo/Model/Post.php(982): XenForo_DataWriter->delete() #12 /home/turkcraft.net/httpdocs/library/XenForo/ControllerPublic/Post.php(245): XenForo_Model_Post->deletePost(3064, 'hard', Array) #13 /home/turkcraft.net/httpdocs/library/XenForo/FrontController.php(310): XenForo_ControllerPublic_Post->actionDelete() #14 /home/turkcraft.net/httpdocs/library/XenForo/FrontController.php(132): XenForo_FrontController->dispatch(Object(XenForo_RouteMatch)) #15 /home/turkcraft.net/httpdocs/index.php(13): XenForo_FrontController->run() #16 {main}
 

Brogan

XenForo moderator
Staff member
You need to repair the xf_search_index table.

You can do that using the MySQL Databases option in cPanel - click on the Repair DB button.

Alternatively you could truncate (empty) the table and rebuild the search index using the option in the ACP.
 

Yiit

Member
I dont use cPanel, I use Multi-Platform so I have no repair button on there. Can you explain the other alternative more deeply please? (Like where can I select that option in the ACP)

Also I'm having another 2 problem; One of them is:

ErrorException: Undefined variable: errno - library/Zend/Http/Client/Adapter/Socket.php:236

#0 /home/turkcraft.net/httpdocs/library/Zend/Http/Client/Adapter/Socket.php(236): XenForo_Application::handlePhpError(8, 'Undefined varia...', '/home/turkcraft...', 236, Array) #1 /home/turkcraft.net/httpdocs/library/Zend/Http/Client.php(973): Zend_Http_Client_Adapter_Socket->connect('www.gravatar.co...', 80, false) #2 /home/turkcraft.net/httpdocs/library/XenForo/Model/Avatar.php(452): Zend_Http_Client->request('HEAD') #3 /home/turkcraft.net/httpdocs/library/XenForo/ControllerPublic/Register.php(161): XenForo_Model_Avatar::gravatarExists('denizcetin_06@h...') #4 /home/turkcraft.net/httpdocs/library/XenForo/FrontController.php(310): XenForo_ControllerPublic_Register->actionRegister() #5 /home/turkcraft.net/httpdocs/library/XenForo/FrontController.php(132): XenForo_FrontController->dispatch(Object(XenForo_RouteMatch)) #6 /home/turkcraft.net/httpdocs/index.php(13): XenForo_FrontController->run() #7 {main}

And the other one:

Zend_Db_Adapter_Mysqli_Exception: Too many connections - library/Zend/Db/Adapter/Mysqli.php:333

#0 /home/turkcraft.net/httpdocs/library/Zend/Db/Adapter/Abstract.php(315): Zend_Db_Adapter_Mysqli->_connect() #1 /home/turkcraft.net/httpdocs/library/XenForo/Application.php(547): Zend_Db_Adapter_Abstract->getConnection() #2 [internal function]: XenForo_Application->loadDb(Object(Zend_Config)) #3 /home/turkcraft.net/httpdocs/library/XenForo/Application.php(774): call_user_func_array(Array, Array) #4 /home/turkcraft.net/httpdocs/library/XenForo/Application.php(804): XenForo_Application->lazyLoad('db', NULL) #5 /home/turkcraft.net/httpdocs/library/XenForo/Model.php(161): XenForo_Application::get('db') #6 /home/turkcraft.net/httpdocs/library/XenForo/Model/DataRegistry.php(138): XenForo_Model->_getDb() #7 /home/turkcraft.net/httpdocs/library/XenForo/Model/DataRegistry.php(97): XenForo_Model_DataRegistry->_getMultiFromDb(Array) #8 /home/turkcraft.net/httpdocs/library/XenForo/CssOutput.php(105): XenForo_Model_DataRegistry->getMulti(Array) #9 /home/turkcraft.net/httpdocs/library/XenForo/CssOutput.php(161): XenForo_CssOutput->_prepareForOutput() #10 /home/turkcraft.net/httpdocs/library/XenForo/CssOutput.php(521): XenForo_CssOutput->renderCss() #11 /home/turkcraft.net/httpdocs/css.php(12): XenForo_CssOutput::run() #12 {main}
 

Brogan

XenForo moderator
Staff member
Whichever application you used to create the database initially, there should be an option somewhere to repair it.
I'm not familiar with the system you use though.

Or as I said you will need to empty the table using e.g. phpMyAdmin and then recreate the search index in the ACP -> Tools -> Rebuild Caches

Your other issues seem to be server related.
Are you on a shared server? If so, it looks to be overloaded.
 

Yiit

Member
I did what you said and its solved. Thank you Brogan, you are REALLY awesome, I mean REALLY REALLY awesome. :)
 

Amphicar770

Active member
This same error recently occurred on my forums as well. Brogans instructions resolved the problem. Is there A bug in xenforo that is causing this?
 

Brogan

XenForo moderator
Staff member
A crashed table is usually related to server issues.

Bearing in mind how many XenForo forums have been operating for over a year without any problems, I think it's safe to assume it's not a bug with the software.
 
Top