Twitter emojis returning 404 on old posts

[CoffeeCake]

We're seeing reports that Twitter emojis are not displaying. Inspecting shows that the embedded images are returning 404.

This was after moving our database server--looks like it may have been something to do with the emoji characters not making it in the backup/restore. New emojis work just fine after wards.

[Stuart Silvester]

11 hours ago, Paul E. said:

We're seeing reports that Twitter emojis are not displaying. Inspecting shows that the embedded images are returning 404.

This was after moving our database server--looks like it may have been something to do with the emoji characters not making it in the backup/restore. New emojis work just fine after wards.

You may find that if you look at the content directly, the emoji are now just a single question mark in the database. This can happen if the export isn't using the utf8mb4 character set for the connection.

You will want to use the following when running mysqldump to ensure that it's using the right character set.

--default-character-set=utf8mb4

 

[CoffeeCake]

Thanks, Stuart. That's precisely what we saw (and what we ultimately replaced to clean up). We're looking into what we'll need to do next time around to avoid this within the Google Cloud infrastructure.