Announcement

Collapse
No announcement yet.

Error during import from phpbb3 to vBulletin

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Error during import from phpbb3 to vBulletin

    Im merging my older phpbb3 forum to my new vbul forum using impex, however im running into issues. This is the error I recieve:

    ------------------------------

    ImpEx will now Alter the tables in the vB database to include import id numbers. This is needed during the import process for maintaining references between the tables during an import. If you have large tables (i.e. lots of posts) this can take some time. They will also be left after the import if you need to link back to the original vB userid.
    moderator - importmoderatorid Completed
    usergroup - importusergroupid Completed
    ranks - importrankid Completed
    poll - importpollid Completed
    forum - importforumid Completed
    forum - importcategoryid Completed
    user - importuserid Completed
    style - importstyleid Completed
    thread - importthreadid Completed
    post - importthreadid Completed
    thread - importforumid Completed
    smilie - importsmilieid Completed
    pmtext - importpmid Completed
    avatar - importavatarid Completed
    customavatar - importcustomavatarid Completed
    customprofilepic - importcustomprofilepicid Completed
    post - importpostid Completed
    attachment - importattachmentid Completed
    pm - importpmid Completed
    usernote - importusernoteid Completed
    phrase - importphraseid Completed
    subscription - importsubscriptionid Completed
    subscriptionlog - importsubscriptionlogid Completed Failed Check database permissions and connection, or table prefix to ensure its correct

    ------------------------------

    Now my old forum in phpbb3 is located in a www/forum directory, while my new vbul board is located in a www/msgboard directory. I edited the config file, however im not sure if this is the issue, therefor ill include whats in it:

    ------------------------------

    # TARGET - The target is the vBulletin database (where the data is going to)
    #
    ####
    $impexconfig['target']['server'] = 'localhost';
    $impexconfig['target']['user'] = '***********';
    $impexconfig['target']['password'] = '***********';
    $impexconfig['target']['database'] = 'vbulletin_forum';
    $impexconfig['target']['tableprefix'] = '';
    # 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
    $impexconfig['sourceexists'] = true;
    ####
    #
    # SOURCE - The source is the old forum database (where the data is coming from)
    #
    ####
    # mysql / mssql
    $impexconfig['source']['databasetype'] = 'mysqli'; // mysql OR mssql
    $impexconfig['source']['server'] = 'localhost';
    $impexconfig['source']['user'] = '***********';
    $impexconfig['source']['password'] = '***********';
    $impexconfig['source']['database'] = 'tunercon_phpb1';
    $impexconfig['source']['tableprefix'] = 'phpbb_';

    ------------------------------

    What am i doing wrong here?

  • #2
    Won't have anything to do with file paths, this is all database related. From the looks of it, it looks like your vbulletin database does not have the subscriptionlog table in the database. Make sure you set the correct version of vb you're using and, if needed, re-run the vbulletin installer to make sure all of the tables for the database gets installed. As a work around, you can always make the subscriptionlog table yourself by using phpmyadmin and edit the database manually.
    me won't have a signature for a loooooong time

    Comment


    • #3
      Which version of vB are importing into?
      Vote for:

      - *Admin Settable Paid Subscription Reminder Timeframe*
      -
      *PM - Add ability to reply to originator only*
      - Add Admin ability to auto-subscribe users to specific channel(s)
      - "Quick Route" Interface...

      Comment


      • #4
        I am getting this error too trying to merge from phpbb 3.07 to VB 4.0 ?
        www.plantandconstruction.co.uk

        Comment


        • #5
          all sorted now thanks
          www.plantandconstruction.co.uk

          Comment

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