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]

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

 

[Mr Lucky]

Ah, just seen there was a bug report
.

EDIT: no that seems to be a different error

 

[duderuud]

No expert here but "caf_xf2" seems to come from an add-on.

 

[Mr Lucky]

No expert here but "caf_xf2" seems to come from an add-on.

No, all addons are disabled - it's the name of the database

 

[Digital Doctor]

No, all addons are disabled - it's the name of the database

I'm even less of an expert but....

the error is happening on the exact same LINE of code as yours.


src/XF/Db/AbstractStatement.php at line 230

 

[Mr Lucky]

Ah, just seen there was a bug report
.

EDIT: no that seems to be a different error

Just tried again and the fix for that error seems to have worked this time.

 

[Chris D]

This is this bug:

Fixed Thread 'XF\Db\Exception: MySQL query error [1366]: Incorrect string value:'

May 18, 2024

XF\Db\Exception: MySQL query error [1366]: Incorrect string value: '\xF0\x9F\x90\x88.1...' for column my_xenforo.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...

• craigForo

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

(This is what enables emoji support).

 

[Mr Lucky]

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;