Skipped upgrade statements: 4

I want to make sure that I understand this right.

I have done all the backup of the database and the site to my computer onto a disk.

My site is on my main domain name like mysite.biz

So I need to do the following:

1. Make a new separate database for the new version.

2. Then upload the old database into the new database.

3. Make a new directory like /test-site/ like this mysite.biz/test-site/

4)Upload the new version of zen cart into the /test-site/ then make sure its working correctly.

5. Then upload the new version of zen cart into the main directory (mysite.biz) then configure both configure.php files that can connect to the new database.

https://www.zen-cart.com/upgrade

Should I go ahead and upload the new version on the main domain and then do the upgrade on the same database or a brand new database?

Follow the instructions.

The database will not let me upgrade to 1.5.0 because it gave me 4

NOTE: Skipped upgrade statements: 4
See details at bottom of page for your inspection.
(Details also logged in the "upgrade_exceptions" table.)
Note: In most cases, these failed statements can be ignored,
as they are indications that certain settings may have already been set on your site.
If all the suggested upgrade steps have been completed (no recommendations left),
you may proceed to Skip Upgrades and continue configuring your site.

then at the bottom says:

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.

When I change the Database information to the new database to do the upgrade then when I click save Database savings. It still shows the old database name instead of the new one. How come is it doing that?

Moderator's note: new thread merged with existing thread on same topic.

Kim,,, Please Help me!

bkeaton:

The database will not let me upgrade to 1.5.0 because it gave me 4

NOTE: Skipped upgrade statements: 4
See details at bottom of page for your inspection.
(Details also logged in the "upgrade_exceptions" table.)
Note: In most cases, these failed statements can be ignored,
as they are indications that certain settings may have already been set on your site.
If all the suggested upgrade steps have been completed (no recommendations left),
you may proceed to Skip Upgrades and continue configuring your site.

then at the bottom says:

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 messages indicate that there were some cleanup steps that were not required in the upgrade process. Those messages can be ignored.

bkeaton:

When I change the Database information to the new database to do the upgrade then when I click save Database savings. It still shows the old database name instead of the new one. How come is it doing that?
I'm not sure I fully understand your question, but I'll offer this based on a very popular mistake:
Your configure.php files are probably read-only, so it won't be able to replace the contents, without being writable.

I finally got it upgraded

How did you do?

I received the same error, but when I go to the see my store. There is nothing there. So I opened the configure.php file in the admin folder, and it's completely blank. Can someone explain what happened and what I can do. I am in a perpetual loop of re-installing. Obviously, I can't access the back end of the store either as it doesn't exist. What happened?

BTW, the files are both config files are set for write for the user.

Thanks,

Marci