Trying to import phpBB2 2.0.11 to vB3

[Paul[Le]]

Hello, I just purchased vB3 and installed it without error and installed the impEx, but I'm running in to a problem importing my previous phpBB2 info.

This is the error I recv:

Database error in vBulletin:ImpEx Source 3.0.3:

Invalid SQL:
SELECT * FROM users
ORDER BY user_id
LIMIT 0,500
mysql error: Table 'phpTest.users' doesn't exist

mysql error number: 1146

Date: Monday 22nd of November 2004 07:59:24 AM
Script: http://www.x.net/forums/impex/index.php
Referer: http://www.x.net/forums/impex/index.php
Username: Paul
IP Address: xxx.xxx.xxx.xxx

Could someone please help me? I setup the ImpExConfig.php file correctly. The only thing I care about importing is the User accounts, PMs, Topics, Threads and such.

[Paul[Le]]

I just read a previous thread...

[ 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

; mysql OR mssql
sourcedatabasetype = mysql
sourceserver = localhost
sourceuser = "name"
sourcepassword = "pass"
sourcedatabase = phpTest
sourcetableprefix = phpbb_

Should this be what my config looks like? Also, should sourceexists = true or false? I really don't understand this option. I set to true because it's pulling the data from an existing sql database that is located on the localhost. Is true the right setting?

[Zachery]

remember that database names are case sensitive.

yes you need to set it as true.

Doesn;t look like its picking up your table prefix however.

[Jerry]

']
Should this be what my config looks like? Also, should sourceexists = true or false? I really don't understand this option. I set to true because it's pulling the data from an existing sql database that is located on the localhost. Is true the right setting?

Yes, that looks correct.

It should be calling :

SELECT * FROM phpbb_users
ORDER BY user_id
LIMIT 0,500

Have you saved ImpExConfig.php as ImpExConfig.php and not ImpExConfig.php.new ?

[Paul[Le]]

I forgot to take off the .new extension. It seems to be importing now.

One thing I've noticed is that it says something like imported_NameHere when I import and some names it doesn't say imported_. Is this normal?

[Zachery]

imported_namehere means that someone ini your current database matched someone in the phpbb database, so they get their name prefixed with imported_ so that you cna merge or do otherwise with the account

[Jerry]

Or re-run the module and merge on email.

[Paul[Le]]

Or re-run the module and merge on email.

Care to walk me through that?

Edit: NM, figured it out!