Emojis gone

Due to misaligned blocks on pages using phone browser...rc2 update...i asked host provider to restore my site and db from 5 days earlier. I got it back at rc1 version and blocks and image preview are ok but there is no emojis now.

There is a gray baloon empty and but when clicked on who liked..it shows who liked. Please see image.

Does anyone know what is missing?

Thanks in advance.

  • Up vote
    1
    Down vote
  • View
    465
  • More
Attachments
Replies (4)

    • Your database dump wasn't properly dumped or restored, because all multibyte characters are lost.

      When making a backup it's always better to add special flag to make sure multibyte characters are properly dumped, for example:

      mysqldump --default-character-set=utf8mb4 db_name_here > dump.sql

      • Thanks for replying...but what do i do now? How can i fix it?

        • You can try to fix it manually by going to Studio > Developer > Forms > Data Items > System > Reactions

          Then edit each item, by entering proper emoji for each row, please don't break PHP serialized string formatting, like this:

          • I've got it!!! Thank you a lot Alex!

            On my site I was missing that small image from this code... there was ? mark instead of image...for all reactions. And my code looked a bit different (took the code from una13b4 and pasted it to current rc2) :

            a:5:{s:5:"emoji";s:4:"?";s:4:"icon";s:0:"";s:5:"color";s:20:"sys-colored col-gray";s:6:"weight";s:1:"1";s:7:"default";s:9:"thumbs-up";}

            instead of

            a:5:{s:5:"emoji";s:4:"👍";s:4:"icon";s:0:"";s:5:"color";s:20:"sys-colored col-gray";s:6:"weight";s:1:"1";s:7:"default";s:9:"thumbs-up";}

            Now it is working as supposed to. Thank You Alex for your directions!!!!

            Login or Join to comment.