MySQL error after host Mysql update

[Zwirc]

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:

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:

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?

 

[Digital Doctor]

Anyway to repair?

Open a ticket.
This might be tough to fix.

It's a Xenforo thing.

LMGTFY

http://xenforo.com/community/thread...ared-statement-needs-to-be-re-prepared.25579/

 

[Zwirc]

Open a ticket.
This might be tough to fix.

It's a Xenforo thing.

LMGTFY

http://xenforo.com/community/thread...ared-statement-needs-to-be-re-prepared.25579/

Thank you for fast answear. Happened after my webhost updated their server, so thought it was their fault.
Tried to google, but you know what to google, tnx

 

[Digital Doctor]

Try some of those Google suggestions.
The google search for this error has lots of Xenforo hits

 

[CTXMedia]

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

Especially at the end bit, here:

[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]

table_definition_cache in particular is mentioned in other docs I found too.

 

[Zwirc]

One.com support:

Oh I'm sorry but this cannot be editted.

 

[CTXMedia]

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.

Hope you get it sorted.

 

[Jake Bunce]

I once searched for information about this error. I found the same information as Clickfinity:

http://xenforo.com/community/threads/error-on-install.17901/#post-236565

One.com support:

Oh I'm sorry but this cannot be editted.

Shared server? I would ask them to escalate your ticket. This is a problem with their MySQL configuration that really should be addressed. On a shared server the web host is the only one that can fix this.

 

[Zwirc]

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]

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.

 

[Zwirc]

Thank you.
Well, I have a dedicated server to.
Maby I just forward the DNS and put up an apache server there.

 

[Zwirc]

Thanks for help guys,
I just moved it to the dedicated server, and since its easy to move Xenforo I sorted it out.