Emoji does not work...
 
Notifications
Clear all

[Closed] Emoji does not work. Errors: "Topic Add Error" and "Reply failed"

6 Posts
5 Users
2 Likes
7,956 Views
Robert
(@robert)
Support Team Admin
Joined: 8 years ago
Posts: 10499
Topic starter  

We found the reason of this problem. This is the database table charset problem. In this case your database table charset is utf8_general_ci.

This is an old charset, current version of WordPress and wpForo requires utf8mb4_unicode_ci charset.

SOLUTION

Make sure your hosting service MySQL version is 5.5.3 and higher. You can check it in Dashboard > Forums > Dashboard admin page.

To check the charset please open your website database manager (phpMyAdmin) and check the charset of your forum tables. In Your website hosting service > cPanel > phpMyAdmin tool open the database table list and check, the right charset is utf8mb4_unicode_ci or utf8mb4_unicode_520_ci:

You should ask your hosting service to change all tables with _wpforo_ prefix to the mentioned charset.

In case you want to do that yourself, just execute this SQL queries in Hosting Service cPanel > phpMyAdmin database manager, navigate to SQL Tab. If your WordPress table prefix is not wp_   replace all wp_ prefixes in this code to your database table prefixes, if they are wp_ just use it as is:

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
ALTER TABLE `wp_wpforo_forums` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `wp_wpforo_languages` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `wp_wpforo_likes` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `wp_wpforo_phrases` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `wp_wpforo_posts` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `wp_wpforo_profiles` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `wp_wpforo_topics` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `wp_wpforo_usergroups` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `wp_wpforo_views` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `wp_wpforo_visits` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `wp_wpforo_votes` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

If you have wpForo Private Messages addon, it's recommended to do the same for PM tables:

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
ALTER TABLE `wp_wpforo_pmfolders` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `wp_wpforo_pms` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

In case you want to say thank you !)
We'd really appreciate and be thankful if you leave a good review on plugin page. This is the best way to say thank you to this project and support team.


   
(@anonymous20)
Noble Member
Joined: 8 years ago
Posts: 1602
 

Just be carefull with all that. Backup first just in case.

Also:

https://make.wordpress.org/core/2015/04/02/the-utf8mb4-upgrade/


   
Robert reacted
optical
(@optical)
Eminent Member
Joined: 6 years ago
Posts: 30
 

All done and now when an emoji is used the topic reply, topic add or topic edit save and they appear in the post.  Excellent thanks for your help and tom over on Gvectors.

Only on odd thing I notice now is when some are selected from the drop down menu they appear as just a block in the post editor. However when the post is saved it is displayed in the forum correctly. Is this an MCE interpretation problem?

 

www.Radios-tv.co.uk


   
Robert
(@robert)
Support Team Admin
Joined: 8 years ago
Posts: 10499
Topic starter  
Posted by: optical

All done and now when an emoji is used the topic reply, topic add or topic edit save and they appear in the post.  Excellent thanks for your help and tom over on Gvectors.

Thank you optical!

Only on odd thing I notice now is that when some emoji are selected in the post editor, they don't appear as emoji just as a block. However when the post is saved they do appear correctly. 

This one is a browser issue. Not all browsers supports Emoji well. Try other browsers or devices. This is the list of browsers which supports Emoji:

http://blog.getemoji.com/post/57054354336/which-browsers-support-emoji

In case you want to say thank you !)
We'd really appreciate and be thankful if you leave a good review on plugin page. This is the best way to say thank you to this project and support team.


   
vtr666
(@vtr666)
Eminent Member
Joined: 7 years ago
Posts: 32
 

Everything worked! Thank you!!


   
Robert reacted
(@opentradearena)
Active Member
Joined: 6 years ago
Posts: 7
 

🙂 🤗  🤩 

Buy and Sell new/used items @ www.otradearena.com