Kunena 6.4.7 Released

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

Question Smartphone Emoticons Management

More
1 week 4 days ago #1 by guidocx84
Smartphone Emoticons Management was created by guidocx84
Hello,I would like to know how do you suggest to manage the users that add to their posts emoticons from their smartphone’s keyboard.It is very frequent that the users contact us asking why they are not able to post and always the problem is related to the use of smartphone emoticons.This is an example of the error:Exception throw at line 411 in file /libraries/vendor/joomla/database/src/Mysqli/MysqliStatement.php with message Incorrect string value: '\xF0\x9F\x98\x82\xF0\x9F...' for column `u897299187_db`.`it7g4_kunena_messages_text`.`message` at row 1Here on Kunena Forum I’m noticing that I’m not able to replicate the issue because if I insert an emoticon from the smartphone and I press “Submit”, nothing happens and I’m not able to post, also if I remove the emoticon! I need to close the post, refreshing the page, and retry the submission.Maybe a warning message could be  better.Thanks!

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

More
1 week 3 days ago - 1 week 3 days ago #2 by Pinkeltje
Replied by Pinkeltje on topic Smartphone Emoticons Management
Must be a setting or something else. I have no problem with emoticons from smartphone or keyboard
⏰️🌳🔥🌧🍷🍾🎉🤢🦤 🙏
Last edit: 1 week 3 days ago by Pinkeltje.

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

More
1 week 3 days ago - 1 week 3 days ago #3 by guidocx84
Replied by guidocx84 on topic Smartphone Emoticons Management
Does someone know which kind of setting is it?

😂😉🥳💪🏻😛🤬🙂🐕🙏🏻🤦🏻‍♂️🤣😍👍🏻♥️😝🙏🏻

Today I’m able to use them as you can see above.

Thanks!
Last edit: 1 week 3 days ago by guidocx84.

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

More
1 week 3 days ago #4 by Pinkeltje
Replied by Pinkeltje on topic Smartphone Emoticons Management
Only thing I can think of on your end is a wrong database/table collation. (utf8_general_ci in stead of utf8mb4_unicode_ci)

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

More
1 week 3 days ago #5 by guidocx84
Replied by guidocx84 on topic Smartphone Emoticons Management

Only thing I can think of on your end is a wrong database/table collation. (utf8_general_ci in stead of utf8mb4_unicode_ci)
Thanks, I've checked and I can confirm that the table collation for the table it7g4_kunena_messages_text is utf8mb4_unicode_ci 

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

More
6 days 14 hours ago #6 by guidocx84
Replied by guidocx84 on topic Smartphone Emoticons Management
Hi,
do you have any ideas for me? What can I check to understand why my users are not able to use their smartphone's emoticons to post on my kunena forum?

Thanks!

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

More
5 days 23 hours ago - 5 days 23 hours ago #7 by Pinkeltje
Replied by Pinkeltje on topic Smartphone Emoticons Management
Still think it is collation issue. Can you run this?
Code:
SHOW VARIABLES LIKE 'character_set_connection'; SHOW VARIABLES LIKE 'character_set_client'; SHOW VARIABLES LIKE 'character_set_results';
Which MySQL/MariaDB version are you using?
Last edit: 5 days 23 hours ago by Pinkeltje.

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

More
5 days 12 hours ago - 5 days 12 hours ago #8 by guidocx84
Replied by guidocx84 on topic Smartphone Emoticons Management
Below you can find attached the results of the queries



Database Version: MySQL 8.0.37-cll-lve
Database Collation: utf8mb4_0900_ai_ci
Database Connection Collation: utf8mb4_0900_ai_ci
Last edit: 5 days 12 hours ago by guidocx84.

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

Time to create page: 0.455 seconds