XF 1.4 Probelm with conversations

[gavpeds]

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

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

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

 

[Paul B]

Disable all add-ons and test again.

 

[gavpeds]

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

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

 

[Mike]

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.

 

[gavpeds]

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?