XF 1.5 vb 4x import

[fan]

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

 

[Slavik]

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.