Support » Plugin: UpdraftPlus WordPress Backup Plugin » Lost some of emoji after restoring database

  • Resolved keeeper

    (@keeeper)



    Hi,

    Thanks for the great plugin.
    I recently faced an issue after restoring database using Updraft. Some of the emoji have been replaced to ????, some of emoji are ok. Wp_posts endocing is utf8mb4.
    When talking about emoji I mean 🙂🍒🔆

Viewing 6 replies - 1 through 6 (of 6 total)
  • Plugin Contributor DNutbourne

    (@dnutbourne)

    Hi,

    Please could you send us a copy of the restoration log? This can be found in the ‘wp-content/updraft’ directory via FTP.

    The contents will be too long to post here directly, but you can use an online service such as Pastebin, and post the link here.

    Hi,

    Sorry for the delay.

    1. Here is the page before database restoration:

    Pasting its content here: This is a test page 😀😂🐰🐯👆🙌😃😉

    2. Here is the page after the restoration:

    Pasting its content here: This is a test page ????????????????????????????????

    The log file: https://pastebin.com/raw/pP3g9QBE

    • This reply was modified 1 year, 2 months ago by  keeeper.
    Plugin Contributor DNutbourne

    (@dnutbourne)

    Hi,

    Please could you check the Database Charset in your wp-config.php file on the new site?
    e.g.

    /** Database Charset to use in creating database tables. */
    define('DB_CHARSET', 'utf8mb4');

    Hi,

    It was:
    define('DB_CHARSET', 'utf8');
    After reading your last post I’ve changed it to
    define('DB_CHARSET', 'utf8mb4');

    Now database restoration does not cause emoji loss, thanks.
    Is config file change the only thing needed to avoid the issue?

    Plugin Contributor DNutbourne

    (@dnutbourne)

    Hi,

    Yes, this should be the only thing that needs changing if migrating from a site where the emoji worked correctly.

    Hi,

    Thanks a lot for the reply and help.

Viewing 6 replies - 1 through 6 (of 6 total)
  • The topic ‘Lost some of emoji after restoring database’ is closed to new replies.