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

XF 1.4 1.2.5 to 1.4 upgrade mysqli "display_order" error

Discussion in 'Installation, Upgrade, and Import Support' started by kella, Mar 26, 2015.

  1. kella

    kella Member

    Based on my brief searching, this appears to be due to the Smilie Manager add-on. What is the current advice on how to best handle this? Should I revert to a backup, remove all add-ons, and then complete the upgrade?

    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 294
    10. XenForo_Model_Deferred->runDeferred() in XenForo/Model/Deferred.php at line 428
    11. XenForo_Model_Deferred->_runInternal() in XenForo/Model/Deferred.php at line 354
    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/nutopias/public_html/forum/install/index.php at line 18
  2. Brogan

    Brogan XenForo Moderator Staff Member

    There are instructions in the smiley manager add-on resource/thread on how to resolve it.

Share This Page