Notifications
Clear all

wpForo 1.x.x [Solved] Posting with emoticon gives "reply request error"

12 Posts
3 Users
3 Likes
2,720 Views
OMTesla
Posts: 217
Topic starter
(@omtesla)
Active Member
Joined: 8 years ago

Hello support.
I have asked before about this but did not received a reply so i decided to create a topic.

I try to reinstall plugin after this flush all caches and update Forum and Users statistics but problem persist.
Also what i observed when i insert them the looks are different than the ones in wpForo, see attachment.

11 Replies
optical
Posts: 30
(@optical)
Eminent Member
Joined: 6 years ago

I had this exact same fault, I logged it over on the gvectors forum and with the help of Tom over there and Robert here, the fault was resolved.

For me its was related to needing charset utf8mb4_unicode_ci, once I ran the advised SQL to update the Db, selecting emoji's no longer stopped posts. I'm not saying your problem is the same but its a place to start checks.

https://gvectors.com/forum/general-questions/emoji-stops-posts/

Robert
Posts: 10499
Admin
(@robert)
Support Team
Joined: 8 years ago

This problem solution is already described in FAQ section. Please follow to this topic:

https://wpforo.com/community/faq/emoji-does-not-work-errors-topic-add-error-and-reply-failed/

OMTesla
Posts: 217
Topic starter
(@omtesla)
Active Member
Joined: 8 years ago

Hello

I have successfully updated almost all wpForo tables as suggested in Robert Solution but one table gives error not know why.

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
ALTER TABLE `xx_wpforo_subscribes` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci;

#1071 - Specified key was too long; max key length is 1000 bytes 

Update: emoticons are working now, should i leave that table as is without change Collate?

Robert
Posts: 10499
Admin
(@robert)
Support Team
Joined: 8 years ago

For the subscriptions table please execute this SQL before converting it to utf8mb:

ALTER TABLE `wp_wpforo_subscribes`
CHANGE COLUMN `user_name` `user_name` VARCHAR(90) NOT NULL DEFAULT '' COLLATE 'utf8mb4_unicode_520_ci' AFTER `active`,
CHANGE COLUMN `user_email` `user_email` VARCHAR(90) NOT NULL DEFAULT '' COLLATE 'utf8mb4_unicode_520_ci' AFTER `user_name`;
Page 1 / 3