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

XF 1.5 Upgrading from 1.2.4 to 1.5.6

Discussion in 'Installation, Upgrade, and Import Support' started by Brandon K, Mar 12, 2016.

  1. Brandon K

    Brandon K New Member

    Hello,

    I decided the forums were due for an update so I created a test site to try out the upgrade.

    I disabled all the add-ons and I get this error after processing the upgrade on the test site:

    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 295
    10. XenForo_Model_Deferred->runDeferred() in XenForo/Model/Deferred.php at line 429
    11. XenForo_Model_Deferred->_runInternal() in XenForo/Model/Deferred.php at line 355
    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 351
    15. XenForo_FrontController->dispatch() in XenForo/FrontController.php at line 134
    16. XenForo_FrontController->run() in /home/troykpws/test/install/index.php at line 18
    Any help?
     
  2. Brogan

    Brogan XenForo Moderator Staff Member

  3. Brandon K

    Brandon K New Member

  4. Brogan

    Brogan XenForo Moderator Staff Member

  5. Brandon K

    Brandon K New Member

    I ran this query:

    ALTER TABLE xf_smilie
    DROP smilie_category_id,
    ADD smilie_category_id INT UNSIGNED NOT NULL DEFAULT 0,
    ADD display_order INT UNSIGNED NOT NULL DEFAULT 1,
    ADD display_in_editor TINYINT UNSIGNED NOT NULL DEFAULT 1,
    ADD INDEX display_order (display_order)

    and it didn't seem to help.
     
  6. Brogan

    Brogan XenForo Moderator Staff Member

    What is the full text output of this query?
    Code:
    SHOW CREATE TABLE xf_smilie
     
  7. Brandon K

    Brandon K New Member

    I reran this query:

    ALTER TABLE xf_smilie
    ADD smilie_category_id INT UNSIGNED NOT NULL DEFAULT 0

    and it seems to be continuing the upgrade now. Just in case here's that output:


    CREATE TABLE `xf_smilie` (
    `smilie_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
    `title` varchar(50) NOT NULL,
    `smilie_text` text NOT NULL,
    `image_url` varchar(200) NOT NULL,
    `sprite_mode` tinyint(3) unsigned NOT NULL DEFAULT '0',
    `sprite_params` text NOT NULL,
    `smilie_display_order` int(10) unsigned DEFAULT '0',
    `smilie_category_id` int(10) unsigned NOT NULL DEFAULT '0',
    `display_order` int(10) unsigned NOT NULL DEFAULT '1',
    `display_in_editor` tinyint(3) unsigned NOT NULL DEFAULT '1',
    PRIMARY KEY (`smilie_id`),
    KEY `display_order` (`display_order`)
    ) ENGINE=InnoDB AUTO_INCREMENT=274 DEFAULT CHARSET=utf8

    Is there anything I need to do?
     
  8. Brogan

    Brogan XenForo Moderator Staff Member

    That looks fine now so you should be good.
     
  9. Brandon K

    Brandon K New Member

    Thank you so much. Upgrade seems to have completed without further hiccups. I'll look over the rest of the test site before applying to the live site.

    I appreciate your help.
     

Share This Page