By Ndmn518 on Saturday, 06 February 2021
Posted in Technical Issues
Replies 4
Likes 0
Views 1.1K
Votes 0
Hi!

In my comments area often appears a question mark like ??? instead of a symbol. How i can fix it or remove, hide it?

These question marks change the meaning of the message a lot.

Look screenshot.
It seems like the current Komento version doesn't support the emoji and this is why it shows a question mark in the comment.

Can you try to execute the following SQL queries in your database then try to add a new comment and contain emoji and see how it goes?


ALTER TABLE `jos_komento_comments` CHANGE `comment` `comment` TEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL;

ALTER TABLE `jos_komento_comments` CHANGE `preview` `preview` LONGTEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL;


Remember do the full backup first and replace jos_ with your current table prefix before execute it.

For the existing question mark, you have to manually delete it from the backend, edit those existing comments.
·
Saturday, 06 February 2021 11:09
·
0 Likes
·
0 Votes
·
0 Comments
·
Yes its helped. Emoji from a mobile phone are now works.
·
Saturday, 06 February 2021 23:32
·
0 Likes
·
0 Votes
·
0 Comments
·
Will test for a while
·
Saturday, 06 February 2021 23:32
·
0 Likes
·
0 Votes
·
0 Comments
·
Sure, keep us updated then.
·
Monday, 08 February 2021 09:52
·
0 Likes
·
0 Votes
·
0 Comments
·
View Full Post