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

vBulltin User Import fails

#1
Howdy!

We are are trying to import our vbulletin users using the import script provided. However it fails with the following error. Any help appreciated

Server Error
Mysqli prepare error: Unknown column 'forums.usergroup.userid' in 'on clause'
1. Zend_Db_Statement_Mysqli->_prepare() in D:\HostingSpaces\username\domainname.com\wwwroot\v2\community\library\Zend\Db\Statement.php at line 115
2. Zend_Db_Statement->__construct() in D:\HostingSpaces\username\domainname.com\wwwroot\v2\community\library\Zend\Db\Adapter\Mysqli.php at line 381
3. Zend_Db_Adapter_Mysqli->prepare() in D:\HostingSpaces\username\domainname.com\wwwroot\v2\community\library\Zend\Db\Adapter\Abstract.php at line 478
4. Zend_Db_Adapter_Abstract->query() in D:\HostingSpaces\username\domainname.com\wwwroot\v2\community\library\Zend\Db\Adapter\Abstract.php at line 734
5. Zend_Db_Adapter_Abstract->fetchAll() in D:\HostingSpaces\username\domainname.com\wwwroot\v2\community\library\XenForo\Importer\vBulletin4.php at line 518
6. XenForo_Importer_vBulletin4->stepUsers() in D:\HostingSpaces\username\domainname.com\wwwroot\v2\community\library\XenForo\Importer\Abstract.php at line 77
7. XenForo_Importer_Abstract->runStep() in D:\HostingSpaces\username\domainname.com\wwwroot\v2\community\library\XenForo\ControllerAdmin\Import.php at line 166
8. XenForo_ControllerAdmin_Import->_runStep() in D:\HostingSpaces\username\domainname.com\wwwroot\v2\community\library\XenForo\ControllerAdmin\Import.php at line 218
9. XenForo_ControllerAdmin_Import->_startStep() in D:\HostingSpaces\username\domainname.com\wwwroot\v2\community\library\XenForo\ControllerAdmin\Import.php at line 161
10. XenForo_ControllerAdmin_Import->actionStartStep() in D:\HostingSpaces\username\domainname.com\wwwroot\v2\community\library\XenForo\FrontController.php at line 310
11. XenForo_FrontController->dispatch() in D:\HostingSpaces\username\domainname.com\wwwroot\v2\community\library\XenForo\FrontController.php at line 132
12. XenForo_FrontController->run() in D:\HostingSpaces\username\domainname.com\wwwroot\v2\community\admin.php at line 13

Thanks!
 

Mike

XenForo developer
Staff member
#2
This was recently reported in the vB 4 importer thread and I see that you're using the vB 4 importer from Paul M as well. You will need to post in that thread.
 
#5
Is there any other scripts available for this import? As we are desperate to move from vBulletin but can't get this to work even after a full re-install.