Errors on the first step of imporing a phpbb2 board into an existing vB3 board.

[WildEye]

I'm getting errors when trying to import a phpbb2 board into my excisting vB3 board. When doing module 001 i get alot of errors.

the first 12 tables are getting OK messages, but then i get alot of : "xx NOT found or a non standard table." messages for the rest of the items.



moderator - importmoderatorid OK
usergroup - importusergroupid OK
ranks - importranksid OK
poll - importpollid OK
forum - importforumid OK
forum - importcategoryid OK
user - importuserid OK
style - importstyleid OK
thread - importthreadid OK
post - importpostid OK
thread - importforumid OK
smilie - importsmilieid OK

ezapprove_items NOT found or a non standard table.
ezbasket NOT found or a non standard table.
...
pbb_forums NOT found or a non standard table.
...
pbb_users NOT found or a non standard table.
etc
etc
etc




Any tips on what to do?


impexconfig.php:
targetdatabasetype = mysql
targetserver = localhost
targetuser = root
targetpassword =
targetdatabase = n4f-forum
targettableprefix =

sourceexists = true
sourcedatabasetype = mysql
source server = localhost
sourceuser = root
sourcepassword =
sourcedatabase = roleplay_ez3
sourcetableprefix =


Any tips appreciated!

EDIT added som examples of ok messages and failed messages

[Niji]

Looks like you have installed some other stuff in the same database as phpbb is using. The "errors" you're getting are no more than messages or warnings stating that the import system found tables it didn't expect, i.e. it doesn't know them.

I think you can safely ignore these "errors".

[Jerry]

Indeed, its just noting that it found something that it wasn't expecting.

You can proceed regardless of what it says, its my intention to tie the dependency of a module running to the tables that it uses when importing, which will be checked and setup at this stage.

[Dream On]

here i wil let u know what i do when i convert my board ..


install the vb in your localhost then uploud your old databse and do the convert it will work 100%

thankyou

[WildEye]

Ok will give it a shot when i get home.

Are there any other things i need to be aware of when importing into an excisting database (with users already there)?

Thanks

[Niji]

My advise would be to always import into a clean install of VB3. At the very least backup your database before importing into an existing database.

[WildEye]

My advise would be to always import into a clean install of VB3. At the very least backup your database before importing into an existing database.
I've imported my live database to my test machine, and trying to import the phpbb database into that...

update: Well its not working... I'm getting database error emails when attempting to use step / module 002...

Any more tips on what to do? I'm not the admin on the phpbb site, so i have no idea what hacks are installed.


Database error in vBulletin:ImpEx Source 3.0.1:

Invalid SQL:
SELECT user_id,username
FROM users
ORDER BY user_id
LIMIT 0,10
mysql error: Table 'roleplay_ez3.users' doesn't exist

mysql error number: 1146

Date: Thursday 22nd of April 2004 07:35:12 PM
Script: http://localhost/forum/impex/index.php (http://epostleser.online.no/redirect?http://localhost/forum/impex/index.php)
Referer: Username: Espen
IP Address: 127.0.0.1


Would it be possible to have your support team help with the import?

[Niji]

Are you sure your ImpExConfig file has the correct settings?

mysql error: Table 'roleplay_ez3.users' doesn't exist

It looks like you're trying to import from a database called roleplay_ez3 in which should be a "users" table.

Is this correct or have you used a prefix for your phpbb2 tables like "phpbb_"?

BTW: I'm not a vbulletin employee offcourse, but if memory serves you can still request them to do the import for you. Probably by opening a support ticket.

Also, I would advise verifying your ImpExConfig values/settings are correct with the phpbb administrators of that forum....

[WildEye]

Show tables in mysql returns the following tables:

alot of ezXXXX tables
and some pbb_XXXXX

ezuser
ezuser_accountkey
ezuser_discountrule
ezuser_role
ezuser_setting
etc

pbb_auth_access
pbb_banlist
pbb_categories
pbb_config
...
pbb_forum_prune
pbb_forums
...
pbb_posts
pbb_posts_text
...
pbb_user_groups
pbb_users
...

seems there are two table prefixes ?

Jerry, would you be able to assist me via a support ticket?

Thanks in advance...

[WildEye]

Are you sure your ImpExConfig file has the correct settings?

Also, I would advise verifying your ImpExConfig values/settings are correct with the phpbb administrators of that forum....
I have imported a mysqldump of their database onto my testsite mysql. trying to import that into my excisting forum backup. no good so far.

maybe i should try the pbb_ prefix in impex.

[WildEye]

Ok inputting pbb_ in prefix of the import database resulted in finding the tables. but i still get alot of error messages regarding the ez tables...

step two users 25 gave me a screen to associate users to exisiting ones... looking good it seems... updates will follow...

[Jerry]

The "errors" on stage 001 are notices more than errors or faults, it has a list of tables that it is expecting and shows what it finds in the dB it is connected to.

[Niji]

As Jerry said, you can ignore the "errors" about the ez tables.

Jerry... Maybe it would be a nice idea to make it more clear in the output that this concerns tables which "probably don't belong to phpbb, so skipping..." them? ;)

[Jerry]

Once I have fixed the major bugs I'm going to do that, though I was thinking of locking the modules to their dependant tables.

i.e. if you are importing from phpBB and there is no "phpbb_privmsgs" and no "phpbb_privmsgs_text" it won't let you run that module and will tell you during this stage.

[Niji]

Now there's a good thought :)