beats23 Posted October 15, 2021 Share Posted October 15, 2021 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? Link to comment Share on other sites More sharing options...
beats23 Posted October 15, 2021 Author Share Posted October 15, 2021 (edited) 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 Link to comment Share on other sites More sharing options...
PPlanet Posted October 16, 2021 Share Posted October 16, 2021 (edited) @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 Maxxius and beats23 1 1 Link to comment Share on other sites More sharing options...
Marc Posted October 16, 2021 Share Posted October 16, 2021 I would certainly check what is mentioned above, as I have seen this happen previously myself. beats23 1 Link to comment Share on other sites More sharing options...
beats23 Posted October 17, 2021 Author Share Posted October 17, 2021 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. PPlanet 1 Link to comment Share on other sites More sharing options...
Marc Posted October 18, 2021 Share Posted October 18, 2021 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? Link to comment Share on other sites More sharing options...
beats23 Posted October 18, 2021 Author Share Posted October 18, 2021 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. Link to comment Share on other sites More sharing options...
Solution Jim M Posted October 18, 2021 Solution Share Posted October 18, 2021 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. beats23 1 Link to comment Share on other sites More sharing options...
Recommended Posts