• 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

#1
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?
 
#5
You will need to run the query in the add-on thread, linked to from the resource FAQ.

See from this post onwards: https://xenforo.com/community/threads/smiley-manager.63098/page-9#post-709856
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.
 
#7
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?