Hello, im getting this error in the Question Management and Question Pool sections



Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8_unicode_ci,IMPLICIT) for operation '=' SQL=SELECT COUNT(*) FROM `tmnet_quiz_t_question` AS `a` LEFT JOIN `tmnet_quiz_t_qtypes` as `b` ON b.c_id = a.c_type LEFT JOIN `tmnet_quiz_t_quiz` as `c` ON a.c_quiz_id = c.c_id LEFT JOIN `tmnet_categories` AS `cat` ON `cat`.`id` = `a`.`c_ques_cat` LEFT JOIN `tmnet_extensions` as `e` ON e.element = b.c_type WHERE e.folder = "joomlaquiz" AND e.type = "plugin" AND a.c_quiz_id = 0<br />Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8_unicode_ci,IMPLICIT) for operation '=' SQL=SELECT a.*, b.c_qtype as qtype_full, c.c_title as quiz_name,`cat`.`title` AS `category`,e.enabled FROM `tmnet_quiz_t_question` AS `a` LEFT JOIN `tmnet_quiz_t_qtypes` as `b` ON b.c_id = a.c_type LEFT JOIN `tmnet_quiz_t_quiz` as `c` ON a.c_quiz_id = c.c_id LEFT JOIN `tmnet_categories` AS `cat` ON `cat`.`id` = `a`.`c_ques_cat` LEFT JOIN `tmnet_extensions` as `e` ON e.element = b.c_type WHERE e.folder = "joomlaquiz" AND e.type = "plugin" AND a.c_quiz_id = 0 ORDER BY ordering ASC LIMIT 0, 20<br />Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8_unicode_ci,IMPLICIT) for operation '=' SQL=SELECT COUNT(*) FROM `tmnet_quiz_t_question` AS `a` LEFT JOIN `tmnet_quiz_t_qtypes` as `b` ON b.c_id = a.c_type LEFT JOIN `tmnet_quiz_t_quiz` as `c` ON a.c_quiz_id = c.c_id LEFT JOIN `tmnet_categories` AS `cat` ON `cat`.`id` = `a`.`c_ques_cat` LEFT JOIN `tmnet_extensions` as `e` ON e.element = b.c_type WHERE e.folder = "joomlaquiz" AND e.type = "plugin" AND a.c_quiz_id = 0

Hi Kidus,

You can contact Helpdesk to resolve this issue.
www.joomplace.com/support/helpdesk.html

I also have this problem. I get this message:

Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8_unicode_ci,IMPLICIT) for operation '='
Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8_unicode_ci,IMPLICIT) for operation '='

Ingemar

Hello,

I have the same Error:

Error
Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8_unicode_ci,IMPLICIT) for operation '='
Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8_unicode_ci,IMPLICIT) for operation '='

When try add Questions?

Please help!
Regards,,,

Guys,

Please, check whether you use the latest version of Joomla and the database is up to date (Extensions > Manage > Database). If it's not, you can click 'Fix' button to update it.

If the problem remains after that, go to Quiz Deluxe's settings and enable DB fix buttons. Then click on them on the Control Panel. It should fix the problem.