Forums / Upgrading to 1.5.x / ZC 1.5.5 with MySQL 5.0.96 ??

ZC 1.5.5 with MySQL 5.0.96 ??

Locked

Views: 1,235

Results 1 to 5 of 5
This thread is locked. New replies are disabled.
9 Aug 2016, 12:39 AM
#1
frank18 avatar

frank18

Deceased

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

ZC 1.5.5 with MySQL 5.0.96 ??

I have been asked to upgrade a client's site from 1.3.9d to the latest (nothing new to be honest....). The site currently runs on PHP 5.2, so I had to ask the client to make their webhost install different PHP versions with PHP selector which they meanwhile implemented.

The server is currently running MySQL 5.0.96-community-log which is fine for ZC 1.3.9d.

How (if at all) would a ZC 1.5.5 site cope with this old MySQL 5.0.96 version considering the server specs in the FAQ's state 'Zen Cart v1.5.5 expects MySQL 5.1 to 5.7'?

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.

9 Aug 2016, 2:46 AM
#2
drbyte avatar

drbyte

Sensei

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

Re: ZC 1.5.5 with MySQL 5.0.96 ??

At first cursory glance I'm not finding any glaring "breaking" issues. But it seems to be nearly impossible to find a list of feature-changes from MySQL that far back: They only publish docs for 5.6 and 5.7 now.

I'm sure there was a reason why it was mentioned as 5.1 ...... but it's possible that it might work fine with 5.0 even though both are from like 2008-2012 era.

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

9 Aug 2016, 3:20 AM
#3
frank18 avatar

frank18

Deceased

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

Re: ZC 1.5.5 with MySQL 5.0.96 ??

DrByte:

At first cursory glance I'm not finding any glaring "breaking" issues. But it seems to be nearly impossible to find a list of feature-changes from MySQL that far back: They only publish docs for 5.6 and 5.7 now.

I'm sure there was a reason why it was mentioned as 5.1 ...... but it's possible that it might work fine with 5.0 even though both are from like 2008-2012 era.

Thanks Doc, don't get it that some hosts are still hanging on to old PHP and MySQL versions.

Guess my best bet is to give it a try with 1.5.5a in a sub folder and flick the PHP selector to 5.6 for testing purposes.

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

25 Aug 2016, 8:01 AM
#4
explorer1979 avatar

explorer1979

Inactive

Join Date:
Jan 2007
Posts:
377
Plugin Contributions:
0

Re: ZC 1.5.5 with MySQL 5.0.96 ??

Hi all,

Here are the online version of MySQL 5.0 manual (Can google by MySQL 5 Manual to search older manual)
https://docs.oracle.com/cd/E19078-01/mysql/mysql-refman-5.0/

Or you can try download the CentOS 5.11 from centos.org to build a VM testing Linux as a platform testing

You can see the build in version package of CentOS there
https://distrowatch.com/table.php?distribution=centos

Hope this help

Best Regards,
Jimmy Chan
http://explorerhome.no-ip.org/blog

25 Aug 2016, 12:02 PM
#5
frank18 avatar

frank18

Deceased

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

Re: ZC 1.5.5 with MySQL 5.0.96 ??

frank18:

Thanks Doc, don't get it that some hosts are still hanging on to old PHP and MySQL versions.

Guess my best bet is to give it a try with 1.5.5a in a sub folder and flick the PHP selector to 5.6 for testing purposes.

All solved, host did what they should have done a long time ago ie updating MySQL version to the latest. Site upgrade to ZC 1.5.5a went well.

Thanks again / Frank

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