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

XF 1.2 vbulletin import error

#1
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
 

Mike

XenForo developer
Staff member
#2
What version are you importing from? It looks to me like you're missing a fundamental field (in the phrase table).
 

Mike

XenForo developer
Staff member
#4
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.)