Trouble importing forum

[EscortCossie]

I have just installed vb 3.0.1, and are about to import the forum data and users from my CMS (cpgnuke 8.1.1) but I've run into some problems..

I've set up the phpbb import script, but I'm not sure if the sourcedatabase and sourcetableprefix is correct.. When I try to import the database I get this error:

[size=2]
Database error in vBulletin:ImpEx Source 3.0.1:

Invalid SQL: 

SELECT user_id,username

FROM users

ORDER BY user_id

LIMIT 0,25

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

mysql error number: 1146

Date: Sunday 20th of June 2004 08:28:51 PM

Script: [/size][url="http://www.escortpower.net/community/impex/index.php"][u][size=2][color=#0000ff]http://www.escortpower.net/community/impex/index.php[/color][/size][/u][size=2][color=#0000ff][/color][/size][/url]

[size=2]Referer: [/size][url="http://www.escortpower.net/community/impex/index.php"][u][size=2][color=#0000ff]http://www.escortpower.net/community/impex/index.php[/color][/size][/u][size=2][color=#0000ff][/color][/size][/url]

The source database is called escortp_nuke and the phpbb tables are called nuke_bb****.. I also need to import all the users from the table nuke_users.

How do I setup the import config file correctly?

I'm not a php/sql guru, but I'll manage my way around phpMyAdmin and such if anyone could guide me towards the goal


Thanks,
-EC-

[Jerry]

There is a nuke importer in the works though that is going to be a way off at the moment.

There is a way of altering the database to get it back to a phpBB state so the importer can pick up the data it needs.

Are you just after the users or all the posts as well ?

[EscortCossie]

I need to import both the users and the forum data

[VPREATR]

EscortCossie:
Did you ever get this resolved, I have the same situation.

Two table prefixes in the database:

nuke_******
and nuke_bb******


Thanks!

[Jerry]

There is no offical importer for that and the table prefixes were wrong anyway.

[javageek]

The default prefixes for CPGNuke are CMS_. You can change it to whatever you want though on install. Check out my site at www.rdtiburon.com , it was converted over from cpgnuke.