XF 1.2 vbulletin import error

when trying to import vb database i get this error at "import custom userfields" step, how can i fix it ?
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 541
  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 /Users/mac/Sites/forum/admin.php at line 13


XenForo developer
Staff member
That's a fundamental field and something that we've never had a report about, so I have to presume that you have missing data in your vB install. It's probably best that you ensure that your source system is working correctly, possibly doing an upgrade on it to confirm. (It's also not a field that we can avoid reading from - it's used in a "where" clause.)