Zencart and MySQL 5

**colin99** · 6 Jul 2006, 07:40 PM

Any issues with MySQL 5?

Does ZenCart support MySQL 5?

My ISP is heading in this direction over the next few monthes. They are, however, taking their time because they know, full well, that many sites will break if they dump all the mysql servers into MySQL 5.

I have searched the forums and I see no mention of it.

Therefore - I bring it up.

**DrByte** · 6 Jul 2006, 08:41 PM

Zen Cart v1.3.x and higher have better support for MySQL5 than prior versions did.

However, it is not officially supported.

You will find that if your host configures their MySQL5 such that STRICT_TRANS_TABLES is disabled, things will work without issue.

http://www.zen-cart.com/forum/showthread.php?t=37597
http://www.zen-cart.com/forum/showth...t=23628&page=2

In MySQL configuration menus: Startup Variables / Advanced /SQL Mode
Disable/delete the option STRICT_TRANS_TABLES

**colin99** · 6 Jul 2006, 09:08 PM

Thanks Doc! Appreciated.

**superprg** · 6 Jul 2006, 09:40 PM

Doc I have one question here
Whever, we have new version of php or mysql,how do we endorse the fact that our cart is completely complaint for that version
As in what minimal steps we perfom to make sure that there is no serious problem because of the php/mysql version upgrade
Thanks

**Kim** · 6 Jul 2006, 10:52 PM

As in what minimal steps we perfom to make sure that there is no serious problem because of the php/mysql version upgrade

Test, test, test- check the login and checkout procedures, try everything in the Admin.

**Vger** · 6 Jul 2006, 10:57 PM

At least Colin99's host is hesitating before jumping into MySQL5. Some hosts seem to be the first to install the latest version of everything the day it's released - and it's their customers that pay for it.

Vger