XF 1.2 Few server errors after upgrade

[dabollicks]

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

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

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

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]

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.

 

[dabollicks]

Thanks @Mike

 

[Jake Bunce]

Mysqli statement execute error : Prepared statement needs to be re-prepared

Might help:

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

 

[dabollicks]

Thanks @Jake Bunce ill have a gander

 

[dabollicks]

My MySQL version is this:
version5.1.69-cll

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

 

[Walter]

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]

Thanks @Walter ill get round to it ASAP then