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 … Read moreHow to resolve the Zen Cart Illegal mix of collations error

Steps to implement mySQL FULLTEXT

mySQL has full text indexing and searching support from version 5.0 onwards however there are some limitations. If you need to implement full text indexing then please review points given below: 1. mySQL allows full text indexing on MyISAM tables and not any other table type. If you try to create a full text index … Read moreSteps to implement mySQL FULLTEXT

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 … Read moreWhat is the minimum mySQL version requirement for Zencart?

What to do if you got the “Got error 28 from storage engine” in mySQL?

I had logged into PhPMyAdmin and was trying to add some fields into a table when I got the error “Got error 28 from storage engine”. I tried to refresh the page but it kept coming. I closed the browser and then tried to run my website and found that the same error message was … Read moreWhat to do if you got the “Got error 28 from storage engine” in mySQL?

Modify the auto increment value in mySQL

If you want to modify the auto increment column to start inserting records from a specific value then you will need to run the following statement. ALTER TABLE <table_name> AUTO_INCREMENT = 12345; After running the above statement the insertion will start from that value. However if there are any records which have a value greater … Read moreModify the auto increment value in mySQL