XF 2.1 [Solved] Emojis not showing-up in Phrases?

[Neutral Singh]

Clicking Save does not save the emojis in the phrases? How can I show a emoji in the phrases?

 

[Chris D]

If this is a forum that was upgraded from XF 1.5 then perhaps you haven’t converted your database to utf8mb4 yet.

Or perhaps you have but you haven’t added the fullUnicode flag to src/config.php.

There are no reasons emoji shouldn’t work so I’d start with the above.

 

[Neutral Singh]

@Chris D

Can I use phpmyadmin > Operations > Collation to convert to utf8mb4_general_ci?
And is checking both of the check-boxes OK?

Thank you

 

[Chris D]

While that may work, it isn't an approach that we support or recommend.

We advise you to complete the steps here:

Emoji and unicode support | XenForo

XenForo 2 supports full unicode text, which means that emoji can be used in almost all locations that users can enter text.

xenforo.com

 

[Neutral Singh]

Ran this command in shell: php cmd.php xf:convert-utf8mb4 but with one error...

The following tables failed to convert:
    * xf_search_index: xf_search_index: MySQL query error [1366]: Incorrect string value: '\xF2&\x90\xB3\x00...' for column 'metadata' at row 165604
You should contact the table creator for guidance. Failure to correct this may lead to unexpected behavior.

Conversion complete, but with errors!

 

[Chris D]

This probably just means you should delete and recreate your search index. If you are using Enhanced Search then you can just truncate/empty the table and no further action is required.

Then you can add:

$config['fullUnicode'] = true;

To your src/config.php file and you should have full use of emojis.

 

[Neutral Singh]

Done! Now working as desired, Thank you