Sorry! There seems to be a problem connecting to our database.

[albripet]

It now shows that I have been moved from Starka to Chopin. According to the updates, all transfers have been complete, however I am still having database issues. I receive the following error:

Sorry! There seems to be a problem connecting to our database. Please give us a few minutes to remedy the problem. Thank you.

My URL is: http://thebargainshed.x10hosting.com/zencart

Please help ASAP. I've been down for over a month!!!

Thanks,
Peter

 

[vishal]

The databse name is localhost,check it.

 

[Gouri]

It now shows that I have been moved from Starka to Chopin. According to the updates, all transfers have been complete, however I am still having database issues. I receive the following error:

Sorry! There seems to be a problem connecting to our database. Please give us a few minutes to remedy the problem. Thank you.

My URL is: http://thebargainshed.x10hosting.com/zencart

Please help ASAP. I've been down for over a month!!!

Thanks,
Peter

Hi Peter,

Did you checked the database host in your config file. It should point to localhost.

 

[albripet]

Are you talking the configuration.php within Admin under Zen-Cart? Nothing listed in the file about Database or local host.
I am sorry, I'm a little green this level. I'm basic HTML, but can navigate the directory structure of the Zen folder and view the contents of the files no problem. I just need to know where to look and what to look for.
Thanks BUNCHES!

Peter

 

[descalzo]

Should be in a section of the file that looks a bit like:

/ define our database connection
define('DB_TYPE', 'mysql');
define('DB_PREFIX', 'zen_');
define('DB_SERVER', 'localhost');
define('DB_SERVER_USERNAME', '*******');
define('DB_SERVER_PASSWORD', '**********');
define('DB_DATABASE', '**********');

EDIT/ADD:

Note that there are two configuration files...

On the server locate the file: /catalog/includes/dist-configure.php
Rename this file to configure.php and change the permissions to 777 (read-write-execute for all)

Next, on the server locate the file: /catalog/admin/includes/dist-configure.php
Rename this file to configure.php and change the permissions to 777 (read-write-execute for all)

 

[albripet]

Okay, I found the configuration.php under zencart/admin/includes. It had the section you spoke of. I changed it to point to localhost for the zen cart database...it still doesn't work.

Here's how it reads now:

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

 

[Zubair]

First of all remove your passowrd from the above post..

Edit/Add: Go to cpanel then MYSQL Databases, Delete the user albripet_zencart remember Only User not database...

Then add a new user with same name.. and add it to database with all priviges.
Then update password in config file..
and see if your problem get solved

 

[albripet]

Okay...I deleted the user albripet_zencart and re-add with all privileges. Should I do anything with the check/repair. I did. It said all is okay.
At any rate, I put the "new" password between the ' and the ' for DB_SERVER_PASSWORD.
Still no work.
BTW, I have another user name tied to the database. It's albripet_peter
Should I remove that one?

Thanks!

 

[Zubair]

Okay...I deleted the user albripet_zencart and re-add with all privileges. Should I do anything with the check/repair. I did. It said all is okay.
At any rate, I put the "new" password between the ' and the ' for DB_SERVER_PASSWORD.
Still no work.
BTW, I have another user name tied to the database. It's albripet_peter
Should I remove that one?

Thanks!

Your Website is opening fine Now!

Are you still having problem??

 

[albripet]

No more problems...THANK YOU for ALL of your help!!!
:biggrin:

Peter