In debug, I get the error: "500 - JDatabaseMySQL::query: 1267 - Illegal mix of collations (utf8_unicode_ci,COERCIBLE) and (utf8_general_ci,COERCIBLE) for operation 'like' " with the code below.

The sql query runs fine in PHPMyAdmin and in the shell mysql client. A review of all of the tables and fields indicate that all are of the type 'utf8_general_ci', so I don't know why I'm getting the error indicating that 'utf8_unicode_ci' is a problem child. Below is the ARI (v1.8.1) plugin code used. If "MemType like 'Member%' and" is removed from the plugin, then it works correctly. I believe that ARI is injecting something into the query when parsing it, as it is a valid query otherwise.

{arijtablesorter paging="true"} {arijdatatable} {arisqltable} {arisqltablecolumns} {arisqltablecolumn}{/arisqltablecolumn}{/arisqltablecolumns}{arisqltablequery} SELECT date(recordtime) AS Date,MemType,Parent,Email, FROM class_registrations where MemType like 'Member%' and (year(recordtime) > '2012' or ( year(recordtime) = '2012' and month(recordtime) > '11')) order by date_submit asc{/arisqltablequery}{/arisqltable}{/arijdatatable}{/arijtablesorter}

Hello,

Could you send SQL dump of "class_registrations" table by email so we can investigate the problem?

Regards,
ARI Soft

I have resolved this issue. Although the source tables both had 'utf8_general_ci' as the collation for all the fields, for whatever reason, the VIEW that I created defined the MemType field as 'utf8_unicode_ci' for some unknown reason.

Dropping the VIEW and recreating the VIEW resolved the issue.