this was the support ticket from bluehost:

Customer did an Export of their database through phpMyAdmin. For modwerx_zencart.
After that the website started getting errors. They called in then and got their site restored. Support person told them that it was changing some permissions.

They then went today/last night to do another backup by exporting through phpmyadmin.
They download the SQL file succesfully.
No errors.
But then their website stops working again. http://modwerx.com/shop/

http://modwerx.com/shop/ blahblah/ is their zencart admin login that is also erroring.

He tried doing an Import through phpmyadmin and it went ok with no errors.
Yet the website still doesn't work.

Doing a database repair did not fix the problem: http://helpdesk.bluehost.com/index.p...article/000496



and this is the response:

It appears you're using the primary username as your MySQL user in your ~/public_html/shop/includes/configure.php settings file; This is not recommended, as it is neither secure nor stable.

The recommended method is to create a unique user for this username, and assign that username to the database it's connecting to. You can make a new user from cPanel > Databases > MySQL databases; Please see https://tutorials.bluehost.com/mysql/, which covers the creation and assignment of the user; Once the user is created, you'll open the ~/public_html/shop/includes/configure.php file and update lines 53 and 54 with the new database username and database password you created and assigned--You can do this with either File Manager > Code Edit (cPanel > Files > File Manager, "Web Root", "Go") or by downloading it to your PC via FTP, modifying then uploading the corrected file.

This should correct your problem.

If you would like us to do this for you, please provide the last 4 characters of the cPanel password, OR the last 4 digits of the credit card used to purchase or renew the account most recently, and we can do so.

Thank you,
Chad
Level II Tech Support Engineer



i opted to let them change the info for me and it restored access to the main website but not the admin section. the admin section still says:

0 DB_ERROR_NOT_CONNECTED
in:
[select * from zen_project_version WHERE project_version_key = 'Zen-Cart Database' ]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields