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.

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 9 months ago #209255 by tcn
Users cannot insert emoticons from mobile device keyboard was created by tcn
Since Kunena has a nice mobile interface, more and more of our users using mobile devices to access our forums. On most mobile devices you have the ability to insert emoticons directly from the device's keyboard. However, doing so leads to the following error (in the backend log):
Code:
Exception throw at line 665 in file \/home\/web\/transalpclub.nl\/http_docs\/libraries\/joomla\/database\/driver\/mysqli.php with message Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8mb4_general_ci,COERCIBLE) for operation '='
Is this supposed to work? In my opinion it should.

[hr]

This message contains confidential information

Database collation check: ✔ The collation of your table fields are correct

Joomla! SEF: Enabled | Joomla! SEF rewrite: Enabled | FTP layer: Disabled |

This message contains confidential information
htaccess: Exists | PHP environment: Max execution time: 30 seconds | Max execution memory: 128M | Max file upload: 8M

Kunena menu details:

Warning: Spoiler!

Joomla default template details : astroid_template_zero | author: JoomDev | version: 2.0.2 | creationdate: Nov 2018

Kunena default template details : Crypsisb3 | author: Kunena Team | version: 5.1.10.1 | creationdate: 2019-03-04

Kunena template params:

Warning: Spoiler!

Kunena version detailed: Kunena 5.1.10.1 | 2019-03-04 [ Janus ]
| Kunena detailed configuration:

Warning: Spoiler!
| Kunena integration settings:
Warning: Spoiler!
| Joomla! detailed language files installed:
Warning: Spoiler!

Third-party components: UddeIM 4.0

Third-party SEF components: None

Plugins: None

Modules: None

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

More
6 years 9 months ago #209325 by tcn
Replied by tcn on topic Users cannot insert emoticons from mobile device keyboard
Any news on this issue?

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

More
6 years 9 months ago - 6 years 9 months ago #209328 by Slacker
Replied by Slacker on topic Users cannot insert emoticons from mobile device keyboard
I use Crypsis as Kunena template and it works OK with smileys, Have you tried to change template. Also read this about this type of error,
stackoverflow.com/questions/9819159/ille...f8-unicode-ci-implic

Here is from my kunena_smilies database table:

CREATE TABLE `zoc_kunena_smileys` (
`id` int(4) NOT NULL,
`code` varchar(12) CHARACTER SET utf8 NOT NULL DEFAULT '',
`location` varchar(50) CHARACTER SET utf8 NOT NULL DEFAULT '',
`greylocation` varchar(60) CHARACTER SET utf8 NOT NULL DEFAULT '',
`emoticonbar` tinyint(4) NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

Maybe you have: utf8_general_ci instead of utf8mb4_unicode_ci for COLLATE above. utf8mb4 is needed for emojs.
Last edit: 6 years 9 months ago by Slacker.

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

More
6 years 9 months ago #209336 by tcn
Replied by tcn on topic Users cannot insert emoticons from mobile device keyboard
Thanks for your reply.

I checked the Joomla database to be sure. All Kunena tables are utf8mb4_unicode_ci. I wouldn't expect otherwise, since these tables have been created by Kunena itself when the forum was installed.

Moreover, I believe you misread the issue. The table you mentioned relates to Kunena's own emoticons. The issue, I described, happens when users insert emotes using their smartphone keyboard. These are entirely different emotes than Kunena's own. It's more like trying to insert special characters.

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

More
6 years 9 months ago #209337 by Slacker
Replied by Slacker on topic Users cannot insert emoticons from mobile device keyboard
Then your emoj is inserted in kunena_messages_text where the text is in utf8_general_ci. Like your error message said.

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

More
6 years 9 months ago #209339 by tcn
Replied by tcn on topic Users cannot insert emoticons from mobile device keyboard
I don't think so:



Or am I missing something?

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

Time to create page: 0.336 seconds