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

Brand new install... can't use importer

Discussion in 'Media Gallery Support' started by Bonsai Coder, Feb 5, 2015.

  1. Bonsai Coder

    Bonsai Coder Active Member

    I have a clean install of xenForo and xenForo Media Gallery. This is on the same server as my PhotoPost install, just one directory over.

    I am trying to import for PhotoPost PHP Pro / Gallery.

    On the importing page I want to confirm:

    MySQL User Name - this is the user name for the PhotoPost DB, correct?
    MySQL Database Name - this is the DB name for the PhotoPost DB, correct?

    Because I enter all my correct information, as confirmed by cPanel, and I am getting this error:

    Error

    The source database connection details are not correct: Access denied for user 'bonsainu_photogal'@'localhost' (using password: YES)


    [EDIT] This error was created because I was entering "photogal" instead of "photgal" but see the error below [/EDIT]
     
    Last edited: Feb 5, 2015
  2. Chris D

    Chris D XenForo Developer Staff Member

    This looks like a mistake in the username or password or a connection problem between the databases. The latter seems unlikely if it's hosted locally though.
     
  3. Bonsai Coder

    Bonsai Coder Active Member

    Can I give you access to my cPanel? I swear to you - I am cutting and pasting the EXACT values.
     
  4. Brogan

    Brogan XenForo Moderator Staff Member

    Enter the password manually - c&p may introduce extra characters/spaces.
     
    Chris D likes this.
  5. whynot

    whynot Well-Known Member

    Perhaps it's simply 'bonsainu_photogal'?
     
  6. Bonsai Coder

    Bonsai Coder Active Member

    This is exactly what I am entering in the fields (with the exception of my password)

    MySQL Server: localhost
    MySQL Port: 3306
    MySQL User Name: bonsainu_photgal
    MySQL Password: [password]
    MySQL Database Name: bonsainu_db183921164
    Table Prefix: [blank]
    Force Character Set: [blank]
    Archived Import Log: archived_import_log
    vBGallery Files Location: /home/bonsainu/public_html/forums/photopost/data/

    I tried entering the password manually, it made no difference.
     
    Last edited: Feb 5, 2015
  7. Bonsai Coder

    Bonsai Coder Active Member

    I am looking directly at my PhotoPost Admin Menu... the values are right there - even the password is revealed.
     
  8. Bonsai Coder

    Bonsai Coder Active Member

    Ok I am now getting this message:

    Error
    The table prefix or database name is not correct.
     
  9. Bonsai Coder

    Bonsai Coder Active Member

    The table prefix is "pp_"

    Directly out of the config file: $pp_db_prefix = "pp_";

    I enter it manually, and still get the error above.
     
  10. Bonsai Coder

    Bonsai Coder Active Member

    Directly from my PhotoPost config-inc.php

    Code:
    //**************** MySQL Database Configuration ****************//
    
    // PhotoPost database host address, or leave as localhost
    $host="localhost";
    
    // PhotoPost's database name
    $database="bonsainu_db183921164";
    
    // MySQL username and password to access PhotoPost's database
    //
    // These two variables are for the userid and password needed to access
    // the PhotoPost database named above.
    $mysql_user="bonsainu_photgal";
    $mysql_password='[REMOVED]';
    
    // User database host address, or leave as localhost
    $host_bb="localhost";
    
    // If you want to use a prefix for your database, enter it here.
    // NOTE: This variable can only be set PRIOR to your first installation of PhotoPost;
    // existing databases will not be changed and you will be unable to connect if you change
    // this variable after performing a default installation.
    $pp_db_prefix = "pp_";
     
  11. Bonsai Coder

    Bonsai Coder Active Member

    You can see my PhotoPost Galleries right here - to see that I am connecting to my DB with these setting.
     
  12. Bonsai Coder

    Bonsai Coder Active Member

    For what it's worth, I earlier used the xenForo importer to import my vBulletin DB - and had not the slightest problem. So I did not experience a DB connection / permission problem earlier.
     
  13. Bonsai Coder

    Bonsai Coder Active Member

    Opened a ticket. I don't know what else to do...
     
  14. whynot

    whynot Well-Known Member

    Try again from the beginning:
    photgal or photogal.
     
  15. Brogan

    Brogan XenForo Moderator Staff Member

    It's not really a ticket issue - you just need to ensure you are entering the correct database information.

    Presumably the database is on the same server as your XenForo installation?
     
  16. Bonsai Coder

    Bonsai Coder Active Member


    Yes. Both installs are on the same server.

    I posted the EXACT values from my config file to show that I am entering the EXACT correct values. I don't know what else to do. I have tried at least 15 times at this point - been stuck here for two hours. I find it interesting that the importer clears me on the first step that the user name can access the database with the password provided... but then tells me it's an incorrect database.

    I've checked a billion times to make sure it is the PhotoPost DB and NOT the vBulletin DB.
     
  17. Chris D

    Chris D XenForo Developer Staff Member

    If you submit all of your log in details to the open ticket, I'll take a look.

    cPanel, and your Admin CP login should suffice. Maybe a fresh set of eyes will help. If not, I'll look at it from a code perspective to see if there's anything going wrong from that end.
     
  18. Brogan

    Brogan XenForo Moderator Staff Member

    Try running it without entering a prefix.
     
  19. Bonsai Coder

    Bonsai Coder Active Member

    Thank you both so much. I think I may have figured out at least part of the problem. I was doing an import xenforo < photopost gallery. (Because my product license says PhotoPost PHP Pro / PhotoGallery). When I tried importing xenforo < photopost, I got 95% complete... but then got this error:

    So frustrating. PART of the photos uploaded and PART of the content is there... until this error popped up.
     
  20. Chris D

    Chris D XenForo Developer Staff Member

    While that error is on screen, if you refresh the page does it continue?
     

Share This Page