Results 1 to 6 of 6
  1. #1
    Join Date
    Oct 2007
    Posts
    6
    Plugin Contributions
    0

    Default Database Connection Error

    Hello! I am a TOTAL newbie in more ways than one! I am sure there are other posts referencing this problem, but I am getting a connection error when I load my index page to my site. I am very new to Zen Cart and don't know much about MySQL or PHP. The error is located here: www.pricewebsites.com What am I missing in my setup? I have figured out how to setup a new database in the Control Panel of my site through my host, but I am obviously missing a major step. Thank you for any help!!! Amber

  2. #2
    Join Date
    Aug 2005
    Location
    Arizona
    Posts
    27,761
    Plugin Contributions
    9

    Default Re: Database Connection Error

    Post just the DB entries from your /includes/configure.php file and "X" out the user and pass fields for your security and while you are looking at this insure that these details are correct for the DB that you created
    Zen-Venom Get Bitten

  3. #3
    Join Date
    Oct 2007
    Posts
    6
    Plugin Contributions
    0

    Default Re: Database Connection Error

    What DB entries are you referring to? This is where I get confused. I have tried changing the xxx spots to what my username and password are, but you are saying I do NOT have to do this? Thx!

  4. #4
    Join Date
    Aug 2005
    Location
    Arizona
    Posts
    27,761
    Plugin Contributions
    9

    Default Re: Database Connection Error

    Not exactly - I was asking you to post the details here but to X out your user and db name so that others will not see what they are
    Zen-Venom Get Bitten

  5. #5
    Join Date
    Oct 2007
    Posts
    6
    Plugin Contributions
    0

    Default Re: Database Connection Error

    HOw do I easily access my previous posts? I wasn't sure if it was a setting in my account...I've had to scroll to my previous posts.

    I hope this is the information you need...this is the info I changed. I even tried recreating the database (adding a new db) in my control panel, fixing the username and password. Is there other info I should change? I have used Dreamweaver to change and save my php files, is this ok? I have read that Notepad++ works better?? Thank you again!

    // define our database connection
    define('DB_TYPE', 'mysql');
    define('DB_PREFIX', '');
    define('DB_SERVER', 'localhost');
    define('DB_SERVER_USERNAME', 'XXX');
    define('DB_SERVER_PASSWORD', 'XXX');
    define('DB_DATABASE', 'XXX');
    define('USE_PCONNECT', 'false'); // use persistent connections?
    define('STORE_SESSIONS', 'db'); // use 'db' for best support, or '' for file-based storage

  6. #6
    Join Date
    Jan 2004
    Posts
    66,373
    Blog Entries
    7
    Plugin Contributions
    274

    Default Re: Database Connection Error

    Are you sure you granted the "user" access to the "database"?

    https://www.zen-cart.com/tutorials/i...hp?article=137
    .

    Zen Cart - putting the dream of business ownership within reach of anyone!
    Donate to: DrByte directly or to the Zen Cart team as a whole

    Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
    Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.

 

 

Similar Threads

  1. error establishing a database connection
    By Spinners Derek in forum General Questions
    Replies: 7
    Last Post: 11 Aug 2015, 09:21 PM
  2. Error establishing a database connection
    By Fireflyz in forum General Questions
    Replies: 2
    Last Post: 22 Oct 2009, 12:19 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
disjunctive-egg
Zen-Cart, Internet Selling Services, Klamath Falls, OR