Store quit working, suspect database

[rayw1679]

Preparing to update my wife's store -- not used in over 3 months -- I could not login to the admin, although I could login as a customer and place an order. There were no errors; it just kept reloading the login screen. Clicking for a password reset did nothing.

I re-loaded the store from a backup from when I knew she last used it, but it still did the same thing. Since I had upgraded servers, I thought perhaps my host messed up the database, so I created a new database and restored an old backup into it.

When tried to go to the store, I received "There seems to be a problem connecting to our database. Please give us a few minutes to remedy the problem." I thought perhaps something needed to be reset by running the install program, but received: "ERROR: date.timezone not set in php.ini. Please contact your hosting company to set the timezone in the server PHP configuration before continuing." Other stores are running on the same server okay.

Switched back to the old configure.php files and back to the retail store working, but admin not. I tried the SQL deletion of the Admin ID, but that didn't work, either. Suggestions appreciated.

[frank18]

Preparing to update my wife's store -- not used in over 3 months -- I could not login to the admin, although I could login as a customer and place an order. There were no errors; it just kept reloading the login screen. Clicking for a password reset did nothing.

I re-loaded the store from a backup from when I knew she last used it, but it still did the same thing. Since I had upgraded servers, I thought perhaps my host messed up the database, so I created a new database and restored an old backup into it.

When tried to go to the store, I received "There seems to be a problem connecting to our database. Please give us a few minutes to remedy the problem." I thought perhaps something needed to be reset by running the install program, but received: "ERROR: date.timezone not set in php.ini. Please contact your hosting company to set the timezone in the server PHP configuration before continuing." Other stores are running on the same server okay.

Switched back to the old configure.php files and back to the retail store working, but admin not. I tried the SQL deletion of the Admin ID, but that didn't work, either. Suggestions appreciated.

Hi Ray,

I am more so suspecting that the recent server upgrade and your store you are trying to upgrade won't play nicely together.

A few Q's:

1. what zc version is your old store?

2. what kind of upgrades happened on the server?

3. what happens if you install a vanilla zc 1.5.1 on this domain - will it work?

4. is the server a Windoze machine or does it run on Linux?

If was you I'd try to get an answer to Q 3. first.

Just a few thoughts from my end.

Cheers / Frank

[21yanks]

Do you have the correct email address to recover your password?

[DivaVocals]

I re-loaded the store from a backup from when I knew she last used it, but it still did the same thing. Since I had upgraded servers, I thought perhaps my host messed up the database, so I created a new database and restored an old backup into it.

and did you update your configure.php files with the new DB info??

[rayw1679]

Thank you for responding.

Frank18:
1. 1.5.1
2. We upgraded to a newer, faster server. Our host performed the upgrade.
3. I haven’t tried it, yet. I’m hoping to find the problem before trying to completely reinstall. Also, I sometimes have a tendency to break more than I fix, so I’d like to try the small stuff first.
4. Linux Apache.

21yanks: Yes, I verified it from the database backup. I’m not getting a password error – it just reloads. If I’m reading the backup properly, the hex values for my ID are the same prior to and after my attempt to change the password.

DivaVocals: Yes, and I discovered I typed the password wrong, but that didn’t fix it.

Running under the new copy of the database, it’s the same. I can view the store, but can’t sign-in to admin. There is are no error messages when I try, and password reset doesn’t send it to me.

This error was in the logs from when I tried to log-in: PHP Fatal error: 0B_ERROR_NOT_CONNECTED :: delete from db_cache in …/store/includes/classes/db/mysql/query_factory.php on line 120

It’s strange I can go in as a user, login, and create an order (hence, database is being accessed), but can’t login to admin. (I ran the admin password fix SQL against the new database and that didn’t work, either.)

I have downloaded the store and run WinMerge against the original and there are no program changes.

[21yanks]

start from a fresh zencart installation. re-upload your ftp files to your new installation then re-upload your backup database follow this guide:

http://www.zen-cart.com/content.php?...fferent-server

i hope it works..

[rayw1679]

Resolved; two problems. The database was indeed bad. My test store would run the new database okay, but not the old one, but the "bad" store wouldn't run with either. Apparently I somehow copied the wrong custom cookie path for running the store (wrong path), something we 1&1 users have to do when using shared SSL. (LAT9 was kind enough to figure this out a year ago.) Thanks again to all who assisted.

[frank18]

Resolved; two problems. The database was indeed bad. My test store would run the new database okay, but not the old one, but the "bad" store wouldn't run with either. Apparently I somehow copied the wrong custom cookie path for running the store (wrong path), something we 1&1 users have to do when using shared SSL. (LAT9 was kind enough to figure this out a year ago.) Thanks again to all who assisted.

Thanks for the update. Glad you got this fixed now.

[rayw1679]

Thank you, Frank18. Two problems make it difficult, as one fix doesn't fix it. I was about to completely reinstall, but then I never would have known the problem, so I wouldn't have learned anything. Thanks to all who provided advice.

[frank18]

Thank you, Frank18. Two problems make it difficult, as one fix doesn't fix it. I was about to completely reinstall, but then I never would have known the problem, so I wouldn't have learned anything. Thanks to all who provided advice.

Yep, makes sense. And, as always, the learning is in the doing.

Cheers / Frank