import error from phpbb

[stephend23]

Hey
ive just perchase the license for Vbulletin.

After following the instruction to import all my data from phpnuke (phpBB 2.0.11)
I keep getting the follwoing errors:

THIS IS WHAT I GET ON TOP OF THE PAGE
Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in /impex/db_mysql.php on line 248

INSIDE THE BOX I GET THIS MESSAGE:
Database error in vBulletin 3.0.7:
Invalid SQL:
SELECT user_id,username
FROM nuke_users
ORDER BY user_id
LIMIT 0,25
mysql error:
mysql error number: 0


Ive tried skipping to the other modules but i get the same errors again

Any help would be great.

Thanks in advance
Stephen

[stephend23]

Ive just re-tried to do the 001Check and update database module and noticed thw follwoing error below:

ERROR with the database or file system, please check config.

Below is my config file:

targetdatabasetype = mysql

targetserver = localhost

targetuser = "oriental_vbullet"

targetpassword = "#######"

targetdatabase =oriental_vbulletin

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 = false

; mysql OR mssql

sourcedatabasetype = mysql

sourceserver = localhost

sourceuser = "oriental_vbulle1"

sourcepassword = "######"

sourcedatabase =oriental_vbulletin1

sourcetableprefix =nuke_

[Steve Machol]

Assuming all the other info is correct, change the sourceexists line to:

sourceexists = true

[stephend23]

ive just did what you said. And the error in 001Check and update database module doesnt show up anymore however.

i still get the following message:
Database error in vBulletin:ImpEx Source 3.0.7:
Invalid SQL:
SELECT * FROM nuke_users
ORDER BY user_id
LIMIT 0,500
mysql error: Table 'oriental_vbulletin1.nuke_users' doesn't exist
mysql error number: 1146

Ive also tried to change sourcetableprefix to
nuke_bb

But that still didnt work

[stephend23]

think i got it now. Had to change some of the prefix

Thanks for your help