Well, I finally found a server that would reproduce the “Illegal mix of collations” error that MySQL troughs when executing some queries in my TERRIBL Plugin. See, I guess alot of servers use latin1_swedish_ci as the default collation for their MySQL databases. This seems to cause an error in some queries, especially those that use foreign characters. So I have patched my Plugin by explicitly setting all my database collations to utf8_general_ci. I also added an error handler that looks for this error in database table that may have been created by older versions of the Plugin and the new version will now fix the old tables using an “Alter Table” statement. So upgrade to version 1.1.12.21 now.
Related Posts by Tags
- New plugin – EZ Google Analytics (Oct 8th, 2014)
This plugin includes your Google Analytics tracking code on your pages and posts.
Download it here: wordpress.org
- Happy Birthday Blog (Oct 8th, 2012)
This Blog is one year old today. Now I can use the SMALY Widget that I wrote for the SHH Blog on this Blog. You can see links to my one-year-old posts on the sidebar under "THIS DAY IN HISTORY".
- A New WordPress Widget for SHH Blog (Apr 4th, 2012)
I just created a small Widget for the SHH Blog that runs a simple query to find posts posted around the same time last year.
- Now available in the WordPress Repository (Mar 26th, 2012)
I just released my new Anti-Malware plugin for WordPress. It is still in BETA but I think it will be very helpful in removing malicious scripts and patching security vulnerabilities.
Please ...
