1. 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

Discussion in 'Installation, Upgrade, and Import Support' started by Konstantin Salastey, Nov 16, 2015.

  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
     
  2. In code and database different... where right?(
    2015-11-16_151534.png 2015-11-16_151614.png
    display_order - repair database?
    or
    smilie_display_order - repair php) ?
     
  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.
     
  4. Mouth

    Mouth Well-Known Member

    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: Nov 16, 2015
  5. Sorry, where it look? (version)
     
  6. Mouth

    Mouth Well-Known Member

  7. ))
    XenForo 1.2.4
    But my base smilis
    2015-11-16_160859.png
     
  8. You are very kind. I think this problem is not only I can be, so it should be a public decision
     
  9. And in original simile.php not use
    display_order
    display_in_editor
     
  10. All thanks
    Mouth ++ )
    Hand made and...
    2015-11-16_170835.png
     
  11. Early happy)) Smailov not ((
    2015-11-16_175340.png
     
  12. Set in DB display_in_editor=1 all ok. All thanks
     

Share This Page