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

[beats23]

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.

 

This is what's in my emoji settings.

 

Has any one other than me has this issue?

Is there a fix?

 

[beats23]

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 October 15, 2021 by beats23

[PPlanet]

@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.

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 October 16, 2021 by PPlanet

[Marc]

I would certainly check what is mentioned above, as I have seen this happen previously myself.

[beats23]

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.

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.

[Marc]

22 hours ago, beats23 said:

Hi, yes I did change server.

Thanks for your information.

Did you manage to get that sorted in the end?

[beats23]

13 hours ago, Marc Stridgen said:

Did you manage to get that sorted in the end?

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

[Jim M]

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.