Impex Error, phpBB to vB3

[webstalker]

I get lots and lots of errors while running ImpEx.
I have edited the Impexconfig and it still puts up errors in Step2.

Step 1 works 25%. Half the phpBB tables are okay. The rest are Not standard or something like that.
Step 1(and i have confirmed that these tables exist):
Import / Export

ImpEx will now Alter the tables in the vB database to include import id numbers.
This is needed during the import process for maintaining refrences between the tables during an import.If you have large tables (i.e. lots of posts) this can take some time.

They will also be left after the import if you need to link back to the origional phpBB userid.

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
post - importpostid OK
phpbb_auth_access NOT found or a non standard table.
phpbb_banlist NOT found or a non standard table.
phpbb_categories NOT found or a non standard table.
phpbb_config NOT found or a non standard table.
phpbb_confirm NOT found or a non standard table.
phpbb_disallow NOT found or a non standard table.
phpbb_forum_prune NOT found or a non standard table.
phpbb_forums NOT found or a non standard table.
phpbb_groups NOT found or a non standard table.
phpbb_posts NOT found or a non standard table.
phpbb_posts_text NOT found or a non standard table.
phpbb_privmsgs NOT found or a non standard table.
phpbb_privmsgs_text NOT found or a non standard table.
phpbb_ranks NOT found or a non standard table.
phpbb_search_results NOT found or a non standard table.
phpbb_search_wordlist NOT found or a non standard table.
phpbb_search_wordmatch NOT found or a non standard table.
phpbb_sessions NOT found or a non standard table.
phpbb_smilies NOT found or a non standard table.
phpbb_themes NOT found or a non standard table.
phpbb_themes_name NOT found or a non standard table.
phpbb_topics NOT found or a non standard table.
phpbb_topics_watch NOT found or a non standard table.
phpbb_user_group NOT found or a non standard table.
phpbb_users NOT found or a non standard table.
phpbb_vote_desc NOT found or a non standard table.
phpbb_vote_results NOT found or a non standard table.
phpbb_vote_voters NOT found or a non standard table.
phpbb_words NOT found or a non standard table.

Step 2 produce:
Database error in vBulletin :
Database error in vBulletin:ImpEx Source 3.0.3:

Invalid SQL:
SELECT user_id,username
FROM phpBB_users
ORDER BY user_id
LIMIT 0,25
mysql error: Table 'mlo_forum.phpBB_users' doesn't exist

mysql error number: 1146

Date: Monday 02nd of August 2004 11:18:11 PM
Script: http://forums.themlo.com/impex/index.php
Referer: http://forums.themlo.com/impex/index.php
Username: weBstalkeR
IP Address: *

Step 3(skipping step 2):

Database error in vBulletin :

Invalid SQL:
CREATE TABLE vb3_access (
userid INT UNSIGNED NOT NULL DEFAULT '0',
forumid SMALLINT UNSIGNED NOT NULL DEFAULT '0',
accessmask SMALLINT UNSIGNED NOT NULL DEFAULT '0',
PRIMARY KEY userid (userid, forumid)
)

mysql error: Table 'vb3_access' already exists

mysql error number: 1050

Date: Tuesday 03rd of August 2004 12:12:54 AM
Script: http://forums.themlo.com/install/install.php?step=3
Referer: http://forums.themlo.com/install/install.php?step=2
Any help would be much appreciated seeing as I paid 85 dollars for vB and the importer is not even working.

[webstalker]

*bump*

anyone know the answer to my question. i mean i did pay 85 dollars for something to work and it doesnt? what kind of bs is that? and i have waited weeks for support.

[Jerry]

There seems to be 2 errors there, ImpEx dosn't do anything with the access table, and as for the 1st error I would guess that your table prefix is wrong for the source database in impexconfig

[webstalker]

nope, tripled checked the database it looks like:

[ 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 = *
targetpassword = *
targetdatabase = mlo_vb3
targettableprefix = vb3_

[ Source Database ]
; If the system that is being imported from uses a database,
; enter the details for it here and set 'sourceexists' to TRUE.
; If the source data is NOT stored in a database, set 'sourceexists' to FALSE

sourceexists = true

sourcedatabasetype = mysql
sourceserver = localhost
sourceuser = *
sourcepassword = *
sourcedatabase = mlo_forum
sourcetableprefix = phpBB_


my vb tables all start with vb3_ (ex. vb3_user)
my phpbb tables all start with phpbb_ (ex. phpbb_users)

could it be case sens? i never realized that before, i know a lot of things are so ill try it.

k, it was case sensitive. what do i do at the assosiations in step 2 b/c it asks for exisiting user id. btw thanks!

[Jerry]

k, it was case sensitive. what do i do at the assosiations in step 2 b/c it asks for exisiting user id. btw thanks!

Thats only there if you have exsisting vB users that you want to assocaite with the ones you are importing.