Problem Converting IPB 1.3 to Vbulletin

[mpadc]

Hey all

Wonder if someoen can help me im having problems converting Invision 1.3 >>> Vbulletin

This is what it is

Invision power based details:

DB Name: myusername_forum
User: myusername_blah

Vbulletin Details

DB Name: myusername_vbforum
user: User: myusername_blah


My Impex config file is as below:

[ Target Database ]
; The following settings allow ImpEx to connect to the vBulletin 3
; database into which you will be importing data.
targetdatabasetype = mysql
targetserver = localhost
targetuser = "myusername_blah"
targetpassword = "xxxxxxxx"
targetdatabase = "myusername_vbforum"
targettableprefix =

; mysql OR mssql
sourcedatabasetype = mysql
sourceserver = localhost
sourceuser = "myusername_blah"
sourcepassword = "xxxxxxxx"
sourcedatabase = "myusername_vbforum"
sourcetableprefix =


Ok then i go and run the Programme
001Check and update database

moderator - importmoderatorid OK
usergroup - importusergroupid OK
ranks - importrankid OK
poll - importpollid OK
forum - importforumid OK
forum - importcategoryid OK
user - importuserid OK
style - importstyleid OK
thread - importthreadid OK
post - importthreadid OK
thread - importforumid OK
smilie - importsmilieid OK
pmtext - importpmid OK
avatar - importavatarid OK
customavatar - importcustomavatarid OK
customprofilepic - importcustomprofilepicid OK
post - importpostid OK
attachment - importattachmentid OK
access NOT found or a non standard table.
adminhelp NOT found or a non standard table.
administrator NOT found or a non standard table.
adminlog NOT found or a non standard table.
adminutil NOT found or a non standard table.
announcement NOT found or a non standard table.
attachment NOT found or a non standard table.
attachmenttype NOT found or a non standard table.
attachmentviews NOT found or a non standard table.
avatar NOT found or a non standard table.
bbcode NOT found or a non standard table.
calendar NOT found or a non standard table.
calendarcustomfield NOT found or a non standard table.
calendarmoderator NOT found or a non standard table.
calendarpermission NOT found or a non standard table.
cron NOT found or a non standard table.
cronlog NOT found or a non standard table.
customavatar NOT found or a non standard table.
customprofilepic NOT found or a non standard table.
datastore NOT found or a non standard table.
deletionlog NOT found or a non standard table.
editlog NOT found or a non standard table.
event NOT found or a non standard table.
faq found.
forum NOT found or a non standard table.
forumpermission NOT found or a non standard table.
holiday NOT found or a non standard table.
icon NOT found or a non standard table.
imagecategory NOT found or a non standard table.
imagecategorypermission NOT found or a non standard table.
language NOT found or a non standard table.
mailqueue NOT found or a non standard table.
moderation NOT found or a non standard table.
moderator NOT found or a non standard table.
moderatorlog NOT found or a non standard table.
passwordhistory NOT found or a non standard table.
phrase NOT found or a non standard table.
phrasetype NOT found or a non standard table.
pm NOT found or a non standard table.
pmreceipt NOT found or a non standard table.
pmtext NOT found or a non standard table.
poll NOT found or a non standard table.
pollvote NOT found or a non standard table.
post NOT found or a non standard table.
post_parsed NOT found or a non standard table.
posthash NOT found or a non standard table.
postindex NOT found or a non standard table.
profilefield NOT found or a non standard table.
ranks NOT found or a non standard table.
regimage NOT found or a non standard table.
reminder NOT found or a non standard table.
reputation NOT found or a non standard table.
reputationlevel NOT found or a non standard table.
search NOT found or a non standard table.
session NOT found or a non standard table.
setting NOT found or a non standard table.
settinggroup NOT found or a non standard table.
smilie NOT found or a non standard table.
stats found.
stats found.
strikes NOT found or a non standard table.
style NOT found or a non standard table.
subscribeevent NOT found or a non standard table.
subscribeforum NOT found or a non standard table.
subscribethread NOT found or a non standard table.
subscription NOT found or a non standard table.
subscriptionlog NOT found or a non standard table.
template NOT found or a non standard table.
thread NOT found or a non standard table.
threadrate NOT found or a non standard table.
threadviews NOT found or a non standard table.
upgradelog NOT found or a non standard table.
user NOT found or a non standard table.
useractivation NOT found or a non standard table.
userban NOT found or a non standard table.
userfield NOT found or a non standard table.
usergroup NOT found or a non standard table.
usergroupleader NOT found or a non standard table.
usergrouprequest NOT found or a non standard table.
usernote NOT found or a non standard table.
userpromotion NOT found or a non standard table.
usertextfield NOT found or a non standard table.
usertitle NOT found or a non standard table.
vbfields NOT found or a non standard table.
word NOT found or a non standard table.


Then i move to Step 2


Database error in vBulletin:ImpEx Source 3.0.3:
Invalid SQL: SELECT id, name FROM members ORDER BY id LIMIT 0,25
mysql error: Table 'myusername_forum.members' doesn't exist
mysql error number: 1146
Date: Wednesday 10th of November 2004 10:50:58 AM
Script: http://www.mysite.com/bupload/impex/index.php
Referer: http://www.mysite.com.org/vbupload/impex/index.php
Username: admin
IP Address: 194.XX.XX.XX


Anyone know wassup wid that then i can do anything from there on

[Boxy]

Do your vBulletin tables have a prefix? If so you need to include this in targettableprefix.

[peterska2]

IPB tables usually have a prefix of ibf_ so make sure you put this into your source db info. (Don't worry I forgot about it too)

[mpadc]

IPB tables usually have a prefix of ibf_ so make sure you put this into your source db info. (Don't worry I forgot about it too)

Ya i forgot to put the prefixes

tx it works: )