1. 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

Discussion in 'Troubleshooting and Problems' started by Yiit, Aug 2, 2011.

  1. Yiit

    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}
     
  2. Brogan

    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.
     
    racingtrader, leslie dow and Afra like this.
  3. Yiit

    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}
     
  4. Brogan

    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.
     
  5. Yiit

    Yiit Member

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

    Brogan XenForo Moderator Staff Member

    Birşey değil ;)
     
  7. Amphicar770

    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?
     
  8. Brogan

    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.
     

Share This Page