Forums / Upgrading to 1.5.x / Is there a database upgrade between 1.5.0 and 1.5.1?

Is there a database upgrade between 1.5.0 and 1.5.1?

Started by dharrison on 22 Apr 2014, 9:32 AM · Views: 1,941

Results 1 to 13 of 13
22 Apr 2014, 9:32 AM
#1
dharrison avatar

dharrison

Zen Follower

Join Date:
Mar 2009
Location:
Essex, UK
Posts:
448
Plugin Contributions:
0

Is there a database upgrade between 1.5.0 and 1.5.1?

Hi all

I have just upgraded our website form 1.5.0 to 1.5.1 and on reading the info at Tools > Server/version information, I get the following:

Zen Cart 1.5.1
Database Patch Level: 1.5.0

I followed the upgrade version in /docs/ fodler religiously and so far so good. Please could anyone let me know if we are also supposed to upgrade the SQL database during the upgrade to 1.5.1 (because that certainly wasn't outlined).

I appreciate any advice/feedback.

Thanks in advance.

Debbie Harrison
DVH Design | Web Design blog

22 Apr 2014, 9:48 AM
#2
mc12345678 avatar

mc12345678

Totally Zenned

Join Date:
Jul 2012
Posts:
16,908
Plugin Contributions:
2

Re: Is there a database upgrade between 1.5.0 and 1.5.1?

dharrison:

Hi all

I have just upgraded our website form 1.5.0 to 1.5.1 and on reading the info at Tools > Server/version information, I get the following:

Zen Cart 1.5.1
Database Patch Level: 1.5.0

I followed the upgrade version in /docs/ fodler religiously and so far so good. Please could anyone let me know if we are also supposed to upgrade the SQL database during the upgrade to 1.5.1 (because that certainly wasn't outlined).

I appreciate any advice/feedback.

Thanks in advance.

Yes, there is a database upgrade from 1.5.0 to 1.5.1,regardless of how small the change. I amnot sure which instructions specifically you arereferring,but the upgrade instructions that existon this server (whichi would expect would be referenced by any other documentation at least in part would include doing something with the zc_includes folder which would also include updating the database only.

ZC Installation/Maintenance Support <- Site
Contribution for contributions welcome...

22 Apr 2014, 9:49 AM
#3
frank18 avatar

frank18

Deceased

Join Date:
Nov 2007
Location:
Sunny Coast, Australia
Posts:
3,427
Plugin Contributions:
2

Re: Is there a database upgrade between 1.5.0 and 1.5.1?

dharrison:

Hi all

I have just upgraded our website form 1.5.0 to 1.5.1 and on reading the info at Tools > Server/version information, I get the following:

Zen Cart 1.5.1
Database Patch Level: 1.5.0

I followed the upgrade version in /docs/ fodler religiously and so far so good. Please could anyone let me know if we are also supposed to upgrade the SQL database during the upgrade to 1.5.1 (because that certainly wasn't outlined).

I appreciate any advice/feedback.

Thanks in advance.

There is no DB upgrade from 1.5.0 to 1.5.1 - as far I remember. All but one of my updates have been done from 1.3.9h to 1.5.1.

Can't recall doing a DB upgrade from 1.5.0 to 1.5.1........

Cheers / Frank

NOTE: We are sorry that Frank is no longer with us.
We are grateful for all his contributions to the Zen Cart community.

22 Apr 2014, 10:31 AM
#4
mc12345678 avatar

mc12345678

Totally Zenned

Join Date:
Jul 2012
Posts:
16,908
Plugin Contributions:
2

Re: Is there a database upgrade between 1.5.0 and 1.5.1?

frank18:

There is no DB upgrade from 1.5.0 to 1.5.1 - as far I remember. All but one of my updates have been done from 1.3.9h to 1.5.1.

Can't recall doing a DB upgrade from 1.5.0 to 1.5.1........

Cheers / Frank

And I made the statement by looking at a site that I may have manually modified the database to reflect when I upgraded to 1.5.1.

ZC Installation/Maintenance Support <- Site
Contribution for contributions welcome...

22 Apr 2014, 10:58 AM
#5
frank18 avatar

frank18

Deceased

Join Date:
Nov 2007
Location:
Sunny Coast, Australia
Posts:
3,427
Plugin Contributions:
2

Re: Is there a database upgrade between 1.5.0 and 1.5.1?

In the docs folder I find this:

Upgrade Instructions

From v1.5.0 to v1.5.1

Simple: if you are using v1.5.0 already and have not customized any of the files listed in the changed_files-v1-5-1.html document, then simply replace those files with the new versions contained herein.

That tells me that there is no DB upgrade - or it would be mentioned. Replace the files and you are done.

NOTE: We are sorry that Frank is no longer with us.
We are grateful for all his contributions to the Zen Cart community.

22 Apr 2014, 12:56 PM
#6
ajeh avatar

ajeh

Oba-san

Join Date:
Sep 2003
Location:
Ohio
Posts:
62,757
Plugin Contributions:
1

Re: Is there a database upgrade between 1.5.0 and 1.5.1?

If you look in the zc_install:
\zc_install\sql\mysql_upgrade_zencart_150_to_151.sql

you will see the changes that are run via the Upgrade from v1.5 to v1.5.1 ...

You could try to manually make the changes, or run the Upgrade via the /zc_install so that the changes are made correctly ...

Linda McGrath
If you have to think ... you haven't been zenned ...

**Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!**

Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today!]
Officially PayPal-Certified! Just click here

Try our Zen Cart Recommended Services - Hosting, Payment and more ...
Signup for our Announcements Forums to stay up to date on important changes and updates!

22 Apr 2014, 12:59 PM
#7
design75 avatar

design75

Totally Zenned

Join Date:
Dec 2009
Location:
Amersfoort, The Netherlands
Posts:
2,862
Plugin Contributions:
5

Re: Is there a database upgrade between 1.5.0 and 1.5.1?

frank18:

In the docs folder I find this:

That tells me that there is no DB upgrade - or it would be mentioned. Replace the files and you are done.

There is a db upgrade, you can find the upgrade sql from 1.5 to 1.5.1 in the install folder. The changes are mostly field lengths becoming bigger varchar(32) to varchar(45), and of course the zen cart version info will be updated

22 Apr 2014, 1:33 PM
#8
drbyte avatar

drbyte

Sensei

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

Re: Is there a database upgrade between 1.5.0 and 1.5.1?

The instructions VERY CLEARLY tell you to run zc_install to perform the database upgrade.

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

22 Apr 2014, 4:06 PM
#9
dharrison avatar

dharrison

Zen Follower

Join Date:
Mar 2009
Location:
Essex, UK
Posts:
448
Plugin Contributions:
0

Re: Is there a database upgrade between 1.5.0 and 1.5.1?

Thanks all of you for your comments. I think I'll be upgrading the database then. :laugh:

Debbie Harrison
DVH Design | Web Design blog

23 Apr 2014, 2:54 AM
#10
divavocals avatar

divavocals

Totally Zenned

Join Date:
Jan 2007
Location:
Los Angeles, California, United States
Posts:
10,011
Plugin Contributions:
3

Re: Is there a database upgrade between 1.5.0 and 1.5.1?

DrByte:

The instructions VERY CLEARLY tell you to run zc_install to perform the database upgrade.

dharrison:

Thanks all of you for your comments. I think I'll be upgrading the database then. :laugh:
the lesson to be learned here is to not skip running the install script when upgrading even if you THINK you should..

My Site - Zen Cart & WordPress integration specialist
I don't answer support questions via PM. Post add-on support questions in the support thread. The question & the answer will benefit others with similar issues.

23 Apr 2014, 6:53 AM
#11
dharrison avatar

dharrison

Zen Follower

Join Date:
Mar 2009
Location:
Essex, UK
Posts:
448
Plugin Contributions:
0

Re: Is there a database upgrade between 1.5.0 and 1.5.1?

DivaVocals:

the lesson to be learned here is to not skip running the install script when upgrading even if you THINK you should..

Thanks Diva. I must admit I did read and interpret the instructions as quoted by frank18, but I certainly have learned from this experience. Just as well it was only a minor update.

And database has been upgraded and reads fine now.

Debbie Harrison
DVH Design | Web Design blog

23 Apr 2014, 7:41 AM
#12
frank18 avatar

frank18

Deceased

Join Date:
Nov 2007
Location:
Sunny Coast, Australia
Posts:
3,427
Plugin Contributions:
2

Re: Is there a database upgrade between 1.5.0 and 1.5.1?

dharrison:

Thanks Diva. I must admit I did read and interpret the instructions as quoted by frank18, but I certainly have learned from this experience. Just as well it was only a minor update.

And database has been upgraded and reads fine now.

Yep, it's definitely necessary to read all of the instructions from a-z - which is what I would do if I had a pending upgrade.

Just could not remember if I did a DB upgrade on the single occasion when I upgraded a (client's) site from 1.5.0 to 1.5.1. Call that a Senior Moment :P - sorry about that.

NOTE: We are sorry that Frank is no longer with us.
We are grateful for all his contributions to the Zen Cart community.

23 Apr 2014, 8:11 AM
#13
dharrison avatar

dharrison

Zen Follower

Join Date:
Mar 2009
Location:
Essex, UK
Posts:
448
Plugin Contributions:
0

Re: Is there a database upgrade between 1.5.0 and 1.5.1?

No problem Frank I'm glad I wasn't the only one for once. :) I just don't read things properly.

Debbie Harrison
DVH Design | Web Design blog