XF 1.2 Server error during upgrade from 1.2 to 1.3

[Joe Link]

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

 

[Mike]

See: http://xenforo.com/community/resources/how-to-upgrade-to-xenforo-1-3.2810/

This is caused by the smilie add-on you have installed.

 

[Joe Link]

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?

 

[Paul B]

Follow the instructions stated in that link.

Add-ons known to cause problems when upgrading to XenForo 1.3 are:

• http://xenforo.com/community/resources/smiley-manager.2538/
  • See this FAQ for how to upgrade with that add-on installed: http://xenforo.com/community/resources/smiley-manager.2538/field?field=faq

 

[Joe Link]

Thanks for the reply @Brogan.

If I've already run the upgrade is it too late? If not, how do I get past the "The board is currently waiting to be upgraded. Please complete the upgrade." screen to the admincp to uninstall it?

 

[AndyB]

Any options other than a DB restore?

I would think this is your only option.

 

[Joe Link]

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!

 

[Joe Link]

Just my luck, as soon as I finish up I see this post: http://xenforo.com/community/threads/smiley-manager.63098/page-9#post-709864

Ah well, I'll take that as a sign