Upgrading to 1.3.9h problem

A while ago two of my sites were hacked. I was able to finally clean them (I hope!) and now I'm trying to upgrade. One of the sites upgraded OK, the other one I'm stuck. I did follow directions correctly (again, I hope!) but I can't get it to work at all. Before the upgrade, I placed the site in Maintenance mode.

Here's what I did:

1. Created a new folder
2. Created new database
3. Transferred old one into new DB
4. Upgraded
5. Made changes to two config files

Now I go to the directory where the new site is supposed to be and I get a blank page, url is: http://xxxxxxx.com/xxx/index.php?main_page=down_for_maintenance
I try to go to admin (I changed the admin folder name) and I get this error: 0 DB_ERROR_NOT_CONNECTED
in:
[db_cache table]
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.

I put in the right username and pwd in config files so I don't know what's going on and I've about have it with this! :(

0 DB_ERROR_NOT_CONNECTED -- this is a result of the database information being incorrect in the configure.php files. The DB_SERVER, DB_DATABASE, DB_USERNAME, DB_PASSWORD, DB_PREFIX must all be correct for the server you're on.

If it's happening only on the admin side, then your /renamed-admin/includes/configure.php file has the wrong information.

That's what I thought, too - and it's true, my CPanel was messing up with db usernames. Fixed it.

BUT, my troubles have not ended. I'm able to login to admin but it says my DB needs upgrading to 1.3.9 - I thought I had already done that! :( How can I do it now?

And my store still doesn't show, it's a blank page with the url saying "index.php?main_page=down_for_maintenance" - although from the admin panel it is not in maintenance mode.

Sounds like your non-admin configure.php has different DB settings than your admin configure.php file.

DrByte:

Sounds like your non-admin configure.php has different DB settings than your admin configure.php file.

"// define our database connection" is the same on both files :(

Also, I did delete the install files but the admin area is telling me I need to upgrade my DB. What should I do?

is the same on both files
Did you check the files ON THE SERVER? Or just the copy on your PC?

No wonder they call you the doctor! :) You're right, for some strange reasons, that config file wasn't going through an FTP client. Had to do an upload through cPanel. I also did the "upgrade database" through zc_install. THANK YOU!

I upgraded to 1.39h as the instruction said.

The only thing different I did is that once I had the test store working on a new DB which was restore from original DB and upgraded, I decided to use that as my new original DB.

I moved the test store files to the root directory including the config files that point to the new DB (making sure the config files were modified to the correct root paths). Everything seems to be working well, but when I tried to disconnect my test store from the new DB, it brings down the upgraded store as well.

So I change the configs of the test store to point to the old DB, yet it somehow linked to the upgraded store because now on the upgraded store it give me a mesage I need to patch the DB (even though the new DB has already being upgraded).

Does this makes sense?

Basically I have the upgraded store working and just want to delete my test store files without affecting my upgraded store.

Thanks,