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

Error, I dont know whats it :D

#1
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
#2
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.
 
#3
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
#4
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.
 
#7
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
#8
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.