mySQL

How to resolve the Zen Cart Illegal mix of collations error

We had deployed a Zen Cart website and we came up with the following error in the Zen Cart admin panel when clicking on the Tools -> Send Email link. Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (latin1_general_ci,IMPLICIT) for operation ‘locate’ After checking the table collation in PHPmyAdmin I found that the subscribers table (created when …

How to resolve the Zen Cart Illegal mix of collations error Read More »

What is the minimum mySQL version requirement for Zencart?

A client of mine developed his website in Zencart and after careful scrutiny approved the website for deployment to his production machine. He provided the FTP and mySQL information for us to deploy the website. As is the practice, I check for any version conflicts that may conflict with our system before I give the …

What is the minimum mySQL version requirement for Zencart? Read More »