Zen Cart Logo
Forums / Upgrading from 1.3.x to 1.3.9 / Your database appears to need patching to a higher level.

Your database appears to need patching to a higher level.

Views: 14,847

Results 41 to 56 of 56
11 May 2011, 2:36 PM
#41
stuffdone avatar

stuffdone

Zen Follower

Join Date:
Jul 2007
Posts:
156
Plugin Contributions:
0

Your database appears to need patching to a higher level.

I will give this all a good read and a test once I get some projects out of my hair ( opps...no hair ).

I want all the good programmers involved to know how much I do appreciate their work and how much I like Zen cart. I am just currently frustrated by an upgrade ! :smile:

25 May 2011, 4:18 PM
#42
colin99 avatar

colin99

New Zenner

Join Date:
May 2006
Posts:
37
Plugin Contributions:
0

Re: Your database appears to need patching to a higher level.

I have done all the updates as above (in earlier posts) but I am still getting the...

NOTICE: The website is currently Down For Maintenance to the public
Warning Your database appears to need patching to a higher level. See Admin->Tools->Server Information to review patch levels.

Messages and cannot turn them off.

I upgraded from 1.38 to 1.39h

Here is my PATCH Level message...

Zen Cart 1.3.9h
Patch: 1::
Database Patch Level: 1.3.9h

Which means I am patched, yes?
And yet I am getting the ...

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

On the home page still.

25 May 2011, 4:24 PM
#43
colin99 avatar

colin99

New Zenner

Join Date:
May 2006
Posts:
37
Plugin Contributions:
0

Re: Your database appears to need patching to a higher level.

Addendum - Interestingly, my BACK END Admin in my ZEN CART says everything is normal and everything is up to date.

Yet Homepage says: Down for maintenance - Update Database.

Is this simply a message I can switch off somewhere?

25 May 2011, 4:26 PM
#44
haredo avatar

haredo

Totally Zenned

Join Date:
Apr 2006
Location:
Texas
Posts:
6,179
Plugin Contributions:
0

Re: Your database appears to need patching to a higher level.

admin panel/ configuration/ website maintenance/ Down for Maintenance: ON/OFF

25 May 2011, 4:33 PM
#45
colin99 avatar

colin99

New Zenner

Join Date:
May 2006
Posts:
37
Plugin Contributions:
0

Re: Your database appears to need patching to a higher level.

haredo:

admin panel/ configuration/ website maintenance/ Down for Maintenance: ON/OFF

Nope -- set as FALSE.

Backend reports all normal, all patched and on-line.

Cleared browser cache a couple of times as well.

Will happily give you an admin account to poke around.

Thanks!

25 May 2011, 4:42 PM
#46
colin99 avatar

colin99

New Zenner

Join Date:
May 2006
Posts:
37
Plugin Contributions:
0

Re: Your database appears to need patching to a higher level.

Note attached image...

25 May 2011, 4:42 PM
#47
haredo avatar

haredo

Totally Zenned

Join Date:
Apr 2006
Location:
Texas
Posts:
6,179
Plugin Contributions:
0

Re: Your database appears to need patching to a higher level.

I sent you a PM,

After doing the database-upgrade via zc_install, you need to go into your admin area and remove-and-reinstall all your payment and shipping modules. This is documented in the upgrade instructions in the /docs/ folder of the Zen Cart files. After you've done that, you can turn off the down-for-maintenance by going to Admin->Configuration->Website Maintenance and setting Down For Maintenance to False.

25 May 2011, 4:50 PM
#48
colin99 avatar

colin99

New Zenner

Join Date:
May 2006
Posts:
37
Plugin Contributions:
0

Re: Your database appears to need patching to a higher level.

haredo:

I sent you a PM,

After doing the database-upgrade via zc_install, you need to go into your admin area and remove-and-reinstall all your payment and shipping modules. This is documented in the upgrade instructions in the /docs/ folder of the Zen Cart files. After you've done that, you can turn off the down-for-maintenance by going to Admin->Configuration->Website Maintenance and setting Down For Maintenance to False.

Yes - did that too. :-)

I love a good Zen Cart challenge.

25 May 2011, 5:07 PM
#49
haredo avatar

haredo

Totally Zenned

Join Date:
Apr 2006
Location:
Texas
Posts:
6,179
Plugin Contributions:
0

Re: Your database appears to need patching to a higher level.

Look like you have not upgraded the files properly..

When I go to tools/ template selection and switch back to classic contemporary green I get the same page... NOT GOOD

You need to retrace your paths on the upgrade process.. Sorry

25 May 2011, 5:08 PM
#50
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.

colin99:

I have done all the updates as above (in earlier posts) but I am still getting the...

NOTICE: The website is currently Down For Maintenance to the public
Warning Your database appears to need patching to a higher level. See Admin->Tools->Server Information to review patch levels.

Messages and cannot turn them off.

I upgraded from 1.38 to 1.39h

