Jump to content

Help!! All my Twitter style emoji change to question sign


beats23
Go to solution Solved by Jim M,

Recommended Posts

Need a solution.

All the twitter style emoji on my board has turned to a question sign.

 

All the emoji on my board now looks like this question sign image below.

2097180444_Screenshot2021-10-15at11_11_44pm.png.70c32e625fc219dbfe0d0803eeee49fc.png

 

This is what's in my emoji settings.

452154185_Screenshot2021-10-15at11_17_29pm.png.624868438ceb5870bc0d9e3c5656bc3f.png

 

Has any one other than me has this issue?

Is there a fix?

 

Link to comment
Share on other sites

The broken smile face emoji link in the source is <img alt="?" class="ipsEmoji" src="https://twemoji.maxcdn.com/2/72x72/3f.png">

The working links is <img alt="😀" class="ipsEmoji" src="https://twemoji.maxcdn.com/2/72x72/1f600.png">

It seems emoji web link PNG file name is changing by itself over time, which cause the emoji weblink to be broken.

Any thoughts?

 

Edited by beats23
Link to comment
Share on other sites

@beats23Have you migrated your database to a new server? or restored a backup from a Mysql dump?

I've been through that before and I lost my emojis due to those doing the server migration for me being careless. They generated a manual backup of the database, and unfortunately Mysql dump default is UTF8 and not utf8mb4, which is what's needed for Emojis to work.

If you haven't done anything, and this happened maybe the server connection collation has been changed somehow. In that case you may be able to revert it to utf8mb4 in the general settings of your database.

2025295604_ScreenShot2021-10-16at6_42_08pm.thumb.png.cd8ea3d1fe71d6bca979a888f668ba15.png

Failing that maybe you have a backup that the server automatically generated when this setting was correct. But even in that case it depends on how much new content has been added since, so it may be a tough choice between old emojis and latest content. In my case I only realised about the broken emojis 3 months later, so I basically didn't have a choice.

Regardless, you want that set above to utf8mb4_unicode_ci for new emojis.

It could be some other reason behind the problem, but what you say sounds very familiar to me.

 

Edited by PPlanet
Link to comment
Share on other sites

On 10/16/2021 at 8:49 AM, PPlanet said:

@beats23Have you migrated your database to a new server? or restored a backup from a Mysql dump?

I've been through that before and I lost my emojis due to those doing the server migration for me being careless. They generated a manual backup of the database, and unfortunately Mysql dump default is UTF8 and not utf8mb4, which is what's needed for Emojis to work.

If you haven't done anything, and this happened maybe the server connection collation has been changed somehow. In that case you may be able to revert it to utf8mb4 in the general settings of your database.

2025295604_ScreenShot2021-10-16at6_42_08pm.thumb.png.cd8ea3d1fe71d6bca979a888f668ba15.png

Failing that maybe you have a backup that the server automatically generated when this setting was correct. But even in that case it depends on how much new content has been added since, so it may be a tough choice between old emojis and latest content. In my case I only realised about the broken emojis 3 months later, so I basically didn't have a choice.

Regardless, you want that set above to utf8mb4_unicode_ci for new emojis.

It could be some other reason behind the problem, but what you say sounds very familiar to me.

 

Hi, yes I did change server.

Thanks for your information.

Link to comment
Share on other sites

  • Solution
17 minutes ago, beats23 said:

Hi, no I don't know how to sort it, as I don't have a backup of the Db.

I would advise reaching out to your hosting provider if you do not have a backup. Unfortunately, once you converted to a non-mb4 collation, there is no way back as it has gotten rid of these emoji characters essentially.

Link to comment
Share on other sites

  • Recently Browsing   0 members

    • No registered users viewing this page.
×
×
  • Create New...