Zen Cart Logo
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?

Views: 1,913

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.

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.

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

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.

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.

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

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

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:

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

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.

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.

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.