XF 1.2 Mysqli prepare error

[Konstantin Salastey]

Unfortunately I can not remember the previous version. I can look in the database, if the prompt where
Attemtp upgrade Xenforo, i see

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 /var/www/u0107830/data/www/halk.ru/forum/install/index.php at line 18

What to do next?(. Thank you

 

[Konstantin Salastey]

In code and database different... where right?(

display_order - repair database?
or
smilie_display_order - repair php) ?

 

[Konstantin Salastey]

Repair database... Oh) it conflit with add-on..
Upgrade Errors
Uh oh, your upgrade to 1.5.2 has failed!

The following elements of the database are incorrect:

• Column xf_smilie.display_in_editor missing.

This is likely caused by an add-on conflict. You may need to restore a backup, remove the offending add-on data from the database, and retry the upgrade. Contact support if you are not sure how to proceed.

 

[Mouth]

Upgrade from what version - 1.2?
Both 'display_order' and 'display_in_editor' are valid columns in xf_smilie for me with v1.5.2 ...

mysql> describe xf_smilie;
+--------------------+---------------------+------+-----+---------+----------------+
| Field              | Type                | Null | Key | Default | Extra          |
+--------------------+---------------------+------+-----+---------+----------------+
| smilie_id          | int(10) unsigned    | NO   | PRI | NULL    | auto_increment |
| title              | varchar(50)         | NO   |     | NULL    |                |
| smilie_text        | text                | NO   |     | NULL    |                |
| image_url          | varchar(200)        | NO   |     | NULL    |                |
| sprite_mode        | tinyint(3) unsigned | NO   |     | 0       |                |
| sprite_params      | text                | NO   |     | NULL    |                |
| smilie_category_id | int(10) unsigned    | NO   |     | 0       |                |
| display_order      | int(10) unsigned    | NO   | MUL | 1       |                |
| display_in_editor  | tinyint(3) unsigned | NO   |     | 1       |                |
+--------------------+---------------------+------+-----+---------+----------------+
9 rows in set (0.00 sec)

Maybe run the upgrade again?

 

[Konstantin Salastey]

Upgrade from what version?

Sorry, where it look? (version)

 

[Mouth]

Sounds like you should probably submit a support ticket at https://xenforo.com/customers/support

 

[Konstantin Salastey]

))
XenForo 1.2.4
But my base smilis

 

[Konstantin Salastey]

Sounds like you should probably submit a support ticket at https://xenforo.com/customers/support

You are very kind. I think this problem is not only I can be, so it should be a public decision

 

[Konstantin Salastey]

And in original simile.php not use
display_order
display_in_editor

 

[Konstantin Salastey]

All thanks
Mouth ++ )
Hand made and...

 

[Konstantin Salastey]

Early happy)) Smailov not ((

 

[Konstantin Salastey]

Set in DB display_in_editor=1 all ok. All thanks