XF 2.2 xf_unfurl error

[SatGuyScott]

We moved on to a new server last week and have had no issues since the move until today.

Now we are having a wave of errors showing up and not sure what it means.

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

[HEADING=2]Stack trace[/HEADING]
UPDATE  `xf_unfurl_result` SET `title` = ?, `description` = ?, `image_url` = ?, `favicon_url` = ?, `last_request_date` = ?, `pending` = ? WHERE `result_id` = 135680
------------

#0 src/XF/Db/Mysqli/Statement.php(198): XF\Db\AbstractStatement->getException('MySQL query err...', 1366, '22007')
#1 src/XF/Db/Mysqli/Statement.php(78): 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(323): XF\Db\AbstractAdapter->query('UPDATE  `xf_unf...', Array)
#4 src/XF/Mvc/Entity/Entity.php(1531): XF\Db\AbstractAdapter->update('xf_unfurl_resul...', Array, '`result_id` = 1...')
#5 src/XF/Mvc/Entity/Entity.php(1258): 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}

Any ideas what this means and how to fix?

 

[SatGuyScott]

I found the thread that was causing the issue and deleted it which got rid of the Ooops there may be a problem popups and errors in the admin panel.

 

[SatGuyScott]

Well tried reposting that URL and issue came back.

Did more research and it looks like it is a UTF8 vs UTF8MB4 issue.

So I ran php cmd.php xf:convert-utf8mb4

And it found and converted 84 tables, and links seem to be working again.

Hopefully thats the end of it now.