Warning Your database appears to need patching to a higher level

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

Quote:

---

Originally Posted by 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.

Quote:

---

Originally Posted by 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!

Quote:

---

Originally Posted by 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:

Quote:

---

Originally Posted by 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:

Code:

---

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,

---

But mysql_upgrade_zencart_135_to_136.sql tries to add them again:

Code:

---

# 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;

---

.... would that explain it? :dontgetit

Quote:

---

Originally Posted by 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.

Quote:

---

Originally Posted by 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:

Quote:

---

Originally Posted by 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.

Quote:

---

Originally Posted by 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.p...tion_-_Upgrade

Quote:

---

Originally Posted by 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.

Quote:

---

Originally Posted by 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.p...tion_-_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

Quote:

---

********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 !!!!

AWESOME!! Worked like a charm. Thanks so much!

I upgraded from 1.3.0.1 to 1.3.6. all have gone right. Only database warning is still there. I no longer has the zc-folder , so wonder how to fix the problem. Earlier posts seem to point to this folder.

specially DrByte says zc_install should be used. I am a litlle dumbfounded.

I upgraded from 1.3.0.1 to 1.3.6. all have gone right. Very glad that 136 fixed Choose your country bug.

Only database warning is still there. I no longer has the zc-folder , so wonder how to fix the problem. Earlier posts seem to point to this folder.

specially DrByte says zc_install should be used. I am a litlle dumbfounded.

Maybe the only way to go ahead of rme is to use Pinkbeef's suggestion. I wonder if I use that method whether it will cause later big problems during upgrade or installing another mod.

Any help is appreciated. Right now I have the database warning on my site as if across my forehead.

it appears that i upgraded by fantastico, something to be avoided -according to instructions. Any help is appreciated.

Make sure that you have the correct version.php file inside the includes/ folder.

Vger

Thank you Vger for your reply.

now i have 1.3.6. In the includes folder, the version.php has the following. Does it mean it is the correct version. :

...
define('PROJECT_VERSION_NAME', 'Zen Cart');

define('PROJECT_VERSION_MAJOR', '1');

define('PROJECT_VERSION_MINOR', '3.6');

define('PROJECT_VERSION_PATCH1', '');

define('PROJECT_VERSION_PATCH2', '');

define('PROJECT_VERSION_PATCH1_SOURCE', '');

define('PROJECT_VERSION_PATCH2_SOURCE', '');

define('NEW_VERSION_CHECKUP_URL','http://ping.zen-cart.com/version_id.txt');

define('EXPECTED_DATABASE_VERSION_MAJOR', '1');

define('EXPECTED_DATABASE_VERSION_MINOR', '3.6');

?>

It is again my sucker question, sorry.
Except the warning, the site seems to work better than before. Interestingly, after upgrading thru fantastico, I found a new admin folder and suspected if that contributed in causing the warning or any conflict. so I renamed it, but to no avail.

I guess it now goes back to the original problem - you upgraded through Fantastico and not using the Zen Cart upgrade system. If you have a copy of your old site then reinstall it and then use the Zen Cart upgrade system.

Vger

is it ok to upload zc_install folder? on the following link, post #9 , I read if zc_install is deleted it can be uploaded again. Will it cause problems later with future upgrades even if it does the trick now?

http://www.zen-cart.com/forum/showth...store+database

The problem is that you've already run an upgrade via Fantastico, so trying to upgrade again in the correct way may just make things worse.

Did you backup your site before upgrading? If so, load the old site and then run the upgrade.

Vger

A real goofy question: should old i.e. present live site be wiped out and backup be uploaded?

Quote:

---

Originally Posted by zenartman

is it ok to upload zc_install folder? on the following link, post #9 , I read if zc_install is deleted it can be uploaded again. Will it cause problems later with future upgrades even if it does the trick now?

http://www.zen-cart.com/forum/showth...store+database

---

To do an upgrade you NEED to re-upload the newest zc_install folder. Use it to do your database-upgrade, and then remove the zc_install folder again.

Make sure you have done backups of your database before proceeding.

My test site is ok. But live site got problem.

Does somebody know why I have these words:

Warning: main(version.php) [function.main]: failed to open stream: No such file or directory in /home/XXXXXXXXXXXXX/public_html/artscrafts/zc_install/includes/application_top.php on line 26

Warning: main(version.php) [function.main]: failed to open stream: No such file or directory in /home/XXXXXXXXXXXXX/public_html/artscrafts/zc_install/includes/application_top.php on line 26

Fatal error: main() [function.require]: Failed opening required 'version.php' (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/XXXXXXXXXXXXX/public_html/artscrafts/zc_install/includes/application_top.php on line 26

Two guesses....

1. If you are installing/upgrading, you probably have a botched ftp and not all the files made it to the server.
2. If you are not upgrading/installing, you have everything in the wrong directory as the zc_install directory should not be there except for installation/upgrade.