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

XF 1.2 Server error during upgrade from 1.2 to 1.3

Joe Link

Well-known member
#1
I feel lucky the upgrade on my main site went smoothly, but now I have this to deal with. So far all I've tried was disabling all addons via the config file.

Where do I go from here?

Server Error
Mysqli prepare error: Unknown column 'display_order' in 'order clause'

  1. Zend_Db_Statement_Mysqli->_prepare() in Zend/Db/Statement.php at line 115
  2. Zend_Db_Statement->__construct() in Zend/Db/Adapter/Mysqli.php at line 381
  3. Zend_Db_Adapter_Mysqli->prepare() in Zend/Db/Adapter/Abstract.php at line 478
  4. Zend_Db_Adapter_Abstract->query() in XenForo/Model.php at line 219
  5. XenForo_Model->fetchAllKeyed() in XenForo/Model/Smilie.php at line 87
  6. XenForo_Model_Smilie->getAllSmiliesForCache() in XenForo/Model/Smilie.php at line 113
  7. XenForo_Model_Smilie->rebuildSmilieCache() in XenForo/Deferred/ImportMasterData.php at line 40
  8. XenForo_Deferred_ImportMasterData->execute() in XenForo/Deferred/Atomic.php at line 66
  9. XenForo_Deferred_Atomic->execute() in XenForo/Model/Deferred.php at line 256
  10. XenForo_Model_Deferred->runDeferred() in XenForo/Model/Deferred.php at line 390
  11. XenForo_Model_Deferred->_runInternal() in XenForo/Model/Deferred.php at line 316
  12. XenForo_Model_Deferred->runByUniqueKey() in XenForo/Install/Controller/Abstract.php at line 34
  13. XenForo_Install_Controller_Abstract->_manualDeferredRunner() in XenForo/Install/Controller/Upgrade.php at line 221
  14. XenForo_Install_Controller_Upgrade->actionRunDeferred() in XenForo/FrontController.php at line 347
  15. XenForo_FrontController->dispatch() in XenForo/FrontController.php at line 134
  16. XenForo_FrontController->run() in /home/swfa/public_html/install/index.php at line 18
 
Last edited:

Joe Link

Well-known member
#3
Thanks @Mike. Figures I remember to disable it on the first site then forget on the second. I've studied that link all day :)

Any options other than a DB restore?
 

Joe Link

Well-known member
#7
Nearly six years of running a forum and I've never recovered a site from a backup before tonight. I gotta say, it was well worth the downtime for everything I've learned from it.

Thanks for the help guys!