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

XF 1.4 Probelm with conversations

Discussion in 'Troubleshooting and Problems' started by gavpeds, Sep 16, 2014.

  1. gavpeds

    gavpeds Active Member

    I am getting this error when users try to start a conversation. sometimes they get it right after clicking the link to start a conversation. Sometimes they get it on trying to submit it.

    This is the code they get right after clicking start conversation
    Code:
    An exception occurred: Mysqli statement execute error : Lost connection to MySQL server during query in /home/window/public_html/library/Zend/Db/Statement/Mysqli.php on line 214
    
    Zend_Db_Statement_Mysqli->_execute() in Zend/Db/Statement.php at line 297
    Zend_Db_Statement->execute() in Zend/Db/Adapter/Abstract.php at line 479
    Zend_Db_Adapter_Abstract->query() in XenForo/Model/DataRegistry.php at line 164
    XenForo_Model_DataRegistry->set() in WidgetFramework/Model/Cache.php at line 118
    WidgetFramework_Model_Cache->_set() in WidgetFramework/Model/Cache.php at line 69
    WidgetFramework_Model_Cache->setCachedWidgets() in WidgetFramework/Model/Cache.php at line 233
    WidgetFramework_Model_Cache->setLiveCache() in WidgetFramework/Core.php at line 576
    WidgetFramework_Core->_saveCachedWidget() in WidgetFramework/Core.php at line 625
    WidgetFramework_Core::saveCachedWidget() in WidgetFramework/WidgetRenderer.php at line 546
    WidgetFramework_WidgetRenderer->_acquireLock() in WidgetFramework/WidgetRenderer.php at line 646
    WidgetFramework_WidgetRenderer->render() in WidgetFramework/Core.php at line 397
    WidgetFramework_Core->_renderWidgetsFor() in WidgetFramework/Core.php at line 316
    WidgetFramework_Core->renderWidgetsFor() in WidgetFramework/Listener.php at line 126
    WidgetFramework_Listener::template_post_render()
    call_user_func_array() in XenForo/CodeEvent.php at line 58
    XenForo_CodeEvent::fire() in XenForo/Template/Abstract.php at line 195
    XenForo_Template_Abstract->render() in XenForo/Template/Public.php at line 110
    XenForo_Template_Public->render() in XenForo/ViewRenderer/HtmlPublic.php at line 123
    XenForo_ViewRenderer_HtmlPublic->renderContainer() in XenForo/FrontController.php at line 618
    XenForo_FrontController->renderView() in XenForo/FrontController.php at line 158
    XenForo_FrontController->run() in /home/window/public_html/index.php at line 13
    This is the code they get on trying to send a conversation message
    Code:
    An exception occurred: Mysqli prepare error: MySQL server has gone away in /home/window/public_html/library/Zend/Db/Statement/Mysqli.php on line 77
    
    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 Zend/Db/Adapter/Abstract.php at line 734
    Zend_Db_Adapter_Abstract->fetchAll() in NodesAsTabs/Model/Options.php at line 43
    NodesAsTabs_Model_Options->getJoinedOptionsForNav() in NodesAsTabs/NavTabs.php at line 25
    NodesAsTabs_NavTabs::createNodeTabs()
    call_user_func_array() in XenForo/CodeEvent.php at line 90
     
  2. Brogan

    Brogan XenForo Moderator Staff Member

    Disable all add-ons and test again.
     
  3. gavpeds

    gavpeds Active Member

    Disabled all ad ons and still get this. The only ad ons i have added recently is post ratings and smilies manager.

    Code:
    Mysqli prepare error: Lost connection to MySQL server during query
    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 Zend/Db/Adapter/Abstract.php at line 574
    Zend_Db_Adapter_Abstract->insert() in XenForo/DataWriter.php at line 1624
    XenForo_DataWriter->_insert() in XenForo/DataWriter.php at line 1613
    XenForo_DataWriter->_save() in XenForo/DataWriter.php at line 1405
    XenForo_DataWriter->save() in XenForo/DataWriter/ConversationMaster.php at line 331
    XenForo_DataWriter_ConversationMaster->_postSave() in XenForo/DataWriter.php at line 1409
    XenForo_DataWriter->save() in XenForo/ControllerPublic/Conversation.php at line 623
    XenForo_ControllerPublic_Conversation->actionInsert() in XenForo/FrontController.php at line 347
    XenForo_FrontController->dispatch() in XenForo/FrontController.php at line 134
    XenForo_FrontController->run() in /home/window/public_html/index.php at line 13
     
  4. Mike

    Mike XenForo Developer Staff Member

    These are happening at very inconsistent times (as in, the errors are all completely different places). This would indicate something like network connectivity issues or high load/resource contention:

    http://dev.mysql.com/doc/refman/5.0/en/error-lost-connection.html

    Your host would be the only one who could look into it.
     
  5. gavpeds

    gavpeds Active Member

    Thanks the odd thing is that we can post threads and replies fine and the site seems to be running fine its only the conversations that are throwing the errors maybe a specific table that is causing it?
     

Share This Page