When I log into the Admin section of my site I get the following messages

Warning Your database appears to need patching to a higher level. See Tools->Server Information to review patch levels.

My info on that page is:

Zen Cart 1.3.6
Database Patch Level: 1.3.5
v1.3.5 [2006-09-12 20:29:45] (Fresh Installation)

I upgraded from 1.3.5 this morning and believe I did everything right including the upgrade database process in the zc_installer.

My site appears to be running fine except for the error message.

How can I fix it?

Thanks!:smile:

If the database version indicator is not v1.3.6, then that stage did not complete properly. Best to re-do the db-upgrade step via zc_install.

I tried re-upgrading the database by running zc_install again. However, I am still having the same problem:

Zen Cart 1.3.6
Database Patch Level: 1.3.5
v1.3.5 [2006-09-12 20:29:45] (Fresh Installation)

I think I am doing everything correctly (Following step 3 of the Upgrade Proceedure):

I made a new db called "newstore" I backed up my old db "store" by following these steps:

1. Selecting the original database in the database dropdown panel on the left in phpMyAdmin.*

2. When that page opens, select Export from the top tabs.

3. Select all.

4. Select MySql

5. Ensure that Structure is checked on the right of the page and that Add DROP TABLE, Add AUTO INCREMENT and Enclose table and field names with backquotes are all checked.

