1.3.0.1 to 1.3.0.2 db patch problem

25 Jun 2006, 7:58 PM

#1

besheer

New Zenner

Join Date:: Nov 2004
Posts:: 69
Plugin Contributions:: 0

1.3.0.1 to 1.3.0.2 db patch problem

How about this error when applying the db patch from 1.3.0.1 to 1.3.0.2...

SKIPPED: Cannot insert configuration_key "MAX_META_TAG_DESCRIPTION_LENGTH" because it already exists

I got it after hitting the button on the database upgrade page in the zc_install process. Now everything seems to be working, but how do I know if it actually upgraded the database? The notification message is gone and the server info shows db patch 1.3.0.2.

Also, for some reason, the auto installer says I am running database patch 1.3.0 but in the admin panel it says I have 1.3.0.1 (and now, after this "upgrade", it says 1.3.0.2). The auto installer is suggesting I upgrade from 1.3.0 to 1.3.0.1 then 1.3.0.1 to 1.3.0.2. Should I let it try?

25 Jun 2006, 8:25 PM

#2

drbyte

Sensei

Join Date:: Jan 2004
Posts:: 63,511
Plugin Contributions:: 176

Re: 1.3.0.1 to 1.3.0.2 db patch problem

The "skipped" item indicates that it already existed. In 99% of cases, that's fine, and can be ignored.

What is the URL to your 1302 site's zc_install/techsupp.php ?

.
Zen Cart - putting the dream of business ownership within reach of anyone!
Donate to: DrByte directly or to the Zen Cart team as a whole

Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.

25 Jun 2006, 9:00 PM

#3

besheer

New Zenner

Join Date:: Nov 2004
Posts:: 69
Plugin Contributions:: 0

Re: 1.3.0.1 to 1.3.0.2 db patch problem

I deleted the zc_install folder and all its contents. Should I restore the db and run the installer again? What info is in the techsupp.php file?

25 Jun 2006, 9:45 PM

#4

drbyte

Sensei

Join Date:: Jan 2004
Posts:: 63,511
Plugin Contributions:: 176

Re: 1.3.0.1 to 1.3.0.2 db patch problem

besheer:

The auto installer is suggesting I upgrade from 1.3.0 to 1.3.0.1 then 1.3.0.1 to 1.3.0.2. Should I let it try?
It is suggesting that one or more of the database-upgrade steps from 1.3.0 to 1.3.0.1 haven't completed properly.

You may tell it to go ahead, but note that rerunning the upgrade for those steps may or may not result in more "skipped" messages, or perhaps even SQL errors. It is unlikely to damage the database, but if it's failing on individual statements, then it may be necessary to do individual statements manually.

.
Zen Cart - putting the dream of business ownership within reach of anyone!
Donate to: DrByte directly or to the Zen Cart team as a whole

Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.