Quote Originally Posted by Yizit View Post
It appears to have something to do with MySQL5 and versions of ZenCart 1.2.7 and earlier. The only exception is that with the program I'm working on this message only appears once and that's at startup. At that point, I can choose to do anything I want and the message never re-appears whereas with the post you provided a link to Tina, they were getting the message on various pages.
Zen Cart v1.2.7 is grossly incompatible with MySQL5.
Basically, don't mix them.
If you need to mix them, upgrade your Zen Cart version to v1.3.7 or newer.

You say it's only appearing once. Consider yourself overly lucky.
(Actually, I'd be very concerned since that's inconsistent with normal operation.)
Quote Originally Posted by Yizit View Post
Since this only happens at startup, it would be nice to think that, at startup, a message could be sent to ZenCart telling it not to be afraid of MySQL5 and to go on working as happily as it did in the past until a version upgrade of ZenCart can be made. If anyone can come up with something like that, it would be worth a couple of cups of joe!
The thing is ... Zen Cart v1.2.7 SHOULD BE VERY AFRAID of MySQL 5.

The newer versions (1.3.8 to some extent, and even better in v2.0.0) do give clearer warnings of incompatibility, or a complete intentional halt where a known incompatibility exists.

Keep in mind ... Zen Cart v1.2.7 was built on architecture that existed before MySQL 5 was largely embraced. Thus, it was a little hard to write code to anticipate the incompatibilities. Much has been learned since then, and future versions will be much less painful to accommodate.

Keep in mind that Zen Cart v1.2.7 was released in February 2006, and there have been more than 8 new versions released since then, all with increasingly greater compatibility with PHP5 and MySQL 5.

You are VERY STRONGLY ADVISED to upgrade if you're using MySQL 5 or PHP5.


Sorry, I don't mean to rant ... just to be emphatic.