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
Translate
▼
English
Spanish
French
German
Italian
Portuguese
Russian
Chinese
Japanese
Korean
Arabic
Hindi
Dutch
Polish
Turkish
Vietnamese
Thai
Swedish
Danish
Finnish
Norwegian
Czech
Hungarian
Romanian
Greek
Hebrew
Indonesian
Malay
Ukrainian
Bulgarian
Croatian
Slovak
Slovenian
Serbian
Lithuanian
Latvian
Estonian
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
Translate
▼
English
Spanish
French
German
Italian
Portuguese
Russian
Chinese
Japanese
Korean
Arabic
Hindi
Dutch
Polish
Turkish
Vietnamese
Thai
Swedish
Danish
Finnish
Norwegian
Czech
Hungarian
Romanian
Greek
Hebrew
Indonesian
Malay
Ukrainian
Bulgarian
Croatian
Slovak
Slovenian
Serbian
Lithuanian
Latvian
Estonian
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
Translate
▼
English
Spanish
French
German
Italian
Portuguese
Russian
Chinese
Japanese
Korean
Arabic
Hindi
Dutch
Polish
Turkish
Vietnamese
Thai
Swedish
Danish
Finnish
Norwegian
Czech
Hungarian
Romanian
Greek
Hebrew
Indonesian
Malay
Ukrainian
Bulgarian
Croatian
Slovak
Slovenian
Serbian
Lithuanian
Latvian
Estonian
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_ .