vBulltin User Import fails

[AdamHeavens]

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]

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.

 

[ragtek]

Seems similar to http://xenforo.com/community/threads/vbulletin-4-importer.5726/page-27#post-217079

edit:grml too slow

 

[AdamHeavens]

Thanks Gents, I will post there as well

 

[AdamHeavens]

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.

 

[Paul B]

That's the only vB4 importer available currently.