If you have a database configuration error, it can display in different ways. If error reporting is not turned on, it will show differently according to the browser.

Googe Chrome

The website encountered an error while retrieving http://domain.com/ It may be down for maintenance or configured

FireFox Generally displays a blank page
Internet Explorer

The website cannot display the page

While these messages are fairly general and can be for different errors as well, it is best to then turn on the error reporting as shown in a previous article. The error should then display with the beginning portion reading "Fatal error: Uncaught exception 'PrestaShopDatabaseException' with message 'Link to database cannot be established."

To troubleshoot the database configuration:

  1. Log into your hosting control panel, SSH, or FTP client.
  2. Navigate to the PrestaShop 1.5 root folder.
  3. From there, find your way to the config folder.
  4. Once in the config folder, locate the file named settings.inc.php This is the file with all of the database settings.
  5. The table below shows your the four database settings. Ensure that each one is correct. The data shown is sample data, so you will need to know the connection data for your own installation.

    define('_DB_SERVER_', 'localhost');

    define('_DB_NAME_', 'your_database_name');

    define('_DB_USER_', 'your_database_user_name');

    define('_DB_PASSWD_', 'your_database_password');

  6. Once you have corrected the database settings and saved the file, refresh the page to see if the site displays. If so, you may turn off the error reporting.

That is how you troubleshoot a database connection error in PrestaShop 1.5.

Continued Education in Course Prestashop 1.5
You are viewing Section 39: 301: PrestaShop 1.5 - Error - Link to database cannot be established
Section 38: 344: How to reset your admin password in PrestaShop 1.5
Section 40: 304: How to enable Geolocation in PrestaShop 1.5

Support Center Login


Social Media Login

Related Questions

Here are a few questions related to this article that our customers have asked:
Ooops! It looks like there are no questions about this page.
Would you like to ask a question about this page? If so, click the button below!
Ask a Question
n/a Points
2015-03-02 4:43 am

Where do i check the database settings? 

define('_DB_SERVER_', 'localhost');

define('_DB_NAME_', 'your_database_name');

define('_DB_USER_', 'your_database_user_name');

define('_DB_PASSWD_', 'your_database_password');

Staff
14,452 Points
2015-03-02 10:07 am
Hello Vivian,

Thank you for your question. You will need to create the database, then create the database user, and password and attach them to the database.

If you have any further questions, feel free to post them below.

Thank you,
John-Paul
n/a Points
2015-03-03 12:05 am

It was database on my phpmyadmin. The server and database name is correct but i am not sure what is the database password. Where i can check the database password? Can i check this on my phpmyadmin?

Staff
2,274 Points
2015-03-03 12:14 pm
Hello,

Unfortunately the password would not be displayed anywhere but you could create a new user with a new password, attach it to the database, then edit the settings.inc.php with the new user and password.

Best Regards,
TJ Edens
n/a Points
2015-03-03 11:50 pm

May i know what is going wrong for my cms page? Cms is showing Category cannot be loaded at the back office, all cms page on my website is show This page does not exist.

Here is my error page http://shoppingononline.com/cms/About-Us.html. Please help me recover the cms problem. I am appreciate your help.

 

 

 

Staff
22,613 Points
2015-03-04 11:25 am
Hello Vivian,

Sorry for the problem with your ABOUT US page. The problem is probably linked to the CMS Block Module (under Modules), and also the CMS information that should be filled out (under Preferences >CMS). Please make sure that both of those areas are active, and have the correct information for your About Us page.

I hope this helps to answer your question, please let us know if you require any further assistance.

Regards,
Arnel C.
n/a Points
2015-03-07 12:59 am

I have the same error, any one was able to find a solution for this?

CMS: Category cannot be loaded

Staff
25,046 Points
2015-03-10 7:30 am
Hello Fadi,

The error itself is cause by a missing category ID in the category table. Did you perform a CSV import prior to getting this error? You should be able to correct it by accessing the database via phpmyadmin and then adding the row with the appropriate category ID so that it can be found

Kindest Regards,
Scott M

Post a Comment

Name:
Email Address:
Phone Number:
Comment:
Submit

Please note: Your name and comment will be displayed, but we will not show your email address.

9 Questions & Comments

Post a comment

Back to first comment | top

Need more Help?

Search

Ask the Community!

Get help with your questions from our community of like-minded hosting users and InMotion Hosting Staff.

Current Customers

Chat: Click to Chat Now E-mail: support@InMotionHosting.com
Call: 888-321-HOST (4678) Ticket: Submit a Support Ticket

Not a Customer?

Get web hosting from a company that is here to help. Sign up today!