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

XF 1.5 Importing from VB 4.2.3

Brand new XenForo user here; we were doing a test run of Importing from VB 4.2.3 and all was going well until we got to the stage "Import Content Tags" then we get hit by an Error:

Server Error

Mysqli statement execute error : Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '='

Zend_Db_Statement_Mysqli->_execute() in C:\inetpub\wwwroot\home-xen\library\Zend\Db\Statement.php at line 297
Zend_Db_Statement->execute() in C:\inetpub\wwwroot\home-xen\library\Zend\Db\Adapter\Abstract.php at line 479
Zend_Db_Adapter_Abstract->query() in C:\inetpub\wwwroot\home-xen\library\Zend\Db\Adapter\Abstract.php at line 825
Zend_Db_Adapter_Abstract->fetchOne() in C:\inetpub\wwwroot\home-xen\library\XenForo\Importer\vBulletin4x.php at line 213
XenForo_Importer_vBulletin4x->stepContentTags() in C:\inetpub\wwwroot\home-xen\library\XenForo\Importer\Abstract.php at line 124
XenForo_Importer_Abstract->runStep() in C:\inetpub\wwwroot\home-xen\library\XenForo\ControllerAdmin\Import.php at line 189
XenForo_ControllerAdmin_Import->_runStep() in C:\inetpub\wwwroot\home-xen\library\XenForo\ControllerAdmin\Import.php at line 137
XenForo_ControllerAdmin_Import->actionImport() in C:\inetpub\wwwroot\home-xen\library\XenForo\FrontController.php at line 351
XenForo_FrontController->dispatch() in C:\inetpub\wwwroot\home-xen\library\XenForo\FrontController.php at line 134
XenForo_FrontController->run() in C:\inetpub\wwwroot\home-xen\admin.php at line 13
We thought it just be a case of editing all the Bulletin Tables from latin1_swedish to general_ci but we can't get the damn error to clear!

Everytime we go back into the Importer to Resume the error re-appears.
We're not sure if its stuck from before; or if it actually 'bothers' trying again. the GUI isn't clear :(

Please help. This is a bog standard vBulletin 4.2.3 import (nothing special). It took hours to get all the users and threads in so we don't fancy starting from scratch.


XenForo developer
Staff member
It looks to me like your source DB is inconsistent. I have responded to your ticket to get more details though.
For anyone who Google's this, the suggestion by the Xenforo staff to add the flowing to the my.ini file, at the end of the [mysqld] section worked for us.