Announcement

Collapse
No announcement yet.

Trouble importing forum

Collapse
X
 
  • 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:
    Code:
    [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-

  • #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

    Comment


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

      Comment


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

        Two table prefixes in the database:

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


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

        Comment


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

          Blog | Me

          Comment


          • #6
            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.

            Comment

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