XF 2.0 Vbulletin database migration help?

[DarkJesture]

Hey there, trying to migrate a big 3.7GB vbulletin database over to xenforo. I have tried to use both XF 2.x and XF 1.5 but have gotten errors for both. I've been trying to figure it out for a little over a week now and I can't seem to figure out how to remedy this. Can someone help me out?

This is the error I get with XF2.0

XenForo
XF\Db\Exception: MySQL statement prepare error [1146]: Table 'Database_name.vb_usergroup' doesn't exist in src/XF/Db/AbstractStatement.php at line 212

    XF\Db\AbstractStatement->getException() in src/XF/Db/Mysqli/Statement.php at line 196
    XF\Db\Mysqli\Statement->getException() in src/XF/Db/Mysqli/Statement.php at line 39
    XF\Db\Mysqli\Statement->prepare() in src/XF/Db/Mysqli/Statement.php at line 54
    XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 79
    XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 106
    XF\Db\AbstractAdapter->fetchAllKeyed() in src/addons/XFI/Import/Importer/vBulletin.php at line 571
    XFI\Import\Importer\vBulletin->stepUserGroups() in src/XF/Import/Runner.php at line 160
    XF\Import\Runner->runStep() in src/XF/Import/Runner.php at line 74
    XF\Import\Runner->run() in src/XF/Admin/Controller/Import.php at line 232
    XF\Admin\Controller\Import->actionRun() in src/XF/Mvc/Dispatcher.php at line 249
    XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 88
    XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 41
    XF\Mvc\Dispatcher->run() in src/XF/App.php at line 1934
    XF\App->run() in src/XF.php at line 333
    XF::runApp() in admin.php at line 13

When using XF1.5 I get this error when using "vb_" as the prefix:

The table prefix or database name is not correct.

Thanks in advance

 

[Claudio]

The vb_usergroup table is missing on the vBulletin database (which I'm unsure if you set as "Database_name")

 

[DarkJesture]

The vb_usergroup table is missing on the vBulletin database (which I'm unsure if you set as "Database_name")

That's what I'm confused about. In my vbulletin database the usergroupid and such is all under "vb_users" as far as I can tell. Any steps I should take? Thanks

 

[djbaxter]

That's what I'm confused about. In my vbulletin database the usergroupid and such is all under "vb_users" as far as I can tell. Any steps I should take? Thanks

vB3 was so long ago for me I don't remember but in vB4 vb_user and vb_usergroup were two separate tables.

 

[DarkJesture]

Hmm. Perhaps I'll install vbulletin on a separate board, upgrade it, then try the importer again. I'll update this post with the results.

 

[MySiteGuy]

VB 3 has a vb_usergroup table as well.