wpForo - WordPress Forum Plugin

wpForo – WordPress Forum Plugin
  • Home
  • Forum
  • Migrate to wpForo
  • Addons
  • Documentation

Forum

Home | Forum

  • Forums
  • Members
  • Recent Posts
  • Register
  • Login
General Forums Frequently Asked Qu... Emoji does not work...  

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

    Last Post
  RSS

Robert
 Robert
(@robert)
Support Team Admin
Joined:2 years  ago
Posts: 3911
Robert - Twitter
December 12, 2017 6:45 pm  

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;
Edited: 2 months  ago

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.


MassimoD
 MassimoD
(@massimod)
Reputable Member
Joined:1 year  ago
Posts: 458
December 12, 2017 6:52 pm  

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

Also:

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

Edited: 4 months  ago

Robert liked
optical
 optical
(@optical)
Eminent Member
Joined:5 months  ago
Posts: 30
December 12, 2017 7:14 pm  

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?

 

Edited: 4 months  ago

www.Radios-tv.co.uk


Robert
 Robert
(@robert)
Support Team Admin
Joined:2 years  ago
Posts: 3911
Robert - Twitter
December 12, 2017 7:20 pm  
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
(@vtr666)
Eminent Member
Joined:2 years  ago
Posts: 32
December 12, 2017 8:37 pm  

Everything worked! Thank you!!


Robert liked
OpenTradeArena
 OpenTradeArena
(@opentradearena)
Active Member
Joined:6 months  ago
Posts: 7
OpenTradeArena - Facebook OpenTradeArena - Twitter
December 13, 2017 10:55 am  

🙂 🤗  🤩 

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


Forum Search

Download wpForo plugin
on WordPress.org

wpForo Addons

wpforo-private-messages  wpforo-advanced-attachments-128x128  wpforo-embeds-128x128 wpForo User Custom Fields addon  wpForo – Blog Cross Posting addon  wpForo Ads Manager
View all Addons »

Recent Topics

  • HTML errors

    By eddr, 15 hours  ago

  • Unable to Authorize Email

    By biggerbush, 16 hours  ago

  • Removing certain member activities

    By Deionatrix, 18 hours  ago

  • Getting permanent notification icon for banned users... why?

    By TGW, 1 day  ago

  • Need Help

    By Jordan Moffett, 1 day  ago

  • Making it one topic

    By Deionatrix, 2 days  ago

  • How to change MCE container color on reply form?

    By webpikirdong, 2 days  ago

  • Input fields in user account show white background and white typing?

    By Todd Scire, 3 days  ago

If you liked wpForo

Thank you very much for using wpForo. This is a new forum plugin and we do our best to make it better every day. We work hard to allow people create a beautiful and powerful communities on WordPress. We'd really appreciate and be thankful if you leave a good review on plugin page. This will helps us keep plugin rating high and make it more popular. This is the best way to say thank you to this project and support team.

Thank you!
Sincerely yours,
gVectors Team 

Recent Posts

  • RE: From MyBB to wpForo

    News? 🍹  

    By Tropico, 9 hours  ago

  • RE: Getting permanent notification icon for banned users... why?

    Posted by: SofyHi TGW,You should navigate to Dashboard ...

    By TGW, 11 hours  ago

  • RE: Getting permanent notification icon for banned users... why?

    Hi TGW,You should navigate to Dashboard > Forums >...

    By Sofy, 14 hours  ago

  • RE: Need Help

    Hi Jordan Moffett,Please read this support topic/p>For ...

    By Sofy, 14 hours  ago

  • HTML errors

    HiPlease fix HTML errors shown by the w3 validator:Some...

    By eddr, 15 hours  ago

  • Unable to Authorize Email

    Hi,I have a problem authorizing new users for my siteAf...

    By biggerbush, 16 hours  ago

  • RE: Unable to make changes to member profile as Admin

    I was playing around with some settings and now it just...

    By Kamran Ahmad, 17 hours  ago

  • Removing certain member activities

    Is there any way to remove some of the member activitie...

    By Deionatrix, 18 hours  ago

  • RE: How to change MCE container color on reply form?

    Posted by: SofyHi webpikirdong,Please use the following...

    By webpikirdong, 23 hours  ago

  • Getting permanent notification icon for banned users... why?

     I've banned two users, and now the forum button on the...

    By TGW, 1 day  ago

  • RE: Answers are not counting

    When will it be released?

    By uman231, 1 day  ago

  Forum Statistics
15 Forums
2,248 Topics
11.4 K Posts
0 Online
4,203 Members

Latest Post: Remove WP Foro takeing over from wordpress Our newest member: bcheng Recent Posts

Topic Icons: New Replied Active Hot Sticky Unapproved Solved Private Closed

  
Working

Please Login or Register

Powered by wpForo | Copyright © 2016-2018 gVectors Team
Copyright Registration Service - Click here for more information or to register work
wpForo is Registered with the IP Rights Office
Copyright Registration Service

Ref: 4477265538
  • Home
  • Forum
  • Migrate to wpForo
  • Addons
  • Documentation