errors after trying to backup

i cant seem to get into the admin page or view any part of the shop directory after i tried to do a backup. you can see the error using the link below.

http://modwerx.com/shop/

i always look at the tutorial in the support section but i forgot to click on the ZC database this time. i only tried to export and the only other thing that was done was that the /shop folder on the server was downloaded for backup. the best backup i have is from nov. of '09. anyone know if i may be able to fix this?

this is the error from the admin login:

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.

modwerx:

i cant seem to get into the admin page or view any part of the shop directory after i tried to do a backup. you can see the error using the link below.

http://modwerx.com/shop/

Shop seems to be working now???

Cheers
Rod

RodG:

Shop seems to be working now???

Cheers
Rod

i called bluehost support last night and the lady found out a file permission somehow got changed so you can view the site now but the admin page error is still showing up.

modwerx:

i called bluehost support last night and the lady found out a file permission somehow got changed so you can view the site now but the admin page error is still showing up.

On this basis you'll need to call them again to check the file permissions in the admin section.

There's no point in looking for the cause elsewhere until the rest of the file permissions have be thoroughly checked and verified.

Cheers
Rod

the second guy at bluehost restored the site from a backup from 4/2/10 but since i still didnt have a backup i tried to backup the site again last night and the same thing has happened again. this time i followed the tutorial to the letter so i have no idea what the heck is going on.

modwerx:

the second guy at bluehost restored the site from a backup from 4/2/10 but since i still didnt have a backup i tried to backup the site again last night and the same thing has happened again. this time i followed the tutorial to the letter so i have no idea what the heck is going on.

Exactly which tutorial was it that you followed? (It may give a clue in regards to what may have gone wrong with your attempts)

Cheers
Rod

RodG:

Exactly which tutorial was it that you followed? (It may give a clue in regards to what may have gone wrong with your attempts)

Cheers
Rod

https://www.zen-cart.com/tutorials/index.php?article=103

this is the one for backing up the DB that i used. the guy i talked to today opened a support ticket but everytime ive tried to backup it seems to lock the DB up..

also im using 1.3.8a ZC install

modwerx:

https://www.zen-cart.com/tutorials/index.php?article=103

this is the one for backing up the DB that i used.

I can't see anything in this tutorial that would shed any light on the problem, so a couple more questions are in order.

Firstly, the tutorial mentioned gives details on how to backup and restore the DB. Could you please confirm that the problems arise only after doing a backup rather than after a restore.

Secondly, when you perform the backup, can the backup file be found on your local computer (PC) ok? Is this file readable? (can it be unzipped without error)

Are there any other clues that may be relevant? (EG: Error or warning messages during the backup process)

Cheers
Rod

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.php/kb/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

Your DB_xxxxxx settings in your /admin/includes/configure.php file need to match the settings in your /includes/configure.php file.

thanks rod and dr. byte. after looking around for a few minutes and changing the configure.php for the shop and admin both seem to be working fine now. any idea what may have caused it? was it really an instability caused by the DB? ive been with bluehost for a while now and have backed up the same way many times before and havent had a problem with it until recently.

oddly enough, the root cause of whatever you've encountered seems quite elusive

thanks again. im thinking it may have something to do with some recent changes that bluehost made. im not sure exactly what changes they did but i had to reset my password for security reasons.

modwerx:

thanks rod and dr. byte. after looking around for a few minutes and changing the configure.php for the shop and admin both seem to be working fine now. any idea what may have caused it?

Nothing that can explained with the information provided.

Cheers
Rod