6. The defaults in the Data panel seem to work fine for me (they are Complete inserts, Extended inserts and Use hexadecimal for binary fields all checked

7. Make sure Export Type is INSERT

8. Check Save as file

9. Up to you whether you use compression or not.

10. Click Go.

Save this to your hard-drive.

I restored this .sql file to my "newstore" db.

I made sure that the includes/configure.php and admin/includes/configure.php are uploaded.

I edited in my db name, pw, and user in includes/configure.php.

I run zc_install. At the "Prerequisites" screen I get the message at the top:

"Upgrade Mode Available

Previous Zen Cart Installation Found
Database appears to be Zen Cart v1.3.6"

I click the Database upgrade button and go to the next screen where I get the message:
"Database Information -- Upgrade Sniffer predicts: *** No upgrade required***"

I fill in my information anyway and click the upgrade button.

I get these errors:

SKIPPED: Cannot insert configuration_key "DEFINE_PAGE_NOT_FOUND_STATUS" because it already exists
SKIPPED: Cannot insert configuration_key "CURRENCY_UPLIFT_RATIO" because it already exists
SKIPPED: Cannot insert configuration_key "CURRENCY_UPLIFT_RATIO" because it already exists
SKIPPED: Cannot insert configuration_key "CURRENCY_UPLIFT_RATIO" because it already exists
SKIPPED: Cannot insert configuration_key "CURRENCY_UPLIFT_RATIO" because it already exists
SKIPPED: Cannot insert configuration_key "CURRENCY_UPLIFT_RATIO" because it already exists
SKIPPED: Cannot insert configuration_key "CURRENCY_UPLIFT_RATIO" because it already exists
SKIPPED: Cannot insert configuration_key "CURRENCY_UPLIFT_RATIO" because it already exists
SKIPPED: Cannot insert configuration_key "SUBCATEGORY_IMAGE_TOP_WIDTH" because it already exists
SKIPPED: Cannot insert configuration_key "SUBCATEGORY_IMAGE_TOP_HEIGHT" because it already exists
SKIPPED: Cannot insert configuration_key "SHOW_SHOPPING_CART_EMPTY_NEW_PRODUCTS" because it already exists
SKIPPED: Cannot insert configuration_key "SHOW_SHOPPING_CART_EMPTY_FEATURED_PRODUCTS" because it already exists
SKIPPED: Cannot insert configuration_key "SHOW_SHOPPING_CART_EMPTY_SPECIALS_PRODUCTS" because it already exists
SKIPPED: Cannot insert configuration_key "SHOW_SHOPPING_CART_EMPTY_UPCOMING" because it already exists
SKIPPED: Cannot insert configuration_key "PRODUCT_LIST_CATEGORY_ROW_STATUS" because it already exists
SKIPPED: Cannot insert configuration_key "SHOW_NEW_PRODUCTS_UPCOMING_MASKED" because it already exists
SKIPPED: Cannot insert configuration_key "META_TAG_INCLUDE_MODEL" because it already exists
SKIPPED: Cannot ADD column get_term_table because it already exists.
SKIPPED: Cannot ADD column get_term_name_field because it already exists.
SKIPPED: Cannot ADD column get_term_name_field because it already exists.
SKIPPED: Cannot ADD column get_term_name_field because it already exists.
SKIPPED: Cannot ADD column get_term_name_field because it already exists.
SKIPPED: Cannot ADD column coupon_zone_restriction because it already exists.

I am at my wits end. I have tried reinstalling zc at least 6 times. I have deleted my new database and recreated it at least 3 times. I'm not sure where I am going wrong.

Any help is greatly appreciated.

Thanks

bgroup99:

I edited in my db name, pw, and user in includes/configure.php.Did you edit the same information in your /admin/includes/configure.php ?

I was wondering about that. I did not do it because I read in the 2.readme_how_to_upgrade:

"EDIT your "/zen_new/includes/configure.php" file and ensure that your DATABASE_NAME matches your NEW database. Also verify database username and password in case that information has changed. Save this file, and be sure to upload it as part of the next step:"

That section of the upgrade readme is sort of unclear. I'll try editing both /includes/configure.php and /admin/includes/configure.php and re-running zc_install.

I changed both configure.php files and re-ran zc_install.

The only errors I had were:

NOTE: Skipped upgrade statements: 2
See details at bottom of page for your inspection.
(Details also logged in the "upgrade_exceptions" table.)

...

SKIPPED: Cannot ADD column get_term_table because it already exists.
SKIPPED: Cannot ADD column get_term_name_field because it already exists.
SKIPPED: Cannot ADD column get_term_name_field because it already exists.
SKIPPED: Cannot ADD column get_term_name_field because it already exists.
SKIPPED: Cannot ADD column get_term_name_field because it already exists.

I checked the upgrade_exceptions table, but I'm not exactly sure what is there -- I don't know much about sql.

I guess they don't matter though because it worked. I'm all upgraded. I feel stupid for only editing the one configure.php file, but the readme is misleading.

Thanks!

I got the same error with the "Cannot ADD column get_term_name_field because it already exists." statement. Does anyone know if this is normal?

I am upgrading from 1.3.5 to 1.3.6 as well.

bgroup99:

SKIPPED: Cannot ADD column get_term_table because it already exists.
SKIPPED: Cannot ADD column get_term_name_field because it already exists.
SKIPPED: Cannot ADD column get_term_name_field because it already exists.
SKIPPED: Cannot ADD column get_term_name_field because it already exists.
SKIPPED: Cannot ADD column get_term_name_field because it already exists.

I checked the upgrade_exceptions table, but I'm not exactly sure what is there -- I don't know much about sql.

I guess they don't matter though because it worked. I'm all upgraded.

I don't think those messages are always an indication of a serious problem. If your store is running alright I wouldn't worry about it.

Those are only alerts. They are not errors. The descriptive explaining the messages also indicates that those alerts are not necessarily indications of a problem. They are simply indicating to you that something being done by the upgrade was "already done" and didn't need doing. There could be many reasons for this ... some important. Some not. In most cases it's a non-issue if the message simply says "SKIPPED .... ...... already exists, etc"

Thanks for the clarification on this one. I am quite new to Zencart and this was my first upgrade. My store is not yet live, but I am having a blast with Zencart (My previous store was CRELoaded but their support is non-existent). Go Zencart!

Daphisto:

I got the same error with the "Cannot ADD column get_term_name_field because it already exists." statement. Does anyone know if this is normal? I am upgrading from 1.3.5 to 1.3.6 as well. Same here :huh: > DrByte:

There could be many reasons for this ... some important. Some not. Well now. I dug out the original mysql_zencart.sql in zen-cart-v1.3.5-full-fileset-09042006 and it seems that get_term_table and get_term_name_field were already added in the original v1.3.5 install: ```
CREATE TABLE get_terms_to_filter (
get_term_name varchar(255) NOT NULL default '',
get_term_table varchar(64) NOT NULL,
get_term_name_field varchar(64) NOT NULL,

Updating table get_terms_to_filter

ALTER TABLE get_terms_to_filter ADD get_term_table varchar(64) NOT NULL;
ALTER TABLE get_terms_to_filter ADD get_term_name_field varchar(64) NOT NULL;

imac:

.... would that explain it?Yes ... it explains it completely.

But, since those settings were missed from the upgrade-script for folks upgrading to 1.3.5, they had to be added to the upgrade script for 1.3.6 so folks who never saw any bug reports were brought up to date.

Does that close the gap on understanding it? I didn't detail that earlier, because I was quite convinced that the original poster didn't really care about the exact technical "why" behind it.

DrByte:

... since those settings were missed from the upgrade-script for folks upgrading to 1.3.5, they had to be added to the upgrade script for 1.3.6 so folks who never saw any bug reports were brought up to date. Fair do's Doc. But for those of us who do try to keep up-to-date and apply mods and upgrades as meticulously as we can, error messages can be a bit of a shock :lamo: > DrByte:

Does that close the gap on understanding it? Certainly does. Your good works on this front much appreciated as always :thumbsup: But you know how it is. Some of us just can't rest until we know the far end of everything. I know I should be getting out more, but ZC is developing at such a rate there just aren't enough hours in the day to keep on top of it all. > DrByte:

I didn't detail that earlier, because I was quite convinced that the original poster didn't really care about the exact technical "why" behind it. Too true. I would guess probably most ZC users don't. But now you've got me thinking. I don't really understand such things, but suspect that trying to implement a Windows-style, one-click upgrade process would probably be a nightmare which would cost more than it would benefit. But Debian's repository system works brilliantly. Might adding something like that to the route map put ZC not just streets, but whole highways ahead of the competition?

I had the same issue, and this worked for me.

Remember to backup your database first**

I have only tried this on a 1.3.5 to a 1.3.6 upgrade.**

Go to the folder that you downloaded Zen Cart into, open the Zen Cart folder and locate the folder “zc_install” , in there you will find a folder called “sql”, open it and find the sql file “mysql_upgrade_zencart_135_to_136.sql”.
Open this file and copy its contents

Log into Zen Cart admin.
Go to tools / install SQL patches.
Now past the file “mysql_upgrade_zencart_136_to_136.sql”. Into the window and hit send.
This will update the database to 1.3.6.
Don’t worry about any messages about “could not install………….
As you have already installed the files, all you need from this is to add the data.

And remember, “don’t go playing with any Bug Eyed Monsters”.

Pinkbeef,
While successful for you, this is not the best way to do an upgrade.
Best practice is to follow http://www.zen-cart.com/wiki/index.php/Installation_-_Upgrade

pinkbeef:

I had the same issue, and this worked for me.

Remember to backup your database first**

I have only tried this on a 1.3.5 to a 1.3.6 upgrade.**

Go to the folder that you downloaded Zen Cart into, open the Zen Cart folder and locate the folder “zc_install” , in there you will find a folder called “sql”, open it and find the sql file “mysql_upgrade_zencart_135_to_136.sql”.
Open this file and copy its contents

Log into Zen Cart admin.
Go to tools / install SQL patches.
Now past the file “mysql_upgrade_zencart_136_to_136.sql”. Into the window and hit send.
This will update the database to 1.3.6.
Don’t worry about any messages about “could not install………….
As you have already installed the files, all you need from this is to add the data.

And remember, “don’t go playing with any Bug Eyed Monsters”.

Your tip worked successfully for me and saved my time. Thank you so much! Hopefully others would be pleased with your tip like I am.

Note: Back up your database and the store to prevent big loss and excessive work to fix the problem.

dbltoe:

Pinkbeef,
While successful for you, this is not the best way to do an upgrade.
Best practice is to follow http://www.zen-cart.com/wiki/index.php/Installation_-_Upgrade

This was never intended as a way to upgrade.
It was the way I resolved the " Warning Your database appears to need patching to a higher level" issue.

Had you bothered to read the title of this post you would have known that

Actually, my glasses are working okay. As you stated in your post> ********I have only tried this on a 1.3.5 to a 1.3.6 upgrade.**********I wanted to make sure someone else did not misread it as a miracle cure for upgrade. My wording should not have backwards possibly been.

I tried the 1.35 to 1.36 upgrade SQL and got an error message:
1064 You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '0', '1'),')' at line 1
in:
[INSERT INTO zen_configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) values ('Define Page-Not-Found Status', 'DEFINE_PAGE_NOT_FOUND_STATUS', '1', 'Enable the Defined Page-Not-Found Text from define-pages?
0= Define Text OFF
1= Define Text ON', '25', '67', now(), now(), NULL, 'zen_cfg_select_option(array('0', '1'),');]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.

What do I do with THAT?
Thanks, guys!!

You need to do your upgrade by running the zc_install script via your browser .... DO NOT UPGRADE BY USING THE SQL-PATCH TOOL !!!!