1. 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

Discussion in 'Troubleshooting and Problems' started by Zwirc, Jul 19, 2012.

  1. Zwirc

    Zwirc Member

    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?
     
  2. Digital Doctor

    Digital Doctor Well-Known Member

  3. Zwirc

    Zwirc Member

  4. Digital Doctor

    Digital Doctor Well-Known Member

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

    CyclingTribe Well-Known Member

    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.
    
     
  6. CyclingTribe

    CyclingTribe Well-Known Member

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

    Zwirc Member

    One.com support:
     
  8. CyclingTribe

    CyclingTribe Well-Known Member

    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.
     
  9. Jake Bunce

    Jake Bunce XenForo Moderator Staff Member

    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

    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.
     
  10. Zwirc

    Zwirc Member

    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.
     
  11. Naatan

    Naatan Well-Known Member

    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.
     
  12. Zwirc

    Zwirc Member

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

    Zwirc Member

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

Share This Page