After DB upgrade, still getting "database upgrade required" message

[wygk]

As per the instructions, I made a copy of my 1.3.9 database to preserve my date, then ran zc_install.

I ran the "Upgrade DB from 1.3.9 to 1.5.0" and " Upgrade DB from 1.5.0 to 1.5.1" and got a few messages about things that could not be dropped (because they didn't exist) or added (because they already exist). Based on the instructions, I assumed these errors would not cause problems.

I got to the page that said:

Congratulations!
You have successfully installed Zen Cart® on your system!

However, when I went to the admin page, I got the following error:

"database upgrade required. please run the 1.3.9-to-1.5.0 upgrade via zc_install"

I tried deleting and recreating the database. I also tried running the two database upgrade steps separately, as opposed to checking both at the same time. The results are always the same.

How do I go about tracking down the problem?

[kobra]

I got to the page that said:

Congratulations!
You have successfully installed Zen Cart® on your system!

You should not be seeing this when running zc_install and selecting database upgrade

[wygk]

MORE INFO:

Here are the messages I get after "Upgrade DB from 1.3.9 to 1.5.0"

SKIPPED: Cannot drop index page_accessed on table admin_activity_log because it does not exist.
SKIPPED: Cannot drop index access_date on table admin_activity_log because it does not exist.
SKIPPED: Cannot add index idx_page_accessed_zen to table admin_activity_log because it already exists.
SKIPPED: Cannot add index idx_access_date_zen to table admin_activity_log because it already exists.

And here are the contents of the zc_upgrade_exceptions table:

| 1 | sql/mysql_upgrade_zencart_139_to_150.sql | Cannot drop index page_accessed on table admin_activity_log because it does not exist. | 2012-10-06 14:14:05 | ALTER TABLE admin_activity_log DROP INDEX page_accessed; |
| 2 | sql/mysql_upgrade_zencart_139_to_150.sql | Cannot drop index access_date on table admin_activity_log because it does not exist. | 2012-10-06 14:14:05 | ALTER TABLE admin_activity_log DROP INDEX access_date; |
| 3 | sql/mysql_upgrade_zencart_139_to_150.sql | Cannot add index idx_page_accessed_zen to table admin_activity_log because it already exists. | 2012-10-06 14:14:05 | ALTER TABLE admin_activity_log ADD INDEX idx_page_accessed_zen (page_accessed); |
| 4 | sql/mysql_upgrade_zencart_139_to_150.sql | Cannot add index idx_access_date_zen to table admin_activity_log because it already exists. | 2012-10-06 14:14:05 | ALTER TABLE admin_activity_log ADD INDEX idx_access_date_zen (access_date); |




There are no additional errors after I run "Upgrade DB from 1.5.0 to 1.5.1" ... the "Zen Cart® Setup - Finished" page is displayed. But at that point, if I try to go to the admin page, I get the "database upgrade required. please run the 1.3.9-to-1.5.0 upgrade via zc_install" message.

[DrByte]

MORE INFO:

Here are the messages I get after "Upgrade DB from 1.3.9 to 1.5.0"

SKIPPED: Cannot drop index page_accessed on table admin_activity_log because it does not exist.
SKIPPED: Cannot drop index access_date on table admin_activity_log because it does not exist.
SKIPPED: Cannot add index idx_page_accessed_zen to table admin_activity_log because it already exists.
SKIPPED: Cannot add index idx_access_date_zen to table admin_activity_log because it already exists.

Those are normal. Can be ignored.

[DrByte]

Chances are your /renamed_admin_folder/includes/configure.php file contains DB_XXXXX settings that are different from your /includes/configure.php DB_XXXXX settings.

[wygk]

YES!

That was exactly the problem. Pretty obvious, in retrospect (as is often the case). I was SURE I had replaced the admin/includes/configure.php file

Thanks so much for catching this!