XF 2.1 error by using emoji

[gouwepeer.nl]

I've got this error on my forum after using the "bat" emoji :

XF\Db\Exception: MySQL query error [1366]: Incorrect string value: '\xF0\x9F\xA6\x87' for column 'message' at row 1 in src/XF/Db/AbstractStatement.php at line 217

    XF\Db\AbstractStatement->getException() in src/XF/Db/Mysqli/Statement.php at line 196
    XF\Db\Mysqli\Statement->getException() in src/XF/Db/Mysqli/Statement.php at line 77
    XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
    XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 218
    XF\Db\AbstractAdapter->insert() in src/XF/Mvc/Entity/Entity.php at line 1452
    XF\Mvc\Entity\Entity->_saveToSource() in src/XF/Mvc/Entity/Entity.php at line 1184
    XF\Mvc\Entity\Entity->save() in src/addons/XFMG/Service/Comment/Creator.php at line 121
    XFMG\Service\Comment\Creator->_save() in src/XF/Service/ValidateAndSavableTrait.php at line 40
    XFMG\Service\Comment\Creator->save() in src/addons/XFMG/Pub/Controller/AbstractComment.php at line 226
    XFMG\Pub\Controller\AbstractComment->actionAddComment() in src/XF/Mvc/Dispatcher.php at line 321
    XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 244
    XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 100
    XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 50
    XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2178
    XF\App->run() in src/XF.php at line 390
    XF::runApp() in index.php at line 20

 

[Paul B]

It works here: https://xenforo.com/community/media/dragonfly.2766/#xfmg-comment-1006

Did you run the conversion script?

If you did, try running it again as one or more tables may have failed to convert: https://xenforo.com/xf2-docs/manual/unicode/