Consistantly getting a
Illegal mix of collations (utf8_unicode_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation '=' SQL=SELECT COUNT(*) FROM `fjbl3_jofbpt_category` AS a LEFT JOIN `fjbl3_languages` AS l ON l.lang_code = a.language LEFT JOIN fjbl3_users AS uc ON uc.id=a.checked_out LEFT JOIN fjbl3_viewlevels AS ag ON ag.id = a.access WHERE (a.state IN (0, 1)) Illegal mix of collations (utf8_unicode_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation '=' SQL=SELECT a.id, a.name, a.alias, a.checked_out, a.checked_out_time,a.state, a.access, a.ordering,a.language,l.title AS language_title,uc.name AS editor,ag.title AS access_level FROM `fjbl3_jofbpt_category` AS a LEFT JOIN `fjbl3_languages` AS l ON l.lang_code = a.language LEFT JOIN fjbl3_users AS uc ON uc.id=a.checked_out LEFT JOIN fjbl3_viewlevels AS ag ON ag.id = a.access WHERE (a.state IN (0, 1)) ORDER BY a.name asc LIMIT 0, 100 Illegal mix of collations (utf8_unicode_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation '=' SQL=SELECT COUNT(*) FROM `fjbl3_jofbpt_category` AS a LEFT JOIN `fjbl3_languages` AS l ON l.lang_code = a.language LEFT JOIN fjbl3_users AS uc ON uc.id=a.checked_out LEFT JOIN fjbl3_viewlevels AS ag ON ag.id = a.access WHERE (a.state IN (0, 1))