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 4 months 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 4 months 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 11 months 2 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 7 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 6 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.134 seconds

We do our best to secure your data and to be
GDPR compliant.
However, we are not fully there yet.

With that said we'd like you to know that we use cookies.
We store user session cookie only to enable both registered and guest users to use the shopping cart.
Please note that 3rd party cookies may still be encountered on the pages with social media "share" and "like" buttons.

To ensure your privacy we have currently stopped using any analytics tools like Google Analytics.

We anonymize your IP address on the server side so your IP is not tracked by any means.

We DO NOT pass ANY of your data to 3rd parties.
We will do our best to provide maximum transparency in future if anything will change.

Also, we will store cookies to determine if you saw this message.