Zen Cart Logo
Forums / Upgrading from 1.3.x to 1.3.9 / Your database appears to need patching to a higher level. See Tools->Server Informati

Your database appears to need patching to a higher level. See Tools->Server Informati

Views: 52,182

Results 1 to 20 of 23
16 Nov 2006, 2:51 PM
#1
chriskelm avatar

chriskelm

New Zenner

Join Date:
Nov 2006
Posts:
4
Plugin Contributions:
0

Your database appears to need patching to a higher level. See Tools->Server Informati

I ran the recommended upgrade for ZenCart that was recommended by my host. It was an auto install offered. However, it errored out and I know get the following message: "Your database appears to need patching to a higher level. See Tools->Server Information to review patch levels." It is visible on the homepage, and in the admin area. I went as instructed to the admin area, server info and see the following:

**Server Host: **gs14.inmotionhosting.com (205.134.240.228) **Database Host: **localhost (127.0.0.1) **Server OS: **Linux 2.6.9-42.0.3.ELsmp **Database: **MySQL 4.0.27-standard-log **Server Date: **11/16/2006 06:49:56 **Database Date: **11/16/2006 06:49:56 **Server Up Time: **06:49:56 up 25 days, 4:23, 2 users, load average: 2.58, 2.84, 2.96
**PHP Version: **4.3.11 (Zend: 1.3.0)
**HTTP Server: **Apache/1.3.36 (Unix) mod_auth_passthrough/1.8 mod_log_bytes/1.2 mod_bwlimited/1.4 PHP/4.3.11 FrontPage/5.0.2.2635.SR1.2 mod_ssl/2.8.27 OpenSSL/0.9.7a

I look to the config.php and see the following database info.

// define our database connection
define('DB_TYPE', 'mysql');
define('DB_PREFIX', 'zen_');
define('DB_SERVER', 'localhost');
define('DB_SERVER_USERNAME', '*****');
define('DB_SERVER_PASSWORD', '****');
define('DB_DATABASE', 'wicked8_zc1');
define('USE_PCONNECT', 'false'); // use persistent connections?
define('STORE_SESSIONS', 'db'); // use 'db' for best support, or '' for file-based storage

Basically, I know enough to be dangerous, but not enough to corerct this. Can anyone help me out so I do not loose the hours of work I have input. My only thought is to delete and do a fresh install.

26 Mar 2008, 12:36 PM
#2
dranet avatar

dranet

New Zenner

Join Date:
Mar 2008
Posts:
23
Plugin Contributions:
0

Re: Your database appears to need patching to a higher level. See Tools->Server Informati

Does anyone have an answer to this? I'm getting it too.

26 Mar 2008, 2:18 PM
#3
drbyte avatar

drbyte

Sensei

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

Re: Your database appears to need patching to a higher level. See Tools->Server Informati

dranet:

Does anyone have an answer to this? I'm getting it too.

It means that your database structure doesn't match the version that your PHP files are expecting.
This typically happens only when you've started to do an upgrade but haven't completed it properly.

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

27 Mar 2008, 3:42 PM
#4
dranet avatar

dranet

New Zenner

Join Date:
Mar 2008
Posts:
23
Plugin Contributions:
0

Re: Your database appears to need patching to a higher level. See Tools->Server Informati

DrByte:

It means that your database structure doesn't match the version that your PHP files are expecting.
This typically happens only when you've started to do an upgrade but haven't completed it properly.

Thanks for replying, but I just installed ZenCart. I went through every step in the instructions and the only errors I got are for the fcgi thingie. Well, that and I'm getting a page not found error on the catalog (admin works ok).

Are all of these related?

Thanks,
Tracy

27 Mar 2008, 6:41 PM
#5
drbyte avatar

drbyte

Sensei

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

Re: Your database appears to need patching to a higher level. See Tools->Server Informati

What is the URL?

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

31 Mar 2008, 8:44 PM
#6
traders avatar

traders

Zen Follower

Join Date:
Oct 2007
Posts:
111
Plugin Contributions:
0

Re: Your database appears to need patching to a higher level. See Tools->Server Informati

I had a database backup from version 1.3.7.1

I left a site host and held onto the backup until I got a chance to redo the site. I installed zen, apparently 1.3.8.a, restored the backup I had, and am getting the same message about patch levels. I wanted to avoid typing in all of our product data again. Not sure what to do next.

Zen Cart 1.3.8a
Database Patch Level: 1.3.7.1

31 Mar 2008, 8:51 PM
#7
drbyte avatar

drbyte

Sensei

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

Re: Your database appears to need patching to a higher level. See Tools->Server Informati

traders:

I had a database backup from version 1.3.7.1

I left a site host and held onto the backup until I got a chance to redo the site. I installed zen, apparently 1.3.8.a, restored the backup I had, and am getting the same message about patch levels. I wanted to avoid typing in all of our product data again. Not sure what to do next.

Zen Cart 1.3.8a
Database Patch Level: 1.3.7.1

Um ... you need to upgrade 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.

31 Mar 2008, 9:00 PM
#8
traders avatar

traders

Zen Follower

Join Date:
Oct 2007
Posts:
111
Plugin Contributions:
0

