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

MySQL error after host Mysql update

#1
Hi!

I had problems with loading my site for 10 days now.
My host was looking in to it, but they do not have any answear to me yet.

So i tried to update to 1.1.3, but it crashes when i press "upgrade"

The webhost is one.com and the error is:

Code:
Mysqli statement execute error : Prepared statement needs to be
re-prepared
 
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 Zend/Db/Adapter/Abstract.php at
line 753
Zend_Db_Adapter_Abstract->fetchRow() in XenForo/Model/Option.php at line
230
XenForo_Model_Option->getOptionById() in XenForo/DataWriter/Option.php
at line 146
XenForo_DataWriter_Option->_verifyOptionId()
call_user_func_array() in XenForo/DataWriter.php at line 965
XenForo_DataWriter->_runVerificationCallback() in XenForo/DataWriter.php
at line 720
XenForo_DataWriter->_isFieldValueValid() in XenForo/DataWriter.php at
line 638
XenForo_DataWriter->set() in XenForo/DataWriter.php at line 978
XenForo_DataWriter->bulkSet() in XenForo/Model/Option.php at line 1079
XenForo_Model_Option->importOptionsAddOnXml() in
XenForo/Model/Option.php at line 1007
XenForo_Model_Option->importOptionsDevelopmentXml() in
XenForo/CacheRebuilder/ImportMasterData.php at line 40
XenForo_CacheRebuilder_ImportMasterData->rebuild() in
XenForo/ControllerHelper/CacheRebuild.php at line 26
XenForo_ControllerHelper_CacheRebuild->rebuildCache() in
XenForo/Install/Controller/Upgrade.php at line 232
XenForo_Install_Controller_Upgrade->actionRebuild() in
XenForo/FrontController.php at line 310
XenForo_FrontController->dispatch() in XenForo/FrontController.php at
line 132
XenForo_FrontController->run() in
/customers/9/9/e/*mydomain*/httpd.www/install/index.php at line 18
The other error is:
Code:
Server Error
 
Mysqli statement execute error : Prepared statement needs to be re-prepared
 
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 Zend/Db/Adapter/Abstract.php at line 825
Zend_Db_Adapter_Abstract->fetchOne() in XenForo/Session.php at line 625
XenForo_Session->getSessionFromSource() in XenForo/Session.php at line 360
XenForo_Session->_setup() in XenForo/Session.php at line 344
XenForo_Session->start() in XenForo/Session.php at line 246
XenForo_Session::getPublicSession() in XenForo/Session.php at line 187
XenForo_Session::startPublicSession() in XenForo/Controller.php at line 286
XenForo_Controller->_setupSession() in XenForo/Controller.php at line 298
XenForo_Controller->preDispatch() in XenForo/FrontController.php at line 309
XenForo_FrontController->dispatch() in XenForo/FrontController.php at line 132
XenForo_FrontController->run() in /customers/9/9/e/*mydomain*/httpd.www/index.php at line 13

Maby anyone in here could help me?

The error I got before this was Zend errors, but now i get this.
Anyway to repair?
 

CTXMedia

Formerly CyclingTribe
#5
Have a look here: http://bugs.mysql.com/bug.php?id=42041

Especially at the end bit, here:

Code:
[27 Feb 23:49] Derek Hemmes
Peter,

Not sure if this helps, but we seemed to solve the issue on our servers by changing some db settings.

table_open_cache 128=>16384
table_definition_cache 1024=>16384
tmp_table_size 32M=>64M
join_buffer_size 256k=>512k
[28 Feb 10:30] Pete Walker
Thanks for that Derek, it does appear to have helped. Not seeing the error at all now.
 

CTXMedia

Formerly CyclingTribe
#8
If you haven't already, it may be worth opening a ticket here at XF - the devs may be able to fix it for you. (y)

Hope you get it sorted.
 

Jake Bunce

XenForo moderator
Staff member
#9
#10
XF devs could not help, created ticket.

Jake: Tnx, dunno what you "shared server" would say.
I have one of those webhotels from www.one.com

Asked X times on their live support and they created a ticket for technicians 2 weeks ago, but still no results. :/

Im kind of stuck here.
 

Naatan

Well-known member
#11
Shared hosts means you are sharing your server with hundreds of other clients, that's why it's so cheap.

Besides the low level of support you get at a shared host you also have to deal with very irregular server performance, which for me was the primary reason to start looking for alternatives way back when.

I'd highly recommend spending a bit more and getting a managed vps solution, I personally use ServInt and they do an amazing job, an issue like yours would be resolved within 20 minutes.

You get the service you pay for.