Kunena 6.3.1 released

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

Question Illegal mix of collations

More
5 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
5 years 2 months ago #2 by rich

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

More
5 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
5 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
4 years 2 months ago - 4 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: 4 years 2 months ago by Nashita.

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

Time to create page: 0.474 seconds