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

[Wolf Knight]

Hello dear,
I am facing a problem by receiving this error message Frequently:

XF\Db\Exception: MySQL query error [1366]: Incorrect string value: '\xF0\x9F\x91\x87\xF0\x9F...' for column `********`.`xf_unfurl_result`.`description` at row 1
src/XF/Db/AbstractStatement.php:230

UPDATE `xf_unfurl_result` SET `description` = ?, `image_url` = ?, `last_request_date` = ?, `pending` = ? WHERE `result_id` = 8050

#0 src/XF/Db/Mysqli/Statement.php(198): XF\Db\AbstractStatement->getException('MySQL query err...', 1366, '22007')
#1 src/XF/Db/Mysqli/Statement.php(79): XF\Db\Mysqli\Statement->getException('MySQL query err...', 1366, '22007')
#2 src/XF/Db/AbstractAdapter.php(96): XF\Db\Mysqli\Statement->execute()
#3 src/XF/Db/AbstractAdapter.php(324): XF\Db\AbstractAdapter->query('UPDATE `xf_unf...', Array)
#4 src/XF/Mvc/Entity/Entity.php(1519): XF\Db\AbstractAdapter->update('xf_unfurl_resul...', Array, '`result_id` = 8...')
#5 src/XF/Mvc/Entity/Entity.php(1246): XF\Mvc\Entity\Entity->_saveToSource()
#6 src/XF/Service/Unfurl/Fetcher.php(60): XF\Mvc\Entity\Entity->save()
#7 unfurl.php(71): XF\Service\Unfurl\Fetcher->fetch()
#8 {main}

Could someone expert help me to fix this error?
Thank you.

 

[BattleKing]

Please add some more details what you did in detail. What url did you tried to enter

 

[Wolf Knight]

This error is on my site.
I am receiving this error in my site control panel.

 

[BattleKing]

This error is on my site.
I am receiving this error in my site control panel.

Wolf KnightHow often did you get this message? Are there any more errors or information

Which version of xenforo is it

 

[Wolf Knight]

How often did you get this message? Are there any more errors or information

Which version of xenforo is it

BattleKingonly from two days ago.
this is error is frequently appearing.

 

[BattleKing]

only from two days ago.
this is error is frequently appearing.

Wolf Knighteverytime with the same content.
Which XenForo version is it

 

[Wolf Knight]

everytime with the same content.
Which XenForo version is it

BattleKingThe latest version v2.2.8 Patch 1

 

[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]

more details please, from where I can check that?

Wolf KnightI think you got this error due to the fact that somewhere on your forum there is a link that has emoji in the preview, that's why you got this error.

Add $config['fullUnicode'] = true; to your src/config.php file. Then go to the main page in the admin panel. If your base has the wrong charset, you will see a warning there

 

[BattleKing]

I think you got this error due to the fact that somewhere on your forum there is a link that has emoji in the preview, that's why you got this error.

Add $config['fullUnicode'] = true; to your src/config.php file. Then go to the main page in the admin panel. If your base has the wrong charset, you will see a warning there

notwonderfulYes there is

in the message

 

[Wolf Knight]

I think you got this error due to the fact that somewhere on your forum there is a link that has emoji in the preview, that's why you got this error.

Add $config['fullUnicode'] = true; to your src/config.php file. Then go to the main page in the admin panel. If your base has the wrong charset, you will see a warning there

notwonderfulI did but nothing is shown in the admin panel

 

[Fenrir]

I did but nothing is shown in the admin panel

Wolf KnightThis means everything is fine with your database. Now there should be no errors.

 

[Fenrir]

I did but nothing is shown in the admin panel

Wolf KnightBut to be sure run the conversion script

Log in to your server using SSH, or open a command prompt over Remote Desktop if you are using a Windows server.

When you have a command line available, change your current working directory to your XenForo directory. You will know that you are in the correct directory, as it will contain a script called cmd.php.

You can now run the following command:

php cmd.php xf:convert-utf8mb4

Or just recheck your base charset via phpMyAdmin or something else.

 

[Wolf Knight]

But to be sure run the conversion script

Log in to your server using SSH, or open a command prompt over Remote Desktop if you are using a Windows server.

When you have a command line available, change your current working directory to your XenForo directory. You will know that you are in the correct directory, as it will contain a script called cmd.php.

You can now run the following command:

php cmd.php xf:convert-utf8mb4

Or just recheck your base charset via phpMyAdmin or something else.

notwonderfulI got this error

You should contact the table creator for guidance. Failure to correct this may lead to unexpected behavior.

 

[BattleKing]

I got this error

You should contact the table creator for guidance. Failure to correct this may lead to unexpected behavior.

Wolf KnightWhat is the character set of your DB

 

[Wolf Knight]

What is the character set of your DB

BattleKing

 

[Fenrir]

View attachment 27039

Wolf KnightAll tables should be utf8mb4_general_ci

 

[Wolf Knight]

All tables should be utf8mb4_general_ci

notwonderfulThat what I want to do it

 

[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

 

[BattleKing]

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

notwonderfulgood point I thought as well about the character set, but i did not thought about emoji support