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

XF 1.2 Mysqli prepare error

#1
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
 
#3
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

Well-known member
#4
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 ...

Code:
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?
 
Last edited: