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.

I released an update a couple of days ago with some more stats and another attempt to work around the whole Search String URL problem with Google’s new SSL Search. However, in the process of changing some field aliases in the database queries I inadvertently broke the Widget. So today I released another update to fix the Widget and it all seems to be working.

I really thought this Plugin has a lot of potential to be very popular but it still has less than 700 downloads and my other Plugin, Related Posts Links and Widget already has more than 2,600 downloads. Oh well, Maybe if I find a solution the the SSL Encrypted Search String issue it will be a great Search Engine Optimization Tool.