No announcement yet.

Trouble importing forum

  • Filter
  • Time
  • Show
Clear All
new posts

  • Trouble importing forum

    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:
    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=""][u][size=2][color=#0000ff][/color][/size][/u][size=2][color=#0000ff][/color][/size][/url]
    [size=2]Referer: [/size][url=""][u][size=2][color=#0000ff][/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


  • #2
    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 ?
    I wrote ImpEx.

    Blog | Me


    • #3
      I need to import both the users and the forum data


      • #4
        Did you ever get this resolved, I have the same situation.

        Two table prefixes in the database:

        and nuke_bb******

        Last edited by VPREATR; Thu 13 Jan '05, 1:02pm.


        • #5
          There is no offical importer for that and the table prefixes were wrong anyway.
          I wrote ImpEx.

          Blog | Me


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


            widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.