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

XF 1.4 importing our vb3.7 to xf1.4.2

Discussion in 'Installation, Upgrade, and Import Support' started by Ian S, Nov 4, 2014.

  1. Ian S

    Ian S Active Member

    hello again doing alot with this atm so please forgive me for all the questions lol:ROFLMAO::ROFLMAO:
    right i tried to us the importer i read how to do it, but i cant get it to import as i get a error, we had a import done ages ago but i want to get it more update date, i filled all parts in ie database name, sysql user, pass etc didnt put anything in table prefixs or bottom line but it says this

    Error
    The source database connection details are not correct: No such file or directory:cry::cry::cry::cry:

    both sites share the server and phpmyadmin, the database for xf is there and vb is there but they both seperate

    any help apprec(y)
     
    Last edited: Nov 4, 2014
  2. Brogan

    Brogan XenForo Moderator Staff Member

    The details you have entered for the source (vB) are not correct.

    What are you entering for each field (you can omit the password field) and where are vB and XF installed?
     
  3. Ian S

    Ian S Active Member

    thanx as always brogan this is how i filled it in

    MySQL Server: localhost
    MySQL Port: 3306
    MySQL User Name: forum
    MySQL Password:
    MySQL Database Name: forum
    Table Prefix:

    in phpmyadmin our vb db is called forum our xf db is called ****_xf

    i have a callback php script on the vb site with the user and password etc as below


    <?php
    //###########################################################
    //
    //
    // This script recalls the latest posts from MySQL, parses them with vB's parser and outputs the lot.
    // It checks viewing permissions on an individual level.
    //###########################################################
    // (This file needs to live in the /boards/ directory)

    // adjust hour by:
    $time_adjust = 0;

    // how often (in seconds) to refresh the live forum page ?
    $refresh = "100";

    // how many recent posts to show ?
    $showposts = "40";

    // how many posts to pull from database ? typically double $showposts because there's the chance that our user may not be allowed to see half of them!
    $readposts = "60";

    // where is our MySQL ?
    $db_host = "localhost";

    // forum database:
    $db_name = "forum";

    // username:
    $db_user = "forum";

    // pasword:
    $db_pw = "removed *****";

    so i presume ive got the right passes etc for vb
     
  4. Brogan

    Brogan XenForo Moderator Staff Member

    To clarify, do you get the error when you attempt to validate the configuration or during one of the steps?
     
  5. Ian S

    Ian S Active Member

    i get it straight after i press the validate configuration tab
     
  6. Brogan

    Brogan XenForo Moderator Staff Member

    The user name and password are correct, otherwise you would get this error: "The source database connection details are not correct: Access denied for user 'root'@'localhost' (using password: YES)".

    I am unable to trigger the error you receive though.

    If the DB name is incorrect it should be: "The source database connection details are not correct: Unknown database 'name'"

    If the DB is present but isn't a valid 3.7 DB, it's: "The table prefix or database name is not correct.".

    I'll need to dig into the code to see when and why that error message is displayed.
     
  7. Ian S

    Ian S Active Member

    ive tried everything and im at a lost now, the strange thing is when someone built the xf site they did a import from our current vb site all the threads and users are there but obviously some functions arent as vb is different to xf, ive tried all passwords, the strange thing is there both on the same server and both visible easily in phpmyadmin, i tried doing it on the offline version and still got the same error too
     
  8. Ian S

    Ian S Active Member

    heres a pic its deffo vb 3.7
     

    Attached Files:

    • pic.jpg
      pic.jpg
      File size:
      90.5 KB
      Views:
      24
  9. Ian S

    Ian S Active Member

    few more pics
     

    Attached Files:

  10. Mike

    Mike XenForo Developer Staff Member

    Brogan likes this.
  11. Ian S

    Ian S Active Member

    hi mike i get this error with that which is the same as brogan got

    Error
    The source database connection details are not correct: Access denied for user 'forum'@'localhost' (using password: YES)
     
  12. Ian S

    Ian S Active Member

    update i tried that on the offline version and got the error above but i tried it on the live site and got this

    Configure Importer: vBulletin 3.7/3.8
    MySQL Server:
    127.0.0.1
    MySQL Port:
    3306
    MySQL User Name:
    forum
    MySQL Password:
    removed
    MySQL Database Name:
    forum
    Table Prefix:
    Force Character Set:
    Attachments or avatars are being stored in the file system. Please confirm the path to these.
    Attachments Directory:/var/www/vhosts/****.org/httpdocs/attachments

    and then validate configuration button underneath is this going to work now???
     
  13. Brogan

    Brogan XenForo Moderator Staff Member

    If it validates, it will show the next screen which lists the import steps.

    Nothing will happen automatically though.
     
  14. Ian S

    Ian S Active Member

    ok hit the button and got this now

    Server Error
    file_exists(): open_basedir restriction in effect. File(/var/www/vhosts/****.org/httpdocs/attachments) is not within the allowed path(s): (/var/www/vhosts/dev.****.org/:/tmp/:/var/www/vhosts/****.org/httpdocs/)

    1. XenForo_Application::handlePhpError()
    2. file_exists() in XenForo/Importer/vBulletin.php at line 153
    3. XenForo_Importer_vBulletin->validateConfiguration() in XenForo/Importer/vBulletin.php at line 31
    4. XenForo_Importer_vBulletin->configure() in XenForo/ControllerAdmin/Import.php at line 76
    5. XenForo_ControllerAdmin_Import->actionConfig() in XenForo/FrontController.php at line 347
    6. XenForo_FrontController->dispatch() in XenForo/FrontController.php at line 134
    7. XenForo_FrontController->run() in /var/www/vhosts/dev.****.org/httpdocs/admin.php at line 1377
    ive checked and they exist already on the server if i backup/delete this will it work, if it fails anytime later im DEAD lol

    you must be able to overwrite the existing backup
     
  15. Brogan

    Brogan XenForo Moderator Staff Member

    You may need to edit open_basedir in your PHP configuration to include that directory.
     
  16. Ian S

    Ian S Active Member

    hmm its on the host im not sure if i can change the setting in that file where would it be and what would i need to change to include the directory

    thanx again for everyones help
     
  17. Ian S

    Ian S Active Member

    ok im back laptop was kapput anywayz this is whats at line 153 in the error

    if (!file_exists($config['attachmentPath']) || !is_dir($config['attachmentPath']))

    i cant find the open_basedir to edit

    anyone help thanx

    i also tried changing the folder to another and got the same error, i need to import asap all help is appreciated
     
  18. Mike

    Mike XenForo Developer Staff Member

    open_basedir is a php.ini or VHost setting. You need root-level access to change it in most cases. Only your host can do that.

    Alternatively, you can copy your attachments to a different path that is within the open_basedir limits (or move attachments into the database).
     
  19. Ian S

    Ian S Active Member

    thanx mike im not a complete newbie but new some more advice
    is there a tut for this mike???

    thanx(y)
     
  20. Mike

    Mike XenForo Developer Staff Member

    By copying the files, I just mean copying the directories that contain the source forum's attachments to somewhere that PHP can access. You just need to enter that path into the XF importer.

    Alternatively, you can put your attachments back into the DB in your source forum and that eliminates the file path issue.
     

Share This Page