XF 1.5 Upgrading from 1.2.4 to 1.5.6

[Brandon K]

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?

 

[Paul B]

Do you have a smiley manager add-on installed?

The guide here has some links to add-ons with known problems: https://xenforo.com/community/resources/how-to-upgrade-to-xenforo-1-3.2810/

 

[Brandon K]

Do you have a smiley manager add-on installed?

The guide here has some links to add-ons with known problems: https://xenforo.com/community/resources/how-to-upgrade-to-xenforo-1-3.2810/

I completely uninstalled the add-on and I still get that message.

 

[Paul B]

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

 

[Brandon K]

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.

 

[Paul B]

What is the full text output of this query?

SHOW CREATE TABLE xf_smilie

 

[Brandon K]

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?

 

[Paul B]

That looks fine now so you should be good.

 

[Brandon K]

That looks fine now so you should be good.

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.