MySQL compatibility (5.1 vs 5.5)

[DrByte]

Hi Edith

I currently have MySQL 5.5.24 installed and haven't seen any problems with core code. Although I can't speak for contributions.

I echo wilt's comments.
I too normally use MySQL 5.5 in all my development and production work. Haven't run into any problems related to using MySQL 5.5.x as far as Zen Cart v1.5.x core code goes.


Rod, terraGirl *is* a hosting company, so she's one of the rare few who actually do have total control over what version of MySQL she runs on her server

[terraGirl]

Many thanks for your input!

Yes, the query is related to one of our Shared servers, so I have no control over what software is installed and also not the full details of what weird and wonderful modifications are running.

The server is live (with live client sites), hence why I'm treading very carefully here. First step is assessing the most common software types (Zen Cart, Magento, WordPress, Joomla, OpenCart etc) for 5.5. compatibility which appears to be all good.

We probably will hold off with MySQL 5.5 for a bit longer (until after Xmas) and also run more tests on a non-client server first to assess.

Many thanks for your advice, that's been very helpful!