Merging two vB4.2.1 forum ---database error

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • Kwak
    Senior Member
    • Jul 2003
    • 547
    • 4.2.X

    Merging two vB4.2.1 forum ---database error

    Have a forum running 4.2.1 and using Impex to import another database to merge into the 1st forum.

    After the initial Import error using Impex,
    PHP Code:
    ImpEx build version 1.104  Database cleanup restart |||  Online manual  
    Using includes
    /config.php for target config
    I click Database cleanup & restart
    PHP Code:

    Cancel
    To cancel 
    and return to the importclick here.

    Delete Session
    To delete the import session 
    and continue with the importclick here.

    Delete Session and all imported data
    FORUM data 
    To delete the import session and all imported data for a clean retryclick here.

    CMS data To delete the import session and all imported data for a clean retryclick here.

    BLOG data To delete the import session and all imported data for a clean retryclick here.

    Remove Importids
    FORUM importids 
    To delete the importids in the databaseclick herealso removes the sessionThis will allow you to do consecutive imports

    CMS importids 
    To delete the importids in the databaseclick herealso removes the sessionThis will allow you to do consecutive imports

    BLOG importids 
    To delete the importids in the databaseclick herealso removes the sessionThis will allow you to do consecutive imports

    Remove duplicate forums
    /threads/posts.
    This will remove anything that has a duplicate importid and a diffrent vBulletin id. Use with EXTREME cautionresults will vary between source systemsALWAYS TAKE A BACK UP BEFORE USING 
    Clicking on any of the link gives me:
    PHP Code:
    ImpEx Database error

    mysql error
    Invalid SQLDELETE FROM datastore WHERE title='ImpExSession';

    mysql errorTable 'database_dbname.datastore' doesn't exist

    mysql error number: 1146

    Date: Thursday 09th 2013f May 2013 10:02:55 PM
    Database: database_dbname
    MySQL error: Table '
    database_dbname.datastore' doesn't exist 

    What could be the problem? Thank you.
    I am a novice when it comes to mysql database.
  • BirdOPrey5
    Senior Member
    • Jul 2008
    • 9613
    • 5.6.3

    #2
    Make sure you are connected to the correct database Also make sure you have set the correct table prefix for your import database, if the old database had a table prefix you need to set it in the impex config file.

    If you're not sure, open the import database in phpmyadmin- if all the tables have a prefix before them, like vb_datastore then vb_ is the prefix.

    Comment

    • Trevor Hannant
      vBulletin Support
      • Aug 2002
      • 24356
      • 5.7.X

      #3
      Resolved via ticket - the prefix was missing from the ImpexConfig.php file.
      Vote for:

      - Admin Settable Paid Subscription Reminder Timeframe (vB6)
      - Add Admin ability to auto-subscribe users to specific channel(s) (vB6)

      Comment

      • pcmwebmaster
        Member
        • May 2010
        • 30
        • 4.0.0

        #4
        Hello
        I am going to merge two forums in to one forum, i want move threads and posts from one vBulletin to another, how i can do it? should i use IMPEX?
        Both forum are vBulletin 4 Version.
        Thanks

        Comment

        • Mark.B
          vBulletin Support
          • Feb 2004
          • 24287
          • 6.0.X

          #5
          Originally posted by pcmwebmaster
          Hello
          I am going to merge two forums in to one forum, i want move threads and posts from one vBulletin to another, how i can do it? should i use IMPEX?
          Both forum are vBulletin 4 Version.
          Thanks
          Please start your own topic with full details of the issue. Thank you.
          MARK.B
          vBulletin Support
          ------------
          My Unofficial vBulletin 6.0.0 Demo: https://www.talknewsuk.com
          My Unofficial vBulletin Cloud Demo: https://www.adminammo.com

          Comment

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