Here is my PATCH Level message...

Zen Cart 1.3.9h
Patch: 1::
Database Patch Level: 1.3.9h

Which means I am patched, yes?
And yet I am getting the ...

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

On the home page still.

colin99:

Addendum - Interestingly, my BACK END Admin in my ZEN CART says everything is normal and everything is up to date.

Yet Homepage says: Down for maintenance - Update Database.

Is this simply a message I can switch off somewhere?

Looks like your /admin/includes/configure.php is pointing to a different set of database credentials than your /includes/configure.php is.
They need to have the SAME settings for all the DB_xxxxxx parameters, else they're showing you completely different data.

And, remember, if the configure.php file is read-only, you won't be able to upload/edit it without making it writable first.

25 May 2011, 5:52 PM
#51
colin99 avatar

colin99

New Zenner

Join Date:
May 2006
Posts:
37
Plugin Contributions:
0

Re: Your database appears to need patching to a higher level.

DrByte:

Looks like your /admin/includes/configure.php is pointing to a different set of database credentials than your /includes/configure.php is.
They need to have the SAME settings for all the DB_xxxxxx parameters, else they're showing you completely different data.

And, remember, if the configure.php file is read-only, you won't be able to upload/edit it without making it writable first.

Ah! I have a DEV DB running at the same time.

Eep!

My bad - all well now.

Good work ZEN Folk

I have been ZENNING so long now I should try and help out a bit too.

8 Sep 2011, 2:30 PM
#52
stuffdone avatar

stuffdone

Zen Follower

Join Date:
Jul 2007
Posts:
156
Plugin Contributions:
0

Re: Your database appears to need patching to a higher level.

I have tried another upgrade following step by step and have given up. Changing to Virtuemart. ( Sept 2011 )

ZEN developers really need to work on making upgrades easier or write better documentation.

Sorry...while I do appreciate the work put into the actual product and used to love it, when my site using the old version keeps getting hacked due to security holes and I spend hours trying "three easy steps" and still cannot get an upgrade to take it is time to cut my losses ( time and labor and downtime ) and just make a change to something easier to maintain.

I would love to come back to ZEN if/when an auto-update function is developed.

And yes...when I exported my old SQL both that and the new DB are encoded UTF-8 according to phpMyAdmin

:(

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

15 Nov 2011, 3:28 AM
#54
april_may avatar

april_may

New Zenner

Join Date:
Apr 2009
Posts:
52
Plugin Contributions:
0

Re: Your database appears to need patching to a higher level.

I am hosted on GoDaddy. I had to upgrade to a new server in order to upgrade from 1.3.8a.1 to 1.3.9h. That took a few days and it was all done today.
I had alrady backed up all my databases before starting the process. (I have several carts installed.) OK- one at a time.
I started with one cart today. I uninstalled it... thru Godaddy uninstall....but I SAVED the database... AND GoDaddy saves my custom files on the uninstall process.
Then I installed the 1.3.9h in the same folder where the old one was. Godaddy creates the new database automatically. Then I changed the two configure files to point to the old database.
Well that was wrong because I was getting the 'Your database appears to need patching to a higher level" message. My site being 1.3.9h and the database 1.3.8
I guess the old database will not work in the new upgrade.

I just changed the configure files back to point to the new database. Rats. I really don't want to individually upload over 1000 items into my cart in the new database, but looks like I am stuck.

If I get into my new SQL acct. and import the databse will that work? ... or will it just override the new tables and ruin it?

15 Nov 2011, 6:37 AM
#55
barco57 avatar

barco57

Totally Zenned

Join Date:
Apr 2006
Location:
West Salem, IL
Posts:
2,844
Plugin Contributions:
0

Re: Your database appears to need patching to a higher level.

No, because the old databse is still an old version....you need to upload the zc_install folder, import the old db, then go to http://yourdomain.com/zc_install, accept the license, next page scroll to bottom and click the upgrade database......

or you can skip the import old db to the new database, and just point the config files at the old db and run the upgrader....

15 Nov 2011, 8:42 AM
#56
april_may avatar

april_may

New Zenner

Join Date:
Apr 2009
Posts:
52
Plugin Contributions:
0

Re: Your database appears to need patching to a higher level.

Thank you.
That is what I though... old is old. It can not work in the newer version.
OK.. lets see if I understand you.
First, I have not used the "zencart install" before (since I am on GoDaddy - I just click and they install) so excuse me for being lost in this area.

So you say to import the db first. Where do I import it to?
Am I to import it into my current SQL (godaddy has my SQL on a different server) - or upload it somewhere in within the cart files?- or zc_install >sql file? Run the upgrader there & then put the file in my sql on the other server? Will it run the upgrader to my SQL file on the other server directly?
What does the upgrader actually do to the files?
If I get it in my head correctly first I can work with it easier.
I sure would like an easy way to import my products and customers info. This sounds easy.