• 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

dabollicks

Active member
#1
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
 

Mike

XenForo developer
Staff member
#2
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.
 

Walter

Well-known member
#7
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.