additional
Home > Forum > Joomla components > JoomlaQuiz Deluxe > Getting this error in admin
Welcome, Guest
Username: Password: Remember me
  • Page:
  • 1

TOPIC: Getting this error in admin

Getting this error in admin 1 year 1 month ago #25948

  • Kidus
  • Kidus's Avatar
  • OFFLINE
  • Fresh Boarder
  • Posts: 1
  • Karma: 0
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
The administrator has disabled public write access.

Getting this error in admin 1 year 1 month ago #25949

  • Tanya
  • Tanya's Avatar
  • OFFLINE
  • Moderator
  • Posts: 218
  • Thank you received: 14
  • Karma: 0
Hi Kidus,

You can contact Helpdesk to resolve this issue.
www.joomplace.com/support/helpdesk.html
The administrator has disabled public write access.

Getting this error in admin 8 months 3 days ago #26216

  • Ingemar
  • Ingemar's Avatar
  • OFFLINE
  • Fresh Boarder
  • Posts: 1
  • Karma: 0
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
The administrator has disabled public write access.

Getting this error in admin 4 months 2 weeks ago #26511

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,,,
The administrator has disabled public write access.

Getting this error in admin 3 months 3 weeks ago #26548

  • Tanya
  • Tanya's Avatar
  • OFFLINE
  • Moderator
  • Posts: 218
  • Thank you received: 14
  • Karma: 0
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.
The administrator has disabled public write access.
  • Page:
  • 1
Time to create page: 0.162 seconds