Incorrect string value: '\xF0\x9F\x91\x87\xF0\x9F - error

[Fenrir]

I think the problem is in the base charset
Do you have emoji support enabled?

 

[Wolf Knight]

I think the problem is in the base charset
Do you have emoji support enabled?

notwonderfulmore details please, from where I can check that?

 

[Fenrir]

That what I want to do it

Wolf KnightYou can do it in your phpMyAdmin. https://stackoverflow.com/questions/51901178/how-to-change-the-collation-of-an-existing-mysql-database

 

[Wolf Knight]

You can do it in your phpMyAdmin. https://stackoverflow.com/questions/51901178/how-to-change-the-collation-of-an-existing-mysql-database

notwonderfulDone.
I hope that will solve the problem.
Thank you very much for your kind assistance.

 

[Wolf Knight]

You can do it in your phpMyAdmin. https://stackoverflow.com/questions/51901178/how-to-change-the-collation-of-an-existing-mysql-database

notwonderfulStill receiving the same error

 

[Fenrir]

Still receiving the same error

Wolf KnightHello. Then we need to look at this problem in more detail.

 

[Wolf Knight]

Hello. Then we need to look at this problem in more detail.

notwonderfulOne more detail is that I moved my site from one host to another and this error is shown in the new host.

 

[Fenrir]

One more detail is that I moved my site from one host to another and this error is shown in the new host.

Wolf KnightCheck the charset of your database again, it may have changed after the move. Especially if the version is different

 

[thomsa]

to use commaand

php cmd.php xf:convert-utf8mb4

with ssh.

 

[Fenrir]

to use commaand

php cmd.php xf:convert-utf8mb4

with ssh.

thomsaI already told him about it. Apparently, after moving to another hosting, he needs to repeat this.

 

[Wolf Knight]

I already told him about it. Apparently, after moving to another hosting, he needs to repeat this.

notwonderfulI did as you told me and changed it to utf8mb4_general_ci
but still receiving the same error.

 

[BattleKing]

I did as you told me and changed it to utf8mb4_general_ci
but still receiving the same error.

Wolf Knightdid you add $config['fullUnicode'] = true; to your src/config.php file as mentioned before

 

[Wolf Knight]

did you add $config['fullUnicode'] = true; to your src/config.php file as mentioned before

BattleKingSure, I did.

 

[BattleKing]

Sure, I did.

Wolf Knightsorry to ask again what is the collation of xf_unfurl_result table

 

[Wolf Knight]

sorry to ask again what is the collation of xf_unfurl_result table

BattleKingsorry brother, no idea about this.
could you give more details?

 

[Wolf Knight]

sorry to ask again what is the collation of xf_unfurl_result table

BattleKing3.9 MB - 6405

 

[BattleKing]

3.9 MB - 6405

View attachment 27060

Wolf Knightlooks good. Did you checked the error message carefully, is it really the same or does it refer to a different table

 

[Wolf Knight]

looks good. Did you checked the error message carefully, is it really the same or does it refer to a different table

BattleKing

 

[thomsa]

not use phpmyadmin.

https://xenforo.com/community/threads/set-db-to-utf8mb4-without-ssh-deleted.163037/post-1338089

 

[BattleKing]

The (confusingly named) MySQL utf8 charset only provides support for the basic character plane (out of 17 in total), which constitutes 6% of possible characters. As of MySQL 5.5.3 (2010), the utf8mb4 charset provides full UTF-8 support, being completely backwards compatible, not requiring more space than utf8 for characters that are in the utf8 set, and using extra byte for characters outside of the utf8 set.The (confusingly named) MySQL utf8 charset only provides support for the basic character plane (out of 17 in total), which constitutes 6% of possible characters. As of MySQL 5.5.3 (2010), the utf8mb4 charset provides full UTF-8 support, being completely backwards compatible, not requiring more space than utf8 for characters that are in the utf8 set, and using extra byte for characters outside of the utf8 set.

With the current partial UTF-8 support we lack the 16 other character planes. This would include:

• Emojis!
• Mathematical/scientific symbols
• Some Chinese, Japanese and Korean signs
• Musical notation
• Obscure/ancient languages
• Emoticons, astral symbols, game symbols and other pictographic sets
• (User defined) Font icons (these normally use reserved planes)

See also:

• Wikipedia
• http://mzsanford.wordpress.com/2010/12/28/mysql-and-unicode/
• http://mathiasbynens.be/notes/mysql-utf8mb4

https://stackoverflow.com/questions/766809/whats-the-difference-between-utf8-general-ci-and-utf8-unicode-ci/766996#766996

utf-8 can store only 1, 2 or 3 bytes characters, while utf8mb4 can store 4 bytes characters as well. utf-8 is a subset of characters given by utf8mb4

 

[Wolf Knight]

Unfortunately, I am Still receiving the same error.