Anyone tested 1.5.3 on MySQL 5.6 yet?

14 Oct 2014, 7:35 PM

#1

Administrator

Join Date:: Feb 2006
Location:: Tampa Bay, Florida
Posts:: 10,721
Plugin Contributions:: 56

Anyone tested 1.5.3 on MySQL 5.6 yet?

The server requirements http://www.zen-cart.com/content.php?48-what-are-the-server-requirements-to-run-zen-cart say Zen Cart 1.5.3 expects MySQL 5.1-5.5. Has anyone tried MySQL 5.6?

That Software Guy. My Store: Zen Cart Support
Available for hire - See my ad in Services
Plugin Moderator, Documentation Curator, Chief Cook and Bottle-Washer.
Do you benefit from Zen Cart? Then please support the project.

15 Oct 2014, 8:35 AM

#2

rodg

Deceased

Join Date:: Jan 2007
Location:: Australia
Posts:: 6,263
Plugin Contributions:: 4

Re: Anyone tested 1.5.3 on MySQL 5.6 yet?

swguy:

The server requirements http://www.zen-cart.com/content.php?48-what-are-the-server-requirements-to-run-zen-cart say Zen Cart 1.5.3 expects MySQL 5.1-5.5. Has anyone tried MySQL 5.6?

Yes.

Zen Cart 1.5.3
PHP Version: 5.5.17
Database: MySQL 5.6.10-log (running on Centos).

No problems noted.

Cheers
RodG

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

Ozpost - The Ultimate Shipping module for Australian Merchants. Click these links for its Homepage, or Download from Zen-Cart.com.

15 Oct 2014, 9:52 AM

#3

swguy

Administrator

Join Date:: Feb 2006
Location:: Tampa Bay, Florida
Posts:: 10,721
Plugin Contributions:: 56

Re: Anyone tested 1.5.3 on MySQL 5.6 yet?

Thank you! This is good to know.

That Software Guy. My Store: Zen Cart Support
Available for hire - See my ad in Services
Plugin Moderator, Documentation Curator, Chief Cook and Bottle-Washer.
Do you benefit from Zen Cart? Then please support the project.

15 Oct 2014, 12:36 PM

#4

torvista

Totally Zenned

Join Date:: Aug 2007
Location:: Gijón, Asturias, Spain
Posts:: 2,876
Plugin Contributions:: 7

Re: Anyone tested 1.5.3 on MySQL 5.6 yet?

Zen Cart 1.5.3
PHP Version: 5.5.15
Database: MySQL 5.6.20 (running locally Windows 7/Xampp).

No problems noted.

I have only ever had "problems" with each upgrade to php, spitting out new deprecation and other warnings. Never had a problem with the db version.

Steve
github.com/torvista: BackupMySQL, Structured Data, Multiple Copy-Move-Delete, Google reCaptcha, Image Checker, Spanish Language Pack and more...

15 Oct 2014, 5:39 PM

#5

drbyte

Sensei

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

Re: Anyone tested 1.5.3 on MySQL 5.6 yet?

Can you test using Salemaker and Specials, specifically with enabling/disabling sales/specials, and also setting them to expire.
I'm concerned about changes they're making to zero-date restrictions, starting with about MySQL 5.6.6 or so.

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

15 Oct 2014, 5:56 PM

#6

rodg

Deceased

Join Date:: Jan 2007
Location:: Australia
Posts:: 6,263
Plugin Contributions:: 4

Re: Anyone tested 1.5.3 on MySQL 5.6 yet?

DrByte:

Can you test using Salemaker and Specials, specifically with enabling/disabling sales/specials, and also setting them to expire.
I'm concerned about changes they're making to zero-date restrictions, starting with about MySQL 5.6.6 or so.

Sale maker doesn't seem to be an issue (tested using null field and valid dates)

Specials on the other hand are producing an error

PHP Fatal error: 1364:Field 'dealproduct_date' doesn't have a default value :: insert into zen_specials
(products_id, specials_new_products_price, specials_date_added, expires_date, status, specials_date_available)
values ('3963',
'20',
now(),

BUT, as you can see, this client/server has a 'daily deals' module installed so my findings may not be applicable to a native ZenCart installation (apparently the client hasn't been using this module over the last month or so)

Darn you Dr. Now I've got a bug to fix.

Cheers
RodG

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

Ozpost - The Ultimate Shipping module for Australian Merchants. Click these links for its Homepage, or Download from Zen-Cart.com.

15 Oct 2014, 6:19 PM

#7

rodg

Deceased

Join Date:: Jan 2007
Location:: Australia
Posts:: 6,263
Plugin Contributions:: 4

Re: Anyone tested 1.5.3 on MySQL 5.6 yet?

Update: Setting a default value or enabling NULL in the dailydeals fields cured my problem.

It appears that the zencart stock fields are already correctly set with suitable values and they a NOT causing any problem in this MySQL 5.6 site.

Cheers
RodG

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

Ozpost - The Ultimate Shipping module for Australian Merchants. Click these links for its Homepage, or Download from Zen-Cart.com.