1st time user - Confused on upgrade process

[RonThePartsGuy]

I figured out the configure.php issue.

Now the demo site says I need to upgrade the database and I follow the process to do such, but the Database Information -- Upgrade Sniffer is incorrectly sniffing the wrong database.

It says that the info is pulled from the configure.php settings but they are not what the configure.php settings say.

Where is the Database Information -- Upgrade Sniffer getting the database info from? More importantly how do I get it to upgrade the correct database and not the one is thinks it should upgrade?

It must have been a cache issue in Firefox?

I started the upgrade process in Chrome and it sniffed the correct database this time.

[DrByte]

It must have been a cache issue in Firefox?

I started the upgrade process in Chrome and it sniffed the correct database this time.

None of the DB_xxxx credentials would be affected by the choice of browser, since that data is on the PHP end, not the browser end.

[RonThePartsGuy]

None of the DB_xxxx credentials would be affected by the choice of browser, since that data is on the PHP end, not the browser end.

Interesting. It wouldn't find the correct database using Firefox but it did using Chrome. Not sure why or how.

Now I have other database upgrade issues:

When I try to do the upgrade I got this:

ATTENTION: Problems Found

• Admin Password required to proceed with upgrade more info...
• Admin Password required to proceed with upgrade more info...
• Could not rename all tables more info...

I know what my admin password is and I never asked it to rename all the tables. Any idea why this is happening?

[RonThePartsGuy]

I went ahead with the database upgrade and I ended up with these errors. What do they mean exactly and what do I do to fix them?

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.

[DrByte]

I went ahead with the database upgrade and I ended up with these errors. What do they mean exactly and what do I do to fix them?

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 just informational, and are a result of the upgrade process trying to do steps that had apparently already been done somehow, or were not needed.
So, those particular messages can be ignored.
If there were a serious functional problem after upgrading, those messages might be useful for troubleshooting later. But those particular ones don't indicate anything risky.

[RonThePartsGuy]

Those are just informational, and are a result of the upgrade process trying to do steps that had apparently already been done somehow, or were not needed.
So, those particular messages can be ignored.
If there were a serious functional problem after upgrading, those messages might be useful for troubleshooting later. But those particular ones don't indicate anything risky.

Thank you!

[RonThePartsGuy]

The live site is on v1.3.9h so I downloaded the zen-cart-v1.3.9h-full-fileset-10262010.zip file and ran WinMerge between the two and there are several differences.

IMO: there are lots of major code differences that does look like add-ons.

Files like functions_prices.php & attributes_controller.php have serious code differences.

I am guessing that someone has added some add-ons in the past to this site. Other than using a program like WinMerge... is there an easy way to see what has been added to the site?

Is there somewhere in the admin area that lists exactly what add-ons have been applied?

[kobra]

Is there somewhere in the admin area that lists exactly what add-ons have been applied?

No - one should keep track of the addons that have been installed

[RonThePartsGuy]

No - one should keep track of the addons that have been installed

I agree with you and I have extensive notes on all the other sites that I have built or worked on in the past, but I just inherited this site yesterday morning. The last person to work on it is gone and left no notes or anything so I am on my own to figure it all out.

[haredo]

Every mod i have ever installed the developers always paste the name in the coding ...
Winmerge carefully and you will find your modules tucked in the original code of zen cart ...