Kunena 6.4.9 & Kunena 7.0.1 Released

The Kunena team has announce the arrival of Kunena 6.4.9 [K 6.4.9] 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

The Kunena team has announce the arrival of Kunena 7.0.1 [K 7.0.1] 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/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

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.

Topics must relate to a currently supported version of Kunena. If you are unsure what is the current supported version of Kunena, please go to the download page.

If you are having problems then, for your own benefit, it would save us all a lot of time if you would kindly post your configuration report when you ask for help from this forum. If you do not post your configuration report we will not ask you for it but you will probably not get your problem solved, either.

Question Users cannot insert emoticons from mobile device keyboard

More
6 years 10 months ago #209421 by tcn
Replied by tcn on topic Users cannot insert emoticons from mobile device keyboard
I read up on the subject a little more and found quite a good guide regarding what has to be done if one were to convert an entire database from utf8 to utf8mb4:

mathiasbynens.be/notes/mysql-utf8mb4

I don't think it's necessary to convert the entire Joomla database. However, converting columns other than of type text requires special attention as described in Step 4. I also took a look at which text columns of the Kunena tables are set to use utf8:

Code:
SELECT TABLE_NAME, COLUMN_NAME, CHARACTER_SET_NAME, COLLATION_NAME FROM `information_schema`.`COLUMNS` WHERE `COLLATION_NAME` = 'utf8_general_ci' AND `TABLE_NAME` LIKE '%kunena%' AND `DATA_TYPE` = 'text'
It's quite a few. But, again, not all of them need to support the full range of unicode characters. The candidates I came up with are, besides the messages, announcements and maybe user signatures.

But, as I mentioned before, I'd like to hear Kunena's position in this matter before embarking on this adventure.

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

More
6 years 10 months ago #209440 by rich
Replied by rich on topic Users cannot insert emoticons from mobile device keyboard

Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8mb4_general_ci,COERCIBLE) for operation '='

hm.. this problem seems not unknown. Please enter the error message (quote above) in the google search. You get many hits.
Important! Always create a backup before you make any changes to your website!

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

More
6 years 10 months ago #209445 by tcn
Replied by tcn on topic Users cannot insert emoticons from mobile device keyboard
Meanwhile the cause of the problem has been determined (thanks Slacker) and a possible solution found. What I'd still like to know:
  • Does Kunena support inserting emotes (and other special characters) directly into messages?
  • If so, why are the tables/columns not configured using the correct collation?
  • If so, will this be addressed in a future update (i.e. changing the collation)?
  • If not, will the error message be changed, so it doesn't look like a misconfiguration?
  • What's the developers point of view on this? Do they consider it a bug, a feature request or something else?

I'm asking all these questions, since I'm hesitant making changes to the database. In my opinion the Kunena tables belong to Kunena and should be maintained by Kunena. I could imagine that less tech savvy users would be at a complete loss as how to resolve the issue. They could potentially even shoot themselves in the foot.

For similar reasons, I have also restrained myself from making changes to the Kunena code. I know I could. But I also know it will come back to haunt me or my successor. Upstream is where changes should be made.

I read through issue #3805 , where this has been brought up before. But it remains unclear if any action has been taken back then like suggested in the last comment.

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

More
6 years 3 months ago - 6 years 3 months ago #211411 by terminus
Replied by terminus on topic Users cannot insert emoticons from mobile device keyboard
I have not migrated any data, started from scratch instead. But I have the same Problem with Emojis, when a user insert them from his cellphone.

Any Ideas?

Cheers
Last edit: 6 years 3 months ago by terminus.

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

More
6 years 1 month ago #211950 by nickza
Replied by nickza on topic Users cannot insert emoticons from mobile device keyboard
Hi there.
I have just taken over a forum powered by Kunena and this issue is also persistent.
When a user on a mobile browser enters an emoji in a post and posts it, the emoji is reflected on the forum as a " ? "

Thank you

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

More
6 years 1 month ago #211952 by rich
Replied by rich on topic Users cannot insert emoticons from mobile device keyboard
Please read this topic: www.kunena.org/forum/k5-1-support-archiv...-replying-or-quoting
Important! Always create a backup before you make any changes to your website!

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

Time to create page: 0.292 seconds