Re: Your database appears to need patching to a higher level. See Tools->Server Informati

Ok, I'll try to find information on that. I do not know if I was to upgrade it BEFORE upload, or after. There were some switches and/or selections at the restore page but I just left everything alone and did not change anything. Any clue on how to do appreciated, meantime I'll search. Thanks.

31 Mar 2008, 9:06 PM
#9
drbyte avatar

drbyte

Sensei

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

Re: Your database appears to need patching to a higher level. See Tools->Server Informati

Upload the zc_install folder for your Zen Cart version, and run it from your browser.
Full upgrade documentation is available in several places:
a) the /docs/ folder of your Zen cart files
b) the FAQ/Tutorials area
c) all over the forum

Or, you could just download the older version of Zen Cart and install that instead.
And plan your upgrade later.

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

31 Mar 2008, 9:23 PM
#10
traders avatar

traders

Zen Follower

Join Date:
Oct 2007
Posts:
111
Plugin Contributions:
0

Re: Your database appears to need patching to a higher level. See Tools->Server Informati

ok, i'll try to figure it out thanks for the help. i originally installed through fantastico which is automatic install so i have never installed outsite of there, so i'll work with your info thanks.

31 Mar 2008, 9:42 PM
#11
drbyte avatar

drbyte

Sensei

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

Re: Your database appears to need patching to a higher level. See Tools->Server Informati

No time like the present to learn how to do an upgrade.
Fantastico is fine for new installs, but that's about all.

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

31 Mar 2008, 9:42 PM
#12
traders avatar

traders

Zen Follower

Join Date:
Oct 2007
Posts:
111
Plugin Contributions:
0

Re: Your database appears to need patching to a higher level. See Tools->Server Informati

apparently i do not have a zc install file, i am going to try and figure out how to upload one I guess fantastico does all that automatically, if I have one I cannot find it so I am trying to find that now.

31 Mar 2008, 9:44 PM
#13
drbyte avatar

drbyte

Sensei

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

Re: Your database appears to need patching to a higher level. See Tools->Server Informati

You'll have to download the Zen Cart files from this site.
Click the Home link at the top of the page ...

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

31 Mar 2008, 9:51 PM
#14
traders avatar

traders

Zen Follower

Join Date:
Oct 2007
Posts:
111
Plugin Contributions:
0

Re: Your database appears to need patching to a higher level. See Tools->Server Informati

i downloaded zen from the site and upload the zc_install folder to my server, but it won't execute, so I kind of know what i need to do just don't know how.

31 Mar 2008, 9:52 PM
#15
drbyte avatar

drbyte

Sensei

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

Re: Your database appears to need patching to a higher level. See Tools->Server Informati

In your browser, go to http://your_domain.com/zc_install/index.php ... or whatever the correct path to it is.

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

31 Mar 2008, 9:57 PM
#16
traders avatar

traders

Zen Follower

Join Date:
Oct 2007
Posts:
111
Plugin Contributions:
0

Re: Your database appears to need patching to a higher level. See Tools->Server Informati

I think I got it, finally, thanks for your patience.

31 Mar 2008, 10:42 PM
#17
traders avatar

traders

Zen Follower

Join Date:
Oct 2007
Posts:
111
Plugin Contributions:
0

Re: Your database appears to need patching to a higher level. See Tools->Server Informati

Ok, I got it done and have ONE problem. if you view the site at https://www.wildwillysposters.com, there is a yellow bar appearing with the letters ggg in it. I can view source and see it and am trying to find out how to remove it.

31 Mar 2008, 10:44 PM
#18
drbyte avatar

drbyte

Sensei

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

Re: Your database appears to need patching to a higher level. See Tools->Server Informati

That looks like an EZ-Page ?

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

31 Mar 2008, 10:51 PM
#19
traders avatar

traders

Zen Follower

Join Date:
Oct 2007
Posts:
111
Plugin Contributions:
0

Re: Your database appears to need patching to a higher level. See Tools->Server Informati

I figured out the ggg problem, somehow it configured an ez page that was non-existent but I fixed it. You are right, I am glad I went through the upgrade. Fantastico does not teach anything, does everything so I needed to do this, thanks again for all your help. :smartalec:

7 Feb 2011, 8:17 PM
#20
justme2011 avatar

justme2011

New Zenner

Join Date:
Jan 2011
Posts:
1
Plugin Contributions:
0

Re: Your database appears to need patching to a higher level. See Tools->Server Informati

Hello All,

I just made a big mistake & upgraded my ZC 1.3.8 to the latest version through FANTISTICO.

It did a less than FANTASTICO job on my site though.
I followed all posts referring to correcting this that I could find & when I added the zc_install folder n went through everything I got this message on the Database Upgrade.


1253 COLLATION 'latin1_general_ci' is not valid for CHARACTER SET 'utf8'
in:
[CREATE TABLE zen_counter_history_clean as SELECT * FROM zen_counter_history WHERE 1 GROUP BY startdate COLLATE latin1_general_ci;]

What did I do wrong?
Could this be due to the renaming of the Admin Dir as mentioned to do in other posts?

Any Help would be greatly appreciated.

Thank You,
Stephen:smile: