- Posts: 2
- Thank you received: 0
Kunena 7.0.3 Released
The Kunena team has announce the arrival of Kunena 7.0.3 [K 7.0.3] in stable which is now available for download as a native Joomla extension for J! 5.4.x/6.0.x. This version addresses most of the issues that were discovered in K 6.2 / K 6.3 / K 6.4 and issues discovered during the last development stages of K 7.0
Question Illegal mix of collations
7 years 1 week ago #209419
by Omni
Illegal mix of collations was created 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!
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.
7 years 1 week ago #209441
by rich
Important! Always create a backup before you make any changes to your website!
Replied by rich on topic Illegal mix of collations
Seems the same problem here:
www.kunena.org/forum/general-questions-a...bile-device-keyboard
Important! Always create a backup before you make any changes to your website!
Please Log in or Create an account to join the conversation.
7 years 1 week ago #209454
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.
7 years 1 week ago #209457
by ruud
sharing = caring
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)?
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.
6 years 3 weeks ago - 6 years 2 weeks ago #212612
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: 6 years 2 weeks ago by Nashita.
Please Log in or Create an account to join the conversation.
Time to create page: 0.242 seconds