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

Mysqli errors while doing various things.

Discussion in 'Troubleshooting and Problems' started by Slavik, Nov 26, 2010.

  1. Slavik

    Slavik XenForo Moderator Staff Member

    Had someone inform me it was when they tried to post and another while trying to reply to a conversation, all turned up this morning.

    PHP:
    Error Info
    Zend_Db_Statement_Mysqli_Exception
    Mysqli statement execute error Prepared statement needs to be re-prepared library/Zend/Db/Statement/Mysqli.php:214
    Generated By
    Unknown Account27 minutes ago
    Stack Trace
    #0 /var/www/vhosts/koi-forums.com/httpdocs/library/Zend/Db/Statement.php(292): Zend_Db_Statement_Mysqli->_execute(Array)
    #1 /var/www/vhosts/koi-forums.com/httpdocs/library/Zend/Db/Adapter/Abstract.php(468): Zend_Db_Statement->execute(Array)
    #2 /var/www/vhosts/koi-forums.com/httpdocs/library/Zend/Db/Adapter/Abstract.php(782): Zend_Db_Adapter_Abstract->query('?????SELECT dat...', Array)
    #3 /var/www/vhosts/koi-forums.com/httpdocs/library/XenForo/Model/DataRegistry.php(144): Zend_Db_Adapter_Abstract->fetchPairs('?????SELECT dat...')
    #4 /var/www/vhosts/koi-forums.com/httpdocs/library/XenForo/Model/DataRegistry.php(97): XenForo_Model_DataRegistry->_getMultiFromDb(Array)
    #5 /var/www/vhosts/koi-forums.com/httpdocs/library/XenForo/Dependencies/Abstract.php(133): XenForo_Model_DataRegistry->getMulti(Array)
    #6 /var/www/vhosts/koi-forums.com/httpdocs/library/XenForo/FrontController.php(125): XenForo_Dependencies_Abstract->preLoadData()
    #7 /var/www/vhosts/koi-forums.com/httpdocs/index.php(15): XenForo_FrontController->run()
    #8 {main}
    Request State
    array(3) {
      [
    "url"] => string(81"[URL]http://www.koi-forums.com/index.php?conversations/your-company-sub-forum.4/unread[/URL]"
      
    ["_GET"] => array(1) {
        [
    "conversations/your-company-sub-forum_4/unread"] => string(0""
      
    }
      [
    "_POST"] => array(0) {
      }
    }

    PHP:
    Zend_Db_Statement_Mysqli_ExceptionMysqli statement execute error Prepared statement needs to be re-prepared library/Zend/Db/Statement/Mysqli.php:214
    Generated By
    Unknown Account26 minutes ago
    Stack Trace
    #0 /var/www/vhosts/koi-forums.com/httpdocs/library/Zend/Db/Statement.php(292): Zend_Db_Statement_Mysqli->_execute(Array)
    #1 /var/www/vhosts/koi-forums.com/httpdocs/library/Zend/Db/Adapter/Abstract.php(468): Zend_Db_Statement->execute(Array)
    #2 /var/www/vhosts/koi-forums.com/httpdocs/library/Zend/Db/Adapter/Abstract.php(782): Zend_Db_Adapter_Abstract->query('?????SELECT dat...', Array)
    #3 /var/www/vhosts/koi-forums.com/httpdocs/library/XenForo/Model/DataRegistry.php(144): Zend_Db_Adapter_Abstract->fetchPairs('?????SELECT dat...')
    #4 /var/www/vhosts/koi-forums.com/httpdocs/library/XenForo/Model/DataRegistry.php(97): XenForo_Model_DataRegistry->_getMultiFromDb(Array)
    #5 /var/www/vhosts/koi-forums.com/httpdocs/library/XenForo/Dependencies/Abstract.php(133): XenForo_Model_DataRegistry->getMulti(Array)
    #6 /var/www/vhosts/koi-forums.com/httpdocs/library/XenForo/FrontController.php(125): XenForo_Dependencies_Abstract->preLoadData()
    #7 /var/www/vhosts/koi-forums.com/httpdocs/index.php(15): XenForo_FrontController->run()
    #8 {main}
    Request State
    array(3) {
      [
    "url"] => string(37"[URL]http://www.koi-forums.com/favicon.ico[/URL]"
      
    ["_GET"] => array(0) {
      }
      [
    "_POST"] => array(0) {
      }
    }

    PHP:
    Error Info
    Zend_Db_Statement_Mysqli_Exception
    Mysqli statement execute error Prepared statement needs to be re-prepared library/Zend/Db/Statement/Mysqli.php:214
    Generated By
    Unknown Account23 minutes ago
    Stack Trace
    #0 /var/www/vhosts/koi-forums.com/httpdocs/library/Zend/Db/Statement.php(292): Zend_Db_Statement_Mysqli->_execute(Array)
    #1 /var/www/vhosts/koi-forums.com/httpdocs/library/Zend/Db/Adapter/Abstract.php(468): Zend_Db_Statement->execute(Array)
    #2 /var/www/vhosts/koi-forums.com/httpdocs/library/Zend/Db/Adapter/Abstract.php(782): Zend_Db_Adapter_Abstract->query('?????SELECT dat...', Array)
    #3 /var/www/vhosts/koi-forums.com/httpdocs/library/XenForo/Model/DataRegistry.php(144): Zend_Db_Adapter_Abstract->fetchPairs('?????SELECT dat...')
    #4 /var/www/vhosts/koi-forums.com/httpdocs/library/XenForo/Model/DataRegistry.php(97): XenForo_Model_DataRegistry->_getMultiFromDb(Array)
    #5 /var/www/vhosts/koi-forums.com/httpdocs/library/XenForo/Dependencies/Abstract.php(133): XenForo_Model_DataRegistry->getMulti(Array)
    #6 /var/www/vhosts/koi-forums.com/httpdocs/library/XenForo/FrontController.php(125): XenForo_Dependencies_Abstract->preLoadData()
    #7 /var/www/vhosts/koi-forums.com/httpdocs/index.php(15): XenForo_FrontController->run()
    #8 {main}
    Request State
    array(3) {
      [
    "url"] => string(35"[URL]http://www.koi-forums.com/index.php[/URL]"
      
    ["_GET"] => array(0) {
      }
      [
    "_POST"] => array(0) {
      }
    }


    PHP:
    Error Info
    Zend_Db_Statement_Mysqli_Exception
    Mysqli statement execute error Prepared statement needs to be re-prepared library/Zend/Db/Statement/Mysqli.php:214
    Generated By
    Unknown Account22 minutes ago
    Stack Trace
    #0 /var/www/vhosts/koi-forums.com/httpdocs/library/Zend/Db/Statement.php(292): Zend_Db_Statement_Mysqli->_execute(Array)
    #1 /var/www/vhosts/koi-forums.com/httpdocs/library/Zend/Db/Adapter/Abstract.php(468): Zend_Db_Statement->execute(Array)
    #2 /var/www/vhosts/koi-forums.com/httpdocs/library/Zend/Db/Adapter/Abstract.php(782): Zend_Db_Adapter_Abstract->query('?????SELECT dat...', Array)
    #3 /var/www/vhosts/koi-forums.com/httpdocs/library/XenForo/Model/DataRegistry.php(144): Zend_Db_Adapter_Abstract->fetchPairs('?????SELECT dat...')
    #4 /var/www/vhosts/koi-forums.com/httpdocs/library/XenForo/Model/DataRegistry.php(97): XenForo_Model_DataRegistry->_getMultiFromDb(Array)
    #5 /var/www/vhosts/koi-forums.com/httpdocs/library/XenForo/Dependencies/Abstract.php(133): XenForo_Model_DataRegistry->getMulti(Array)
    #6 /var/www/vhosts/koi-forums.com/httpdocs/library/XenForo/FrontController.php(125): XenForo_Dependencies_Abstract->preLoadData()
    #7 /var/www/vhosts/koi-forums.com/httpdocs/index.php(15): XenForo_FrontController->run()
    #8 {main}
    Request State
    array(3) {
      [
    "url"] => string(35"[URL]http://www.koi-forums.com/index.php[/URL]"
      
    ["_GET"] => array(0) {
      }
      [
    "_POST"] => array(0) {
      }
    }


    PHP:
    Error Info
    Zend_Db_Statement_Mysqli_Exception
    Mysqli statement execute error Prepared statement needs to be re-prepared library/Zend/Db/Statement/Mysqli.php:214
    Generated By
    Unknown Account20 minutes ago
    Stack Trace
    #0 /var/www/vhosts/koi-forums.com/httpdocs/library/Zend/Db/Statement.php(292): Zend_Db_Statement_Mysqli->_execute(Array)
    #1 /var/www/vhosts/koi-forums.com/httpdocs/library/Zend/Db/Adapter/Abstract.php(468): Zend_Db_Statement->execute(Array)
    #2 /var/www/vhosts/koi-forums.com/httpdocs/library/Zend/Db/Adapter/Abstract.php(782): Zend_Db_Adapter_Abstract->query('?????SELECT dat...', Array)
    #3 /var/www/vhosts/koi-forums.com/httpdocs/library/XenForo/Model/DataRegistry.php(144): Zend_Db_Adapter_Abstract->fetchPairs('?????SELECT dat...')
    #4 /var/www/vhosts/koi-forums.com/httpdocs/library/XenForo/Model/DataRegistry.php(97): XenForo_Model_DataRegistry->_getMultiFromDb(Array)
    #5 /var/www/vhosts/koi-forums.com/httpdocs/library/XenForo/Dependencies/Abstract.php(133): XenForo_Model_DataRegistry->getMulti(Array)
    #6 /var/www/vhosts/koi-forums.com/httpdocs/library/XenForo/FrontController.php(125): XenForo_Dependencies_Abstract->preLoadData()
    #7 /var/www/vhosts/koi-forums.com/httpdocs/index.php(15): XenForo_FrontController->run()
    #8 {main}
    Request State
    array(3) {
      [
    "url"] => string(35"[URL]http://www.koi-forums.com/index.php[/URL]"
      
    ["_GET"] => array(0) {
      }
      [
    "_POST"] => array(0) {
      }
    }

     
  2. Mike

    Mike XenForo Developer Staff Member

    Kier has had this happen a couple times locally, and we had one other report of it. As far as I can tell, it seems like a MySQL bug as the documented circumstances for it really should never happen. (Each error is coming from the same query.) I'm not sure what to suggest, though it seems like it might be ok now as I can load your site.

    Do you know your MySQL version, BTW?
     
  3. Slavik

    Slavik XenForo Moderator Staff Member

    5.1.49
     
  4. Slavik

    Slavik XenForo Moderator Staff Member

    Error Showed up this morning also. My other vbulletin run forums seemed fine, but these ones were totally offline for 5 mins or so.

    PHP:

    Error Info
    Zend_Db_Statement_Mysqli_Exception
    Mysqli statement execute error Prepared statement needs to be re-prepared library/Zend/Db/Statement/Mysqli.php:214
    Generated By
    Unknown Account6 minutes ago
    Stack Trace
    #0 /var/www/vhosts/koi-forums.com/httpdocs/library/Zend/Db/Statement.php(292): Zend_Db_Statement_Mysqli->_execute(Array)
    #1 /var/www/vhosts/koi-forums.com/httpdocs/library/Zend/Db/Adapter/Abstract.php(468): Zend_Db_Statement->execute(Array)
    #2 /var/www/vhosts/koi-forums.com/httpdocs/library/Zend/Db/Adapter/Abstract.php(782): Zend_Db_Adapter_Abstract->query('?????SELECT dat...', Array)
    #3 /var/www/vhosts/koi-forums.com/httpdocs/library/XenForo/Model/DataRegistry.php(144): Zend_Db_Adapter_Abstract->fetchPairs('?????SELECT dat...')
    #4 /var/www/vhosts/koi-forums.com/httpdocs/library/XenForo/Model/DataRegistry.php(97): XenForo_Model_DataRegistry->_getMultiFromDb(Array)
    #5 /var/www/vhosts/koi-forums.com/httpdocs/library/XenForo/Dependencies/Abstract.php(133): XenForo_Model_DataRegistry->getMulti(Array)
    #6 /var/www/vhosts/koi-forums.com/httpdocs/library/XenForo/FrontController.php(125): XenForo_Dependencies_Abstract->preLoadData()
    #7 /var/www/vhosts/koi-forums.com/httpdocs/admin.php(13): XenForo_FrontController->run()
    #8 {main}
    Request State
    array(3) {
    [
    "url"] => string(50"http://www.koi-forums.com/admin.php?nodes/&last=34"
    ["_GET"] => array(2) {
    [
    "nodes/"] => string(0""    ["last"] => string(2"34"
    }
    [
    "_POST"] => array(0) {
    }
    }
    PHP:

    Error Info
    Zend_Db_Statement_Mysqli_Exception
    Mysqli statement execute error Prepared statement needs to be re-prepared library/Zend/Db/Statement/Mysqli.php:214
    Generated By
    Unknown Account12 minutes ago
    Stack Trace
    #0 /var/www/vhosts/koi-forums.com/httpdocs/library/Zend/Db/Statement.php(292): Zend_Db_Statement_Mysqli->_execute(Array)
    #1 /var/www/vhosts/koi-forums.com/httpdocs/library/Zend/Db/Adapter/Abstract.php(468): Zend_Db_Statement->execute(Array)
    #2 /var/www/vhosts/koi-forums.com/httpdocs/library/Zend/Db/Adapter/Abstract.php(725): Zend_Db_Adapter_Abstract->query('????SELECT node...', 25)
    #3 /var/www/vhosts/koi-forums.com/httpdocs/library/XenForo/Model/Forum.php(29): Zend_Db_Adapter_Abstract->fetchRow('????SELECT node...', 25)
    #4 /var/www/vhosts/koi-forums.com/httpdocs/library/XenForo/ControllerHelper/ForumThreadPost.php(175): XenForo_Model_Forum->getForumById(25, Array)
    #5 /var/www/vhosts/koi-forums.com/httpdocs/library/XenForo/ControllerHelper/ForumThreadPost.php(38): XenForo_ControllerHelper_ForumThreadPost->getForumOrError(25, Array)
    #6 /var/www/vhosts/koi-forums.com/httpdocs/library/XenForo/ControllerPublic/Forum.php(31): XenForo_ControllerHelper_ForumThreadPost->assertForumValidAndViewable(25, Array)
    #7 /var/www/vhosts/koi-forums.com/httpdocs/library/XenForo/FrontController.php(303): XenForo_ControllerPublic_Forum->actionIndex()
    #8 /var/www/vhosts/koi-forums.com/httpdocs/library/XenForo/FrontController.php(132): XenForo_FrontController->dispatch(Object(XenForo_RouteMatch)) #9 /var/www/vhosts/koi-forums.com/httpdocs/index.php(15): XenForo_FrontController->run()
    #10 {main}
    Request State
    array(3) {
    [
    "url"] => string(59"http://www.koi-forums.com/index.php?forums/cdh-software.25/"
    ["_GET"] => array(1) {
    [
    "forums/cdh-software_25/"] => string(0""
    }
    [
    "_POST"] => array(0) {
    }
     } 
    PHP:

    Error Info
    Zend_Db_Statement_Mysqli_Exception
    Mysqli statement execute error Prepared statement needs to be re-prepared library/Zend/Db/Statement/Mysqli.php:214
    Generated By
    Unknown Account16 minutes ago
    Stack Trace
    #0 /var/www/vhosts/koi-forums.com/httpdocs/library/Zend/Db/Statement.php(292): Zend_Db_Statement_Mysqli->_execute(Array)
    #1 /var/www/vhosts/koi-forums.com/httpdocs/library/Zend/Db/Adapter/Abstract.php(468): Zend_Db_Statement->execute(Array)
    #2 /var/www/vhosts/koi-forums.com/httpdocs/library/XenForo/Model.php(218): Zend_Db_Adapter_Abstract->query('?????SELECT *??...', Array, 2)
    #3 /var/www/vhosts/koi-forums.com/httpdocs/library/XenForo/Model/Node.php(178): XenForo_Model->fetchAllKeyed('?????SELECT *??...', 'node_id')
    #4 /var/www/vhosts/koi-forums.com/httpdocs/library/XenForo/Model/Node.php(715): XenForo_Model_Node->getAllNodes(false, true)
    #5 /var/www/vhosts/koi-forums.com/httpdocs/library/XenForo/ControllerPublic/Index.php(28): XenForo_Model_Node->getNodeDataForListDisplay(false, 0)
    #6 /var/www/vhosts/koi-forums.com/httpdocs/library/XenForo/FrontController.php(303): XenForo_ControllerPublic_Index->actionIndex()
    #7 /var/www/vhosts/koi-forums.com/httpdocs/library/XenForo/FrontController.php(132): XenForo_FrontController->dispatch(Object(XenForo_RouteMatch))
    #8 /var/www/vhosts/koi-forums.com/httpdocs/index.php(15): XenForo_FrontController->run()
    #9 {main}
    Request State
    array(3) {
    [
    "url"] => string(35) [URL]http://www.koi-forums.com/index.php[/URL]
    ["_GET"] => array(0) {
    }
    [
    "_POST"] => array(0) {
    }
    }
    Each error shows up twice, but thats all I have, theres no server side generated error logs to correspond to these ones generated by Xenforo. Any suggestions?
     
  5. Mike

    Mike XenForo Developer Staff Member

    Is it happening at a standard time of the day? If so, it sounds like there's something going on with your server at that point -- perhaps backups? Unfortunately, there's not a lot we can do to prevent it. It's being triggered by MySQL, and it can come from any query.
     
  6. Slavik

    Slavik XenForo Moderator Staff Member

    Updating this.

    My cron tasks have myseriously moved 5 hours into the day, this was causing the errors. Now resolved.
     

Share This Page