XF 2.1 Incorrect string value: \xF0\x9F\x99\x82\x0AW...


Well-known member
I have a rather weird error in one of my forums (running on 2.1.4 - license expired). It´s dying slowly so I haven´t really maintained it the last months and have overseen this error, until a user made me aware, that he can´t save posts and instead runs in "Oops, a server error occured." . Now I´ve gone through the logs and found plenty of errors like this, referring to an incorrect string value. It seems to happen most times, when users try to post via a mobile device - but even this is nsure, since I can´t reproduce the error at all, wether with my account or a standard user account, nor add-ons enabled or disabled.
 XF\Db\Exception: MySQL query error [1366]: Incorrect string value: '\xF0\x9F\x99\x82\x0AW...' for column 'message' at row 1 src/XF/Db/AbstractStatement.php:217

    Generiert von: XXX 03.05.2020 um 17:02


INSERT  INTO `xf_draft` (`user_id`, `draft_key`, `message`, `extra_data`, `draft_id`, `last_update`) VALUES (?, ?, ?, ?, ?, ?)

#0 src/XF/Db/Mysqli/Statement.php(196): XF\Db\AbstractStatement->getException('MySQL query err...', 1366, '22007')
#1 src/XF/Db/Mysqli/Statement.php(77): XF\Db\Mysqli\Statement->getException('MySQL query err...', 1366, '22007')
#2 src/XF/Db/AbstractAdapter.php(94): XF\Db\Mysqli\Statement->execute()
#3 src/XF/Db/AbstractAdapter.php(218): XF\Db\AbstractAdapter->query('INSERT  INTO `x...', Array)
#4 src/XF/Mvc/Entity/Entity.php(1452): XF\Db\AbstractAdapter->insert('xf_draft', Array, false)
#5 src/XF/Mvc/Entity/Entity.php(1184): XF\Mvc\Entity\Entity->_saveToSource()
#6 src/XF/Draft.php(44): XF\Mvc\Entity\Entity->save()
#7 src/XF/ControllerPlugin/Draft.php(29): XF\Draft->save()
#8 src/XF/Pub/Controller/Thread.php(275): XF\ControllerPlugin\Draft->updateMessageDraft(Object(XF\Draft), Array)
#9 src/XF/Mvc/Dispatcher.php(321): XF\Pub\Controller\Thread->actionDraft(Object(XF\Mvc\ParameterBag))
#10 src/XF/Mvc/Dispatcher.php(244): XF\Mvc\Dispatcher->dispatchClass('XF:Thread', 'Draft', Object(XF\Mvc\RouteMatch), Object(Snog\Forms\XF\Pub\Controller\Thread), NULL)
#11 src/XF/Mvc/Dispatcher.php(100): XF\Mvc\Dispatcher->dispatchFromMatch(Object(XF\Mvc\RouteMatch), Object(Snog\Forms\XF\Pub\Controller\Thread), NULL)
#12 src/XF/Mvc/Dispatcher.php(50): XF\Mvc\Dispatcher->dispatchLoop(Object(XF\Mvc\RouteMatch))
#13 src/XF/App.php(2178): XF\Mvc\Dispatcher->run()
#14 src/XF.php(390): XF\App->run()
#15 index.php(20): XF::runApp('XF\\Pub\\App')
#16 {main}
Someone around who already come across this type of error before and could tell me, what this may be is caused by? Any hint or help would be highly appreciated.


XenForo moderator
Staff member
5.6 is the minimum version required for 2.1.

You wouldn't have been able to install or upgrade with 5.5, so presumably it was changed afterwards.