Kunena 6.4.8 Released

The Kunena team has announce the arrival of Kunena 6.4.8 [K 6.4.8] in stable which is now available for download as a native Joomla extension for J! 5.0.x/5.1.x/5.2.x/5.3.x/5.4.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 6.4
Important note: Go to the Kunena Dashboard after an upgrade so that the Kunena database tables are also updated. This is particularly necessary for major version jumps so that the table changes are adapted.

Solved fatal error...

More
6 years 5 months ago #1 by mikerotec
fatal error... was created by mikerotec
"Exception throw at line 665 in file /var/www/html/wsvr/html/libraries/joomla/database/driver/mysqli.php with message Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8mb4_general_ci,COERCIBLE) for operation '='"

Whoops! not sure how that happened ( never seen before...)

running Kunena 5.1.12.1 | 2019-04-22 [ Kerberos ]

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

More
6 years 5 months ago #2 by xillibit
Replied by xillibit on topic fatal error...
Hello,

Joomla in last version use tables in utf8mb4_general, the issue is that you have still tables in utf8_general. To fix this i think is to convert collations on tables to utf8mb4_general

I don't provide support by PM, because this can be useful for someone else.
The following user(s) said Thank You: mikerotec

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

More
5 years 7 months ago #3 by freri030
Replied by freri030 on topic fatal error...

mikerotec wrote: "Exception throw at line 665 in file /var/www/html/wsvr/html/libraries/joomla/database/driver/mysqli.php with message Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8mb4_general_ci,COERCIBLE) for operation '='"

Whoops! not sure how that happened ( never seen before...)

running Kunena 5.1.12.1 | 2019-04-22 [ Kerberos ]



I have the same problem, but noticeably from 1 user's account.

I am using: Joomla 3.9.15 and Kunena 5.1.16

"Exception throw at line 665 in file \/home\/wimfrwz132\/domains\/maagdarmstoornis.nl\/public_html\/v2\/libraries\/joomla\/database\/driver\/mysqli.php with message Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8mb4_general_ci,COERCIBLE) for operation '='"

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

More
5 years 7 months ago #4 by xillibit
Replied by xillibit on topic fatal error...
Hello,

You have some entries which aren't in utf8mb4, so look here : www.kunena.org/forum/general-questions-a...board?start=0#209337

I don't provide support by PM, because this can be useful for someone else.

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

More
5 years 7 months ago #5 by freri030
Replied by freri030 on topic fatal error...
I found the problem. When creating a new database in direct admin, different collisions are created per database. I now have the correct utf8mb4 and think the problem is solved.

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

Time to create page: 0.255 seconds