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

XF 1.5 vb 4x import

Discussion in 'Installation, Upgrade, and Import Support' started by fan, Feb 18, 2016.

  1. fan

    fan New Member

    hello, import error; What is the reason?

    Mysqli prepare error: Illegal mix of collations (latin1_bin,IMPLICIT) and (latin5_turkish_ci,IMPLICIT) for operation '='

    Zend_Db_Statement_Mysqli->_prepare() in Zend/Db/Statement.php at line 115
    Zend_Db_Statement->__construct() in Zend/Db/Adapter/Mysqli.php at line 381
    Zend_Db_Adapter_Mysqli->prepare() in Zend/Db/Adapter/Abstract.php at line 478
    Zend_Db_Adapter_Abstract->query() in Zend/Db/Adapter/Abstract.php at line 734
    Zend_Db_Adapter_Abstract->fetchAll() in XenForo/Importer/vBulletin.php at line 2325
    XenForo_Importer_vBulletin->stepThreadPrefixes() in XenForo/Importer/Abstract.php at line 97
    XenForo_Importer_Abstract->runStep() in XenForo/ControllerAdmin/Import.php at line 189
    XenForo_ControllerAdmin_Import->_runStep() in XenForo/ControllerAdmin/Import.php at line 241
    XenForo_ControllerAdmin_Import->_startStep() in XenForo/ControllerAdmin/Import.php at line 184
    XenForo_ControllerAdmin_Import->actionStartStep() in XenForo/FrontController.php at line 351
    XenForo_FrontController->dispatch() in XenForo/FrontController.php at line 134
     
  2. Slavik

    Slavik XenForo Moderator Staff Member

    Its a bit of a rough error, generally this means that you have manually set an individual column to a charset which isnt the same as the table. In this case you have a column set to latin5 with characters which cant be converted to latin1.

    The fix is going to involve finding the column which doesnt match the table character set, and converting it, though the results of what it spits out are going to be unpredictable.

    Obviously before making any such changes, you must take full backups.
     

Share This Page