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

XF 1.2 one of the threads on my forum doesn't load

jacko

Well-known member
#1
My website has been working without problems: www.dzwiek.org
and today one of the users reported he couldn't access a particular thread. I checked and I can't access it either:
http://dzwiek.org/threads/kpa-kemper-metal-profiles-sinmix.12100

it throws out this error:

Code:
An exception occurred: Mysqli prepare error: MySQL server has gone away in /home4/milaszew/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 825
Zend_Db_Adapter_Abstract->fetchOne() in XenForo/Error.php at line 55
XenForo_Error::unexpectedException() in XenForo/Application.php at line 363
XenForo_Application::handleException()
 

Brogan

XenForo moderator
Staff member
#2
The error is due to a timeout, which obviously shouldn't happen when loading a thread.

You may need to check in the database to see if there is anything unusual about that thread or the posts.
 

Mike

XenForo developer
Staff member
#4
Are you running 1.2.4? That error may be hiding the actual error (which is probably related) and I believe this issue is fixed in 1.2.4.

Otherwise, I would have to recommend disabling add-ons and attempting to reconfirm it.
 

jacko

Well-known member
#5
Are you running 1.2.4? That error may be hiding the actual error (which is probably related) and I believe this issue is fixed in 1.2.4.

Otherwise, I would have to recommend disabling add-ons and attempting to reconfirm it.
I just updated to 1.2.4 and it didn't fix it. I will investigate add-ons.
 

jacko

Well-known member
#8
Is it the same error?
Similar:

Code:
An exception occurred: Mysqli prepare error: MySQL server has gone away in /home4/milaszew/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 XenForo/Model.php at line 219
XenForo_Model->fetchAllKeyed() in LiamAds/Model/Adverts.php at line 17
LiamAds_Model_Adverts->getAllAds() in LiamAds/Addon.php at line 50
LiamAds_Addon::hook()
call_user_func_array() in XenForo/CodeEvent.php at line 58
XenForo_CodeEvent::fire() in XenForo/Template/Abstract.php at line 285
XenForo_Template_Abstract->callTemplateHook() in XenForo/Template/Abstract.php(265) : eval()'d code at line 1676
eval() in XenForo/Template/Abstract.php at line 265
XenForo_Template_Abstract->_renderInternal() in XenForo/Template/Abstract.php at line 191
XenForo_Template_Abstract->render() in XenForo/Template/Public.php at line 110
XenForo_Template_Public->render() in XenForo/ViewRenderer/HtmlPublic.php at line 119
XenForo_ViewRenderer_HtmlPublic->renderContainer() in XenForo/FrontController.php at line 614
XenForo_FrontController->renderView() in XenForo/FrontController.php at line 158
XenForo_FrontController->run() in /home4/milaszew/public_html/index.php at line 13
 

Mike

XenForo developer
Staff member
#9
This is showing that add-ons are still enabled. It's not definitive that it's the add-on in question causing it, because it's just trying to access the DB and the connection has been closed. (So the issue has happened before hand.)

However, it generally indicates that something is being very slow and not accessing the DB, thus causing a DB timeout. An add-on that fetches link titles could do this for example.

Disable all add-ons again please and reconfirm. (Include the back trace then.)
 

jacko

Well-known member
#10
This is showing that add-ons are still enabled. It's not definitive that it's the add-on in question causing it, because it's just trying to access the DB and the connection has been closed. (So the issue has happened before hand.)

However, it generally indicates that something is being very slow and not accessing the DB, thus causing a DB timeout. An add-on that fetches link titles could do this for example.

Disable all add-ons again please and reconfirm. (Include the back trace then.)
Now when I disabled add ons using config.php the thread is loading up fine.
How can I trace which add-on is causing the problem?
 

jacko

Well-known member
#12
With all add-ons disabled through config.php:

Code:
An exception occurred: Mysqli prepare error: MySQL server has gone away in /home4/milaszew/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 XenForo/Model.php at line 219
XenForo_Model->fetchAllKeyed() in XenForo/Model/Node.php at line 194
XenForo_Model_Node->getAllNodes() in XenForo/Model/Node.php at line 836
XenForo_Model_Node->getViewableNodeList() in UnreadPostCount/Callback.php at line 9
UnreadPostCount_Callback::getUnreadCount()
call_user_func() in XenForo/Template/Abstract.php at line 330
XenForo_Template_Abstract->callTemplateCallback() in XenForo/Template/Abstract.php(265) : eval()'d code at line 1096
eval() in XenForo/Template/Abstract.php at line 265
XenForo_Template_Abstract->_renderInternal() in XenForo/Template/Abstract.php at line 191
XenForo_Template_Abstract->render() in XenForo/Template/Public.php at line 110
XenForo_Template_Public->render() in XenForo/ViewRenderer/HtmlPublic.php at line 135
XenForo_ViewRenderer_HtmlPublic->renderContainer() in XenForo/FrontController.php at line 614
XenForo_FrontController->renderView() in XenForo/FrontController.php at line 158
XenForo_FrontController->run() in /home4/milaszew/public_html/index.php at line 13
 

Mike

XenForo developer
Staff member
#13
Add-ons are definitely not disabled in that last example.

You should disable all add-ons via the control panel and then enable them one by one until the large delay/error comes back.
 

jacko

Well-known member
#17
Do you have any caching enabled that is keeping the files in memory?
nope

It's just this one thread and the error comes up regardless the add-ons are enabled or disabled.
Other than that the site has worked without problems on that server since August.
 

jacko

Well-known member
#18
Another error:

Code:
An exception occurred: Mysqli prepare error: MySQL server has gone away in /home4/milaszew/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 808
Zend_Db_Adapter_Abstract->fetchPairs() in XenForo/Template/Public.php at line 130
XenForo_Template_Public->_getTemplatesFromDataSource() in XenForo/Template/Abstract.php at line 572
XenForo_Template_Abstract->_loadTemplates() in XenForo/Template/Abstract.php at line 556
XenForo_Template_Abstract->_loadTemplate() in XenForo/Template/Abstract.php at line 180
XenForo_Template_Abstract->render() in XenForo/Template/Public.php at line 110
XenForo_Template_Public->render() in XenForo/ViewRenderer/HtmlPublic.php at line 135
XenForo_ViewRenderer_HtmlPublic->renderContainer() in XenForo/FrontController.php at line 614
XenForo_FrontController->renderView() in XenForo/FrontController.php at line 158
XenForo_FrontController->run() in /home4/milaszew/public_html/index.php at line 13
anyone can try here of course: http://dzwiek.org/threads/kpa-kemper-metal-profiles-sinmix.12100