+ Reply to Thread
Results 1 to 3 of 3

Thread: Errors Importing From phpBB

  1. #1
    New Member ScottRowan has disabled reputation ScottRowan's Avatar
    Join Date
    May 2007
    Location
    Glasgow
    Posts
    24

    Errors Importing From phpBB

    Hi, my phpBB forum is a phpBB3 Beta 5. I installed ImPEX and its showing in the AdminCP. Heres the iImpExConfig.php file:

    Code:
    ####
    #
    # TARGET - The target is the vBulletin database (where the  data is going to)
    #
    ####
    
    $impexconfig['target']['server']        = 'localhost';
    $impexconfig['target']['user']            = 'hazard_Rowan';
    $impexconfig['target']['password']        = 'THECORRECTPASSWORDISHERE';
    $impexconfig['target']['database']        = 'hazard_vbulletin';
    $impexconfig['target']['tableprefix']    = 'vbhazard_';
    
    # 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']    = 'mysql';  // mysql OR mssql
    $impexconfig['source']['server']        = 'localhost';
    $impexconfig['source']['user']            = 'hazard_Rowan';
    $impexconfig['source']['password']        = 'THECORRECTPASSWORDISHERE';
    $impexconfig['source']['database']        = 'hazard_hazardforum';
    $impexconfig['source']['tableprefix']   = 'phpbb_';
    When I go into Import > Import, select:
    Source Format: phpBB3
    Version To Export: vBulletin 3.6.5

    Begin Import....

    When I do "Check and update database" everything shows green.
    When I do "Associate Users" I leave them all empty as they will just be straight transfered over.
    When I do "Import Usergroup" everything shows green.
    When I do "Import User" everything shows green.

    Now, when I do "Import Forum", I get this:

    Code:
    ImpEx Database errormysql error: Invalid SQL: SELECT importcategoryid FROM forum WHERE importcategoryid=50
    
    mysql error: Table 'hazard_vbulletin.forum' doesn't exist
    
    mysql error number: 1146
    
    Date: Monday 07th of May 2007 08:13:52 AM
    Database: hazard_vbulletin
    MySQL error:
    How do I fix this? Been trying to fix it all day.

    Looking forward to reply,

    Cheers,

    Rowan

  2. #2
    Customer Support Manager Steve Machol is a name known to all Steve Machol is a name known to all Steve Machol is a name known to all Steve Machol is a name known to all Steve Machol is a name known to all Steve Machol is a name known to all Steve Machol's Avatar
    Join Date
    Jul 2000
    Location
    Jelsoft InterGalactic HQ
    Posts
    142,702
    mysql error: Table 'hazard_vbulletin.forum' doesn't exist

    You are using the wrong db info in your ImpExConfig.php file. You need to check and fix this info.
    Steve Machol, vBulletin Customer Support Manager
    "Have Copy, Will Paste" (when appropriate)

    Please do not email or PM me for vBulletin support. I will be more than glad to answer your questions on the vB Forums and in the support system.

    Just remember that what happens in localhost, stays in localhost.


  3. #3
    ImpEx Developer Jerry will become famous soon enough Jerry's Avatar
    Join Date
    Dec 2002
    Location
    Secret underground lab
    Posts
    9,115
    Blog Entries
    5
    This means PHP is using the same connection for both databases, for a work around change this in your ImpExConfig.

    PHP Code:
    define('dupe_checking'false); 

+ Reply to Thread

Similar Threads

  1. importing phpbb to vb
    By gotTHC in forum vBulletin Pre-sales Questions
    Replies: 5
    Last Post: Mon 13th Nov '06, 2:06pm
  2. Importing phpBB 2.0.16 attachments...giving me errors!
    By Jet Blast in forum vBulletin Impex Import System
    Replies: 5
    Last Post: Tue 13th Dec '05, 3:35am
  3. Errors when importing from PHPBB 2.0.18
    By Robin McDermott in forum vBulletin Impex Import System
    Replies: 5
    Last Post: Tue 15th Nov '05, 2:48pm
  4. Importing from PHPBB
    By mrmtd in forum vBulletin 2 'How Do I' and Troubleshooting
    Replies: 5
    Last Post: Sun 29th Jun '03, 5:52pm
  5. Importing from PHPBB
    By Paul Govier in forum vBulletin 2 'How Do I' and Troubleshooting
    Replies: 2
    Last Post: Fri 4th Apr '03, 1:39pm

Bookmarks

Posting Permissions

Posting Permissions
  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts