XF 1.4 Import from 3.8.7 - Issues


Well-known member
I'm trying to import a vB database running 3.8.7 to XenForo but it stops on the option to import Custom User Fields with the following error. Any help appreciated:

Server Error
Mysqli prepare error: Unknown column 'fieldname' in 'where 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 Zend/Db/Adapter/Abstract.php at line 808
  5. Zend_Db_Adapter_Abstract->fetchPairs() in XenForo/Importer/vBulletin.php at line 544
  6. XenForo_Importer_vBulletin->stepUserFields() in XenForo/Importer/Abstract.php at line 97
  7. XenForo_Importer_Abstract->runStep() in XenForo/ControllerAdmin/Import.php at line 187
  8. XenForo_ControllerAdmin_Import->_runStep() in XenForo/ControllerAdmin/Import.php at line 239
  9. XenForo_ControllerAdmin_Import->_startStep() in XenForo/ControllerAdmin/Import.php at line 182
  10. XenForo_ControllerAdmin_Import->actionStartStep() in XenForo/FrontController.php at line 347
  11. XenForo_FrontController->dispatch() in XenForo/FrontController.php at line 134
  12. XenForo_FrontController->run() in /**/public_html/admin.php at line 13


XenForo developer
Staff member
This would seem to imply that your source DB is "corrupt", in that it's missing a fundamental column (on the phrase table). I would recommend checking that your dump does still work on the source system (particularly editing something that deals with/changes phrase groups).


Well-known member
I managed to get it to work by importing into IPB then to XenForo. Thanks for the reply however :)