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

XF 1.2 Few server errors after upgrade

Discussion in 'Installation, Upgrade, and Import Support' started by dabollicks, Jun 23, 2013.

  1. dabollicks

    dabollicks Active Member

    Im trying to test things out before i upgrade my live site, so i made a copy of my database, currently running 1.1.5, previously imported from vB 4.2

    I uploaded the upgrade files for 1.2 beta and the upgrade went smoother than a smooth thing, although i now getting a list of errors in the ACP

    Code:
    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 Account, Today at 12:00 AM
    Stack Trace
    #0 /home/rossmc/public_html/local-footy.co.uk/library/Zend/Db/Statement.php(297): Zend_Db_Statement_Mysqli->_execute(Array)
    #1 /home/rossmc/public_html/local-footy.co.uk/library/Zend/Db/Adapter/Abstract.php(479): Zend_Db_Statement->execute(Array)
    #2 /home/rossmc/public_html/local-footy.co.uk/library/Zend/Db/Adapter/Abstract.php(808): Zend_Db_Adapter_Abstract->query('????SELECT data...', Array)
    #3 /home/rossmc/public_html/local-footy.co.uk/library/XenForo/Model/DataRegistry.php(144): Zend_Db_Adapter_Abstract->fetchPairs('????SELECT data...')
    #4 /home/rossmc/public_html/local-footy.co.uk/library/XenForo/Model/DataRegistry.php(97): XenForo_Model_DataRegistry->_getMultiFromDb(Array)
    #5 /home/rossmc/public_html/local-footy.co.uk/library/XenForo/Dependencies/Abstract.php(134): XenForo_Model_DataRegistry->getMulti(Array)
    #6 /home/rossmc/public_html/local-footy.co.uk/library/XenForo/FrontController.php(125): XenForo_Dependencies_Abstract->preLoadData()
    #7 /home/rossmc/public_html/local-footy.co.uk/index.php(13): XenForo_FrontController->run()
    #8 {main}
    Request State
    array(3) {
      ["url"] => string(76) "http://www.local-footy.co.uk/showthread.php/7569-Whittlesea-10-v-PSL?p=46356"
      ["_GET"] => array(1) {
        ["p"] => string(5) "46356"
      }
      ["_POST"] => array(0) {
      }
    }
    Theres 5 of these in total, all with a different thread

    Im also getting these errors
    Code:
    Zend_Db_Statement_Mysqli_Exception: Mysqli prepare error: Table 'XXXXXX.vb_helpfulanswer' doesn't exist - library/Zend/Db/Statement/Mysqli.php:77
    Generated By: administrator, Jun 13, 2013
    Stack Trace
    #0 /home/rossmc/public_html/local-footy.co.uk/library/Zend/Db/Statement.php(115): Zend_Db_Statement_Mysqli->_prepare('?              ...')
    #1 /home/rossmc/public_html/local-footy.co.uk/library/Zend/Db/Adapter/Mysqli.php(381): Zend_Db_Statement->__construct(Object(Zend_Db_Adapter_Mysqli), '?              ...')
    #2 /home/rossmc/public_html/local-footy.co.uk/library/Zend/Db/Adapter/Abstract.php(478): Zend_Db_Adapter_Mysqli->prepare('?              ...')
    #3 /home/rossmc/public_html/local-footy.co.uk/library/Zend/Db/Adapter/Abstract.php(825): Zend_Db_Adapter_Abstract->query('?              ...', Array)
    #4 /home/rossmc/public_html/local-footy.co.uk/library/XenForo/Importer/myvbulletin4.php(347): Zend_Db_Adapter_Abstract->fetchOne('?              ...')
    #5 /home/rossmc/public_html/local-footy.co.uk/library/XenForo/Importer/Abstract.php(77): XenForo_Importer_myvBulletin4->stepPostLikes(0, Array)
    #6 /home/rossmc/public_html/local-footy.co.uk/library/XenForo/ControllerAdmin/Import.php(180): XenForo_Importer_Abstract->runStep(Object(XenForo_ControllerAdmin_Import), Object(XenForo_ImportSession), 'postLikes', 0, Array)
    #7 /home/rossmc/public_html/local-footy.co.uk/library/XenForo/ControllerAdmin/Import.php(232): XenForo_ControllerAdmin_Import->_runStep(Object(XenForo_Importer_myvBulletin4), Object(XenForo_ImportSession), 'postLikes', 0, Array)
    #8 /home/rossmc/public_html/local-footy.co.uk/library/XenForo/ControllerAdmin/Import.php(175): XenForo_ControllerAdmin_Import->_startStep(Object(XenForo_Importer_myvBulletin4), Object(XenForo_ImportSession), 'postLikes', Array)
    #9 /home/rossmc/public_html/local-footy.co.uk/library/XenForo/FrontController.php(310): XenForo_ControllerAdmin_Import->actionStartStep()
    #10 /home/rossmc/public_html/local-footy.co.uk/library/XenForo/FrontController.php(132): XenForo_FrontController->dispatch(Object(XenForo_RouteMatch))
    #11 /home/rossmc/public_html/local-footy.co.uk/admin.php(13): XenForo_FrontController->run()
    #12 {main}
    Request State
    array(3) {
      ["url"] => string(56) "http://www.local-footy.co.uk/admin.php?import/start-step"
      ["_GET"] => array(1) {
        ["import/start-step"] => string(0) ""
      }
      ["_POST"] => array(2) {
        ["step_postLikes"] => string(17) "Import Post Likes"
        ["_xfToken"] => string(53) "1,1371111238,586ee3772d227bf9b95e5b11a7b39627aa0bc440"
      }
    }
    and this one

    Code:
    Zend_Db_Statement_Mysqli_Exception: Mysqli prepare error: Table 'XXXXXX.vb_post_thanks' doesn't exist - library/Zend/Db/Statement/Mysqli.php:77
    Generated By: administrator, Jun 13, 2013
    Stack Trace
    #0 /home/rossmc/public_html/local-footy.co.uk/library/Zend/Db/Statement.php(115): Zend_Db_Statement_Mysqli->_prepare('?              ...')
    #1 /home/rossmc/public_html/local-footy.co.uk/library/Zend/Db/Adapter/Mysqli.php(381): Zend_Db_Statement->__construct(Object(Zend_Db_Adapter_Mysqli), '?              ...')
    #2 /home/rossmc/public_html/local-footy.co.uk/library/Zend/Db/Adapter/Abstract.php(478): Zend_Db_Adapter_Mysqli->prepare('?              ...')
    #3 /home/rossmc/public_html/local-footy.co.uk/library/Zend/Db/Adapter/Abstract.php(825): Zend_Db_Adapter_Abstract->query('?              ...', Array)
    #4 /home/rossmc/public_html/local-footy.co.uk/library/XenForo/Importer/myvbulletin4.php(265): Zend_Db_Adapter_Abstract->fetchOne('?              ...')
    #5 /home/rossmc/public_html/local-footy.co.uk/library/XenForo/Importer/Abstract.php(77): XenForo_Importer_myvBulletin4->stepPostThanks(0, Array)
    #6 /home/rossmc/public_html/local-footy.co.uk/library/XenForo/ControllerAdmin/Import.php(180): XenForo_Importer_Abstract->runStep(Object(XenForo_ControllerAdmin_Import), Object(XenForo_ImportSession), 'postThanks', 0, Array)
    #7 /home/rossmc/public_html/local-footy.co.uk/library/XenForo/ControllerAdmin/Import.php(232): XenForo_ControllerAdmin_Import->_runStep(Object(XenForo_Importer_myvBulletin4), Object(XenForo_ImportSession), 'postThanks', 0, Array)
    #8 /home/rossmc/public_html/local-footy.co.uk/library/XenForo/ControllerAdmin/Import.php(175): XenForo_ControllerAdmin_Import->_startStep(Object(XenForo_Importer_myvBulletin4), Object(XenForo_ImportSession), 'postThanks', Array)
    #9 /home/rossmc/public_html/local-footy.co.uk/library/XenForo/FrontController.php(310): XenForo_ControllerAdmin_Import->actionStartStep()
    #10 /home/rossmc/public_html/local-footy.co.uk/library/XenForo/FrontController.php(132): XenForo_FrontController->dispatch(Object(XenForo_RouteMatch))
    #11 /home/rossmc/public_html/local-footy.co.uk/admin.php(13): XenForo_FrontController->run()
    #12 {main}
    Request State
    array(3) {
      ["url"] => string(56) "http://www.local-footy.co.uk/admin.php?import/start-step"
      ["_GET"] => array(1) {
        ["import/start-step"] => string(0) ""
      }
      ["_POST"] => array(2) {
        ["step_postThanks"] => string(18) "Import Post Thanks"
        ["_xfToken"] => string(53) "1,1371111238,586ee3772d227bf9b95e5b11a7b39627aa0bc440"
      }
    }
    Any ideas folks?

    Thanks
     
  2. Mike

    Mike XenForo Developer Staff Member

    You should note the dates on these - the bottom 2 were triggered during your import.

    The top one is a MySQL issue. It seems to be a bug in a very specific MySQL version. Upgrading MySQL may fix it. Otherwise, it may go away on its own. If it doesn't, restarting MySQL can work around it.
     
  3. dabollicks

    dabollicks Active Member

  4. Jake Bunce

    Jake Bunce XenForo Moderator Staff Member

  5. dabollicks

    dabollicks Active Member

  6. dabollicks

    dabollicks Active Member

    My MySQL version is this:
    version5.1.69-cll

    Would it be recommended to upgrade? That is if an upgrade is available?
     
  7. Walter

    Walter Well-Known Member

    You should upgrade to MySQL 5.5 because there are just certain bug and features that are fixed that do not carry over to the next major release. 5.1 has reached end of life.
    And there are some nice performance improvments as well.
     
    dabollicks likes this.
  8. dabollicks

    dabollicks Active Member

    Thanks @Walter ill get round to it ASAP then
     

Share This Page