By Meagan Hooper on Tuesday, 13 June 2017
Posted in General Issues
Replies 5
Likes 0
Views 680
Votes 0
Hello,

When users post emoji's from their iPhone's they often display in the stream as '????" making the comment look like we're asking a question.

Here (and attached) are two link examples:
http://www.bsmartguide.com/connect/stream/item/8372.html
http://www.bsmartguide.com/connect/stream/item/8398.html

Would it be possible for unrecognized emoji's to appear blank instead of the '????' ?

The questions marks only come across as untented offensive.

Thank you!
Hi there,

It seems that i can replicate this locally. I have created a ticket internally and this fixes will be included on our next release version.
·
Wednesday, 14 June 2017 10:27
·
0 Likes
·
0 Votes
·
0 Comments
·
Hi there,

I have consulted this with our developer and it seems that this issues already fixed on our older version. By the way, on your site, it is not working because you are using database 5.5 version currently. It would be best if you can update them to higher than 5.5, that 5.6 and above. Then you need to run maintenance script at Backend>Maintenance. Those previously emoji somehow will not shown correctly, and only new emoji will shown correctly.

Sorry for any inconvenience caused and thanks for your understanding
·
Wednesday, 19 July 2017 16:06
·
0 Likes
·
0 Votes
·
0 Comments
·
Hello Abdul,

We are using the MariaDB on this site and it is the current version distributed with the server software. You said you could replicate this on your local site, so that would seem to indicate that the problem is elsewhere. Can you ask your developer to look at this again?

Thank You.
·
Wednesday, 19 July 2017 22:27
·
0 Likes
·
0 Votes
·
0 Comments
·
Hello Meagan,

Apologies for that. My colleague was able to replicate this most likely because he did not run the maintenance script on his local environment.

The emoji issue has been fixed by altering the table column, "comment" to use the charset of utf8mb4 instead. Not entirely sure if the column on your table has been updated or not as we do not have the phpmyadmin access to your site.

Perhaps you could try running the following query and try posting the emoji on your mobile device again?

[gist]
ALTER TABLE `#__social_comments` MODIFY `comment` TEXT CHARACTER SET utf8mb4 NOT NULL;
[/gist]

Remember to replace #__ with your table prefix. This was the test that was done by my colleague earlier, on his local test machine http://screen.stackideas.com/Ezrulsio_-_Dashboard_-_easysocial.com_-_Google_Chrome_2017-07-19_13.36.59.png
·
Wednesday, 19 July 2017 22:32
·
0 Likes
·
0 Votes
·
0 Comments
·
View Full Post