Problem upgrading from 1.5.4 to 1.5.5

[Arunachala]

I have a live store at http://bookstore.arunachala.org which is based on version 1.5.4. I have two other bookstores which I upgraded from 1.5.1 and 1.5.4. But this one at the stage of zc_install does not recognize that my database needs upgrade. It says I have a current database and install will wipe out everything. The way I created the database as always is do a mysqldump of the old database and load it into a new one using mysql command. Normally this should come up with a zc-install upgrade database command but not this time. I have done this many times and can't see what I am doing wrong. Any suggestion would be helpful.

[DrByte]

99% of the time it's because you used a non-empty DB_PREFIX on the "live" site, but on your "test" site you left it blank or used some other prefix, meaning all the tablenames it's looking at are a different set of data.

That's why the instructions mention to make sure when you're setting up your temporary site that you look up the DB_PREFIX of the live site and use that same value when setting up the temporary testing/staging site.

[Arunachala]

I do have db_prefix. I will check and fix that and report what is happening. Thanks a lot Sir

[Arunachala]

The test site and the live site both had no prefix. I added prefix to the test site's configure file and c_install started offering the database upgrade option. However it finds the superuser password incorrect even though it works fine on the live site. Stuck again. Any suggestions?

[mc12345678]

I do have db_prefix. I will check and fix that and report what is happening. Thanks a lot Sir

The test site and the live site both had no prefix. I added prefix to the test site's configure file and c_install started offering the database upgrade option. However it finds the superuser password incorrect even though it works fine on the live site. Stuck again. Any suggestions?

This doesn't make sense. It does and it doesn't have a db_prefix value, then entering some "random" prefix into the test site resulted in an upgrade notice. To me this would indicate a need to review the database that is referenced in your test site's includes/configure.php to see what is present and how it relates to the database that is the live site. In working with both, use caution not to make changes (if any) to the wrong database, but the above doesn't make any sense...

[Arunachala]

Clarification. Both live and test sites have database prefixes. I had left them both blank but zc_install didn't offer the upgrade option perhaps confusing it to be the latest version of database. After Dr. Byte's suggestion added prefix to configure file and upgrade option appeared. But it is not recognizing the valid super user admin password. The two databases are different created by mysqldump of live site. There is now way live site can be affected. Need to solve the admin password problem now for the upgrade to proceed

[mc12345678]

Use this to address the password issue: http://www.zen-cart.com/content.php?44

[Arunachala]

Use this to address the password issue: http://www.zen-cart.com/content.php?44

Tried everything but can't go past zc_install error or can't validate admin credentials. Don't know what is causing this?

[DrByte]

Question: in the database, after you followed the FAQ article above to insert an admin user of "Admin", and the password hash was set to "351683ea4e19efe34874b501fdbf9792:9b", after you attempted to login as "Admin" with pwd of "admin", did the password in the database for that user stay the same, or did it change to something else starting with "$2y$10$" ?

Also, what's the PHP version on the server?
Who's the hosting company?

[Arunachala]

Dear Drbyte The database associated with 1.5.4 version had a patch making it 1.5.5. That explains why the zc_install was not able to upgrade. Everything OK now. I have found a way to use the same database with updated files of 1.5.5