Hi guys,
The Emoticons don't work anymore. I can choose emote in the comment space but when i public my comment, there is a blank where the emote should be shown. Emote doesn't display.
Have you a solution, please ?
Notifications
Clear all
May 30, 2020 2:21 pm
7 Replies
May 30, 2020 4:07 pm
Hi @emin-khan,
Could you please temporary disable all cache and optimizer plugins and leave a URL to that page?
Also, please make sure you use latest wpDiscuz and wpDiscuz Emoticons addon.
May 30, 2020 5:33 pm
Hi @tomson
You can check on my website adala-news.fr
I don't have any cache or optimizer plugin active. But i have installed Mycred plugin for his badges
May 30, 2020 7:38 pm
We suspect that your database tables collection is very old and don't support multibit data like Emojies. Please use your Hosting Service cPanle > phpMyAdmin Database manager, go to your website database, find the wp_comments table and check the collation. It should be start with utf8mb4_ phrase.
If you still use the old utf8_ you will not have any chance to use the Emojies. The old MySQL database server versions like 5.5 doesn't support utf8mb4_ collation, so you can't change it. If you use 5.6 and higher version you can change all tables collection to utf8mb4_ using this plugin. But please backup the database before using this plugin. This plugin looks outdated but it does his job very well: https://da.wordpress.org/plugins/database-collation-fix/
May 30, 2020 8:02 pm
I have MySQL 5.5 version.
I check and i have utf8_general_ci. So i need to use the datebase collation fix plugin to change toutf8mb4_, that right ?
Or can I ask to my host to update mysql version ?
May 30, 2020 8:04 pm
I remember my host told me they will change my sql version next year maybe... So i can use the plugin to change my utf8_ to utf8mb4_ ?
May 30, 2020 8:11 pm
I check my sql and for some table i have utf8mb4_ (for login example).
May 30, 2020 11:12 pm
Ok, then you should change all tables to utf8mb4_ , try the plugin I mentioned or ask your hosting support to change it. But, they should not only change the table collations, thy should also change each textual field collection to utf8mb4_ .