XF 2.3 2.3.0 beta 7 error XF\Db\Exception: MySQL query error [1366]: Incorrect string value: '\xF0\x9F\x90\x88.1...

Mr Lucky

Well-known member
I get this when attempting to upgrade to beta 7 (from 2.2.15). All addons disabled still get it.

XF\Db\Exception: MySQL query error [1366]: Incorrect string value: '\xF0\x9F\x90\x88.1...' for column `caf_xf2`.`xf_phrase`.`phrase_text` at row 1 in src/XF/Db/AbstractStatement.php at line 230
XF\Db\AbstractStatement->getException() in src/XF/Db/Mysqli/Statement.php at line 198
XF\Db\Mysqli\Statement->getException() in src/XF/Db/Mysqli/Statement.php at line 78
XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 219
XF\Db\AbstractAdapter->insert() in src/XF/Mvc/Entity/Entity.php at line 1558
XF\Mvc\Entity\Entity->_saveToSource() in src/XF/Mvc/Entity/Entity.php at line 1290
XF\Mvc\Entity\Entity->save() in src/XF/AddOn/DataType/Phrase.php at line 100
XF\AddOn\DataType\Phrase->importAddOnData() in src/XF/Job/AddOnData.php at line 110
XF\Job\AddOnData->run() in src/XF/Job/Atomic.php at line 40
XF\Job\Atomic->run() in src/XF/Job/Manager.php at line 272
XF\Job\Manager->runJobInternal() in src/XF/Job/Manager.php at line 202
XF\Job\Manager->runJobEntry() in src/XF/Job/Manager.php at line 153
XF\Job\Manager->runUnique() in src/XF/Install/Controller/AbstractController.php at line 24
XF\Install\Controller\AbstractController->manualJobRunner() in src/XF/Install/Controller/Upgrade.php at line 267
XF\Install\Controller\Upgrade->actionRunJob() in src/XF/Mvc/Dispatcher.php at line 352
XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 258
XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 115
XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 57
XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2604
XF\App->run() in src/XF.php at line 533
XF::runApp() in install/index.php at line 14
Last edited:
This is this bug:

The easiest workaround is to convert your database tables to support utf8mb4.

(This is what enables emoji support).
In this case that database was already converted (as a backup pf the live database which is converted = utf8mb4_general_ci), however the directory for test install did not have $config['fullUnicode'] = true;
Top Bottom