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 #209340 by Slacker
Replied by Slacker on topic Users cannot insert emoticons from mobile device keyboard
Look in the structure of the table the text is in utf8_general_ci. How do the emojs look like when its in the text of the message.

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

More
6 years 10 months ago #209342 by tcn
Replied by tcn on topic Users cannot insert emoticons from mobile device keyboard
Well, I learned something today. B)
Code:
SELECT COLUMN_NAME, CHARACTER_SET_NAME, COLLATION_NAME FROM `information_schema`.`COLUMNS` WHERE `TABLE_NAME` LIKE 'jml_kunena_messages_text'
That shows me that the column message is indeed utf8_general_ci, utf8 encoded, despite the table collation being utf8mb4_unicode_ci.

Before I start jumping ahead here, I would like to know if that is the default setting by Kunena or the result of our migration from SMF. In SMF, by the way, inserting emoticons from a local device keyboard worked fine. Albeit, it wasn't used very often.

What do I need to watch out for if I decide to go ahead and convert the encoding to utf8mb4_unicode_ci? I read somewhere, that converting between incompatible sets may result in data loss. :unsure:

Regarding your question of what the emotes look like: it's impossible to tell. Messages with such emotes are simply rejected and the user receives a general error message: "Kunena internal error: please enable debug modus and report the issue to your forum administrator" (my translation from the Dutch text shown in a screenshot). In the backend I get the message from the opening post.

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

More
6 years 10 months ago #209343 by Slacker
Replied by Slacker on topic Users cannot insert emoticons from mobile device keyboard
Here is my settings:
CREATE TABLE `zoc_kunena_messages_text` (
`mesid` int(11) NOT NULL DEFAULT '0',
`message` text CHARACTER SET utf8 NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

As you see message text character set is utf8 and thats the problem with emoticons that need multibyte.
Read also this post:
github.com/Kunena/Kunena-Forum/issues/3805

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

More
6 years 10 months ago #209347 by tcn
Replied by tcn on topic Users cannot insert emoticons from mobile device keyboard
@Slacker, thanks for your help. You pointed me to the root of the problem. But your code snippet isn't very helpful. I know how to create a table with the correct encoding and collation. What I need is advice on changing the encoding/collation of a column in an existing table.

In that respect I agree with last comment in the issue you pointed out. Database maintenance/migration should be handled by Kunena itself. Since the issue in GitHub is almost two years old, I would really like to hear from a Kunena developer (or at least one of the moderators here) why the encoding is still utf8 and thus Kunena does not support "local" emoticons.

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

More
6 years 10 months ago #209415 by rich
Replied by rich on topic Users cannot insert emoticons from mobile device keyboard
If you install Kunena new, it creates the tables with the collation which you have set as default in your database. If you want afterwards to change it, you must do it yourself.

What I need is advice on changing the encoding/collation of a column in an existing table.

Should work with phpMyAdmin (click on table -> Operations) but it will change it for all columns, and I've no idea whether is correct if you only for single table changes the collation.
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 #209420 by tcn
Replied by tcn on topic Users cannot insert emoticons from mobile device keyboard

If you install Kunena new, it creates the tables with the collation which you have set as default in your database. If you want afterwards to change it, you must do it yourself.

I checked the defaults and they neither agree with the table collation nor with the encoding of the column in the table:

Code:
SELECT @@collation_server; SELECT @@character_set_server; latin1_swedish_ci latin1
Moreover, is it wise to create tables with the default settings? The application knows best what it needs based on what it needs to support. So, shouldn't the tables and/or columns be created according to the needs of the application?

Should work with phpMyAdmin (click on table -> Operations) but it will change it for all columns, and I've no idea whether is correct if you only for single table changes the collation.

The thing is the collation setting for the table is correct. It's set to utf8mb4_unicode_ci. The column in the table, though, uses a different collation, namely utf8_general_ci. That's why local emotes cannot be inserted.

Should I rather open a bug in GitHub, so one of the developers can chime in and hopefully provide some insights?

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

Time to create page: 0.319 seconds