The server requirements http://www.zen-cart.com/content.php?...o-run-zen-cart say Zen Cart 1.5.3 expects MySQL 5.1-5.5. Has anyone tried MySQL 5.6?
The server requirements http://www.zen-cart.com/content.php?...o-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 Modifications
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.
Thank you! This is good to know.
That Software Guy. My Store: Zen Cart Modifications
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.
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: Spanish Language Pack, Google reCaptcha, Structured Data, Multiple Copy-Move-Delete, Image Checker, BackupMySQL Admin/Auto...
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.
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
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
Last edited by RodG; 15 Oct 2014 at 07:23 PM.
Bookmarks