1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

XF 1.2 Importing DB - issue with details

Discussion in 'Installation, Upgrade, and Import Support' started by rightclickfix, Oct 15, 2013.

  1. rightclickfix

    rightclickfix Member

    I successfully imported my phpbb3 forums the other day to my test site so thought I'd have a go on the new host I'm moving all my sites too eventually. However, when I ran the importer on my newly setup XF forums and put the details in of the phpbb3 forum config file and DB details it spits it with a user error like this;

    Code:
    The source database connection details are not correct: Access denied for user 'username'@'localhost' (using password: YES)
    the original config file (username n pw changed for security.

    Code:
    / phpBB 3.0.x auto-generated configuration file
    // Do not change anything in this file!
    $dbms = 'mysql';
    $dbhost = 'localhost';
    $dbport = '';
    $dbname = 'kayakfis_FORUM';
    $dbuser = 'username';
    $dbpasswd = 'password';
    $table_prefix = 'phpbb_';
    $acm_type = 'file';
    $load_extensions = '';
    
    @define('PHPBB_INSTALLED', true);
    // @define('DEBUG', true);
    // @define('DEBUG_EXTRA', true);
    I did notice in CP of the site housing the forums (which is in a sub directory) that the DB of the forums didn't seem to have a user name assigned to it? It seemed to be using the username of my main CP login so am I overlooking something here?

    so close .......
     
  2. Brogan

    Brogan XenForo Moderator Staff Member

    As the error suggests, the details you have entered for the source database are not correct.

    Presumably both XenForo and phpBB are installed on the same server?
     
  3. rightclickfix

    rightclickfix Member

    No Brogan the phpbb3 forums are still on my old host and I'm moving them to a new host. Could this be the issue as the test site is on the old host whre the phpbb3 forums are and it worked.
     
  4. borbole

    borbole Well-Known Member

    It would be best to have both forums in the same server.
     
  5. Brogan

    Brogan XenForo Moderator Staff Member

    Both installations need to be on the same server.
     
  6. rightclickfix

    rightclickfix Member

    ah ok I'll see about migrating the phpbb3 forums now then thanks. I know this isn't XF related but how about if I d/l the forum files in total and u/l them to the new host then run the importer? the forums don't need to be active do they? I suppose the DB needs to be up there though?
     
  7. Brogan

    Brogan XenForo Moderator Staff Member

    All you need to import is the database and related files such as avatars and attachments.
     
  8. rightclickfix

    rightclickfix Member

    I've just exported my DB as an sql file to PC. I need to import it to my new host/VPS account so do I import it somehow as a standalone DB or what? there doesn't seem to be any options?

    I'll see if the new host can help me as it's an issue with them not XF so thanks for the quick responses and helpful replies as always (y)

    just found DB admin on new host so can I import my DB into the XF one directly off the PC? or is that a bloody stupid thing to do lol?
     
  9. Brogan

    Brogan XenForo Moderator Staff Member

    You need to create a new DB and import the .sql into it.
    Then just upload the attachments and avatars and make sure the path corresponds.

    You don't need the actual software files.
     
  10. rightclickfix

    rightclickfix Member

    ah gotcha thanks :)
     
  11. rightclickfix

    rightclickfix Member

  12. rightclickfix

    rightclickfix Member

    Just looking at my shiny new forums with all content intact and I noticed all users are labelled "Administrator" under their avatar. Yet their permissions seem to be "member". There's also 2 admin user groups; ADMINISTRATOR & Administrator so maybe one id from phpbb3? I've just found an option to update all users and remove Administrator as a 2nd user group but am afraid I break it after getting so far :)
    Any quick links or suggestions please?
     
  13. Brogan

    Brogan XenForo Moderator Staff Member

    You can safely delete any custom user groups, any members will default to the Registered user group.

    Or you can just batch update and re-use the imported user groups.

    The default groups are listed here: http://xenforo.com/help/user-groups/
     
  14. rightclickfix

    rightclickfix Member

    thanks again Brogan :) I removed the imported user groups and now it's listing members as "new member" so I'll poke around from there...

    cheers m8
     

Share This Page