You are here:  » Database Fails

Support Forum



Database Fails

Submitted by BurgerBoy on Tue, 2006-12-05 23:21 in

I just installed your program on my server and during setup I keep getting the following even though I put in the database name exactly as the server told me it was.

Checking database connection...PASS

Checking database selection...FAIL check $config_databaseName value

Checking database tables...FAIL

I'm about to go crazy.

Can someone please tell me what I'm doing wrong.

Database name is "xxxxxxxx_xxxxxxxx"

Thanks

Richard

Submitted by support on Wed, 2006-12-06 07:42

Hi Richard,

The first thing I notice from having a look at your site is that the base HREF variable is not set correctly. I can tell this because the font on the setup page indicates that the stylesheet has not been loaded - so the script must be looking for it in the wrong place. For your server, you need to use:

  $config_baseHREF = "/pricet/";

However, this should not prevent access to the database. The error message indicating that the database could not be selected implies that one of the following;

i) The name is wrong; either in the database or in config.php - please double check that a database exists with exactly the same name as the value of $config_databaseName

or

ii) There may be a permissions problem; if the database username and password that you have set in config.php do have access to the database server but do not have permission to "USE" your "bestshop_pricetapestry" database.

I've emailed you a different version of setup.php which will display the MySQL error message to indicate what the problem is.

If it is a permissions problem; and assuming that you have created the database using a control panel such as cPanel or Plesk then it would indicate a fundamental configuration problem with your MySQL server and you would need to contact your host to investigate this. If, however the error message indicates "unknown database" then it will imply that the value for $config_databaseName does not match the name of the database that you have created. In this instance, I would recommend dropping the database (using your control panel) and creating it again.

If you still can't get the connection, reply to my email that I have sent to you and i'll let you know what else I'll need to know in order to help out further.

Cheers,
David.

Submitted by BurgerBoy on Wed, 2006-12-06 14:27

Hi David

Apparently it was a problem at the host - Bluehost.

They made some corrections at Bluehost and your program finally ran ok and told me that setup was completed.

Do I just keep the new setup.php file that you sent me on the server or do I need to put the old one back on the server?

Thanks for your help.

Richard

Submitted by support on Wed, 2006-12-06 15:02

Hi Richard,

Glad you're up and running! Don't worry about setup.php, it's not used once the database has been installed.

Cheers,
David.