×
Kunena 5.2.9 released and Kunena 6.0.0 (08 Jun 2022)

The Kunena team has announce the arrival of Kunena 5.2.9 [K 5.2.9] which is now available for download as a native Joomla extension for J! 3.10. This version addresses most of the issues that were discovered in K 5.2 and issues discovered during the development stages of previous version of K5.2.

The Kunena team has announce the arrival of Kunena 6.0.0 [K 6.0.0] which is now available for download as a native Joomla extension for J! 4.1.x. Only the module kunena latest and the discuss plugin which are still in beta are working in Joomla! 4.1 with Kunena 6.0.

Question Illegal mix of collations

More
3 years 2 months ago #1 by Omni
Hello,

Some users are having issue posting, Kunena logs shows this fatal error:

"Exception throw at line 665 in file /*filepath*/libraries/joomla/database/driver/mysqli.php with message Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8mb4_general_ci,COERCIBLE) for operation '='"

Any ideas how to fix?

Thanks!

Please Log in or Create an account to join the conversation.

More
3 years 2 months ago #2 by rich

Please Log in or Create an account to join the conversation.

More
3 years 2 months ago #3 by Omni
Replied by Omni on topic Illegal mix of collations
Thanks Rich, I think you're right. I'm surprised that didn't come up in my many searches. Thanks again.

Please Log in or Create an account to join the conversation.

More
3 years 2 months ago #4 by ruud
Replied by ruud on topic Illegal mix of collations
Hi, yesterday encountered the same issue: user trying to input emoji from mobile keyboard freaking out kunena with front-end error messages.

Are there any plans of doing the collation to UTF-8 Multibyte in the Kunena upgrade / install script? Or is there an instruction on how to do it manually (including necessary checks)?

sharing = caring

Please Log in or Create an account to join the conversation.

More
2 years 3 months ago - 2 years 2 months ago #5 by Nashita
Replied by Nashita on topic Illegal mix of collations
What exactly is Collation out of interest? It would be good to get this final query running for sure :slight_smile: Also I was wondering if anyone can suggest a good way to consolidate the principles Walgreenslistens I learnt in this book? I dont have any SQL based projects on the go at present that I can test my new skills on.
Last edit: 2 years 2 months ago by Nashita.

Please Log in or Create an account to join the conversation.

  • Not Allowed: to create new topic.
  • Not Allowed: to reply.
  • Not Allowed: to edit your message.
Time to create page: 0.083 seconds