Zen Cart Logo
Forums / Upgrading from 1.2 to 1.3.x / Database upgrade 1.3.0.1 to 1.3.0.2 - some table skipped?

Database upgrade 1.3.0.1 to 1.3.0.2 - some table skipped?

Locked

Started by donnyw on 20 Jul 2006, 7:46 AM · Views: 2,394

Results 1 to 7 of 7
This thread is locked. New replies are disabled.
20 Jul 2006, 7:46 AM
#1
donnyw avatar

donnyw

New Zenner

Join Date:
Apr 2006
Posts:
9
Plugin Contributions:
0

Database upgrade 1.3.0.1 to 1.3.0.2 - some table skipped?

I just upgraded my zencart and database from v1.3.0.1 using v1.3.0.2 changed files set only, already put new files and went to zc_install and click 'upgrade database'.

It works, but some tables skipped as below:

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

Should I manually replace the tables, or is there any method to avoid this little problem?

20 Jul 2006, 4:22 PM
#2
dbltoe avatar

dbltoe

Totally Zenned

Join Date:
Jan 2004
Location:
N of San Antonio TX
Posts:
9,893
Plugin Contributions:
20

Re: Database upgrade 1.3.0.1 to 1.3.0.2 - some table skipped?

What the system is telling you is that you already created the tables in a previous upgrade.

You can generally disregard > SKIPPED: Cannot insert various statements seen here because it already exists because the system is telling you it wanted to create it but it was already there.

Need a hand with Zen Cart? Hire the team at myZenCartZone.com for upgrades, repairs, and custom plugins.
Zen Cart Certified hosting at myZenCartHost.com

21 Jul 2006, 12:36 AM
#3
donnyw avatar

donnyw

New Zenner

Join Date:
Apr 2006
Posts:
9
Plugin Contributions:
0

Re: Database upgrade 1.3.0.1 to 1.3.0.2 - some table skipped?

Thanks.. I understand your point.

Does it mean I already have the latest database's tables for 1.3.0.2?
Actually I tested the upgrade not on the live site, still doing testing in my PC.

I have a thought that those skipped tables still had previous 1.3.0.1 entries in them... since MetaTag was one of the bug issue found in 1.3.0.1.. I'm afraid that the bug not yet resolved.

Anyhow I will check and compare both version entries and see whether they are the same or not.

21 Jul 2006, 6:07 AM
#4
dbltoe avatar

dbltoe

Totally Zenned

Join Date:
Jan 2004
Location:
N of San Antonio TX
Posts:
9,893
Plugin Contributions:
20

Re: Database upgrade 1.3.0.1 to 1.3.0.2 - some table skipped?

The Meta Tag problems were in code, not data.

Besides, had there been a problem in the database, the SQL would have overwritten or deleted/replaced the offending item.

The devs get a BIG :thumbsup: for that one and maybe a little :hug: too.

OR.... Just throw money!

Need a hand with Zen Cart? Hire the team at myZenCartZone.com for upgrades, repairs, and custom plugins.
Zen Cart Certified hosting at myZenCartHost.com

14 Aug 2006, 8:46 AM
#5
donnyw avatar

donnyw

New Zenner

Join Date:
Apr 2006
Posts:
9
Plugin Contributions:
0

Re: Database upgrade 1.3.0.1 to 1.3.0.2 - some table skipped?

Thanks dbltoe

Yesterday I tried to upgrade my site using the same way and getting that warning again.

However I assume that I wont have problem because of that, since it is not essential.

I just curious why no other people has the same problem with me despite I follow normal upgrading procedure :) ... maybe the mistake on my side.

14 Aug 2006, 9:19 AM
#6
drbyte avatar

drbyte

Sensei

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

Re: Database upgrade 1.3.0.1 to 1.3.0.2 - some table skipped?

Several others have encountered the same warning messages for the same reason you did. The message is indicating that some upgrade steps were not necessary for "your" database.

.
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.

15 Aug 2006, 2:37 AM
#7
donnyw avatar

donnyw

New Zenner

Join Date:
Apr 2006
Posts:
9
Plugin Contributions:
0

Re: Database upgrade 1.3.0.1 to 1.3.0.2 - some table skipped?

Oh glad to hear that, thanks DrByte!