×
Kunena 5.1.15 Released (27 Oct 2019)

The Kunena team has announce the arrival of Kunena 5.1.15 [K 5.1.15] which is now available for download as a native Joomla extension for J! 3.9.x. This version addresses most of the issues that were discovered in K 5.1 and issues discovered during the development stages of K 5.1.

Question Illegal mix of collations

More
8 months 4 days 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
8 months 4 days ago #2 by rich

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

More
8 months 3 days 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
8 months 3 days 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.

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