Fix XF\Db\Exception: MySQL query error [1366]: Incorrect string value: '\xF0\x9F\x93\x8A [...' for column `xf_phrase`.`phrase_text`

[Admin]

Chào các bạn, hôm nay tuoitreit.vn xin hướng dẫn bạn fix lỗi này

Để fix lỗi này bạn làm theo hướng dẫn sau, dán code này vào cuối của config.php

$config['fullUnicode'] = true;

Sau đó chạy lệnh sau

php cmd.php xf:convert-utf8mb4

Vậy là xong rồi đó

Chúc bạn thành công!
Nguồn tuoitreit.vn

 

[Admin]

This tutorial is fix

XF\Db\Exception: MySQL query error [3988]: Conversion from collation utf8mb3_general_ci into utf8mb4_general_ci impossible for parameter in src/XF/Db/AbstractStatement.php at line 230

1. XF\Db\AbstractStatement->getException() in src/XF/Db/Mysqli/Statement.php at line 198
2. XF\Db\Mysqli\Statement->getException() in src/XF/Db/Mysqli/Statement.php at line 78
3. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
4. XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 219
5. XF\Db\AbstractAdapter->insert() in src/XF/Mvc/Entity/Entity.php at line 1558
6. XF\Mvc\Entity\Entity->_saveToSource() in src/XF/Mvc/Entity/Entity.php at line 1290
7. XF\Mvc\Entity\Entity->save() in src/XF/AddOn/DataType/Phrase.php at line 100
8. XF\AddOn\DataType\Phrase->importAddOnData() in src/XF/Job/AddOnData.php at line 110
9. XF\Job\AddOnData->run() in src/XF/Job/Atomic.php at line 40
10. XF\Job\Atomic->run() in src/XF/Job/Manager.php at line 272
11. XF\Job\Manager->runJobInternal() in src/XF/Job/Manager.php at line 202
12. XF\Job\Manager->runJobEntry() in src/XF/Job/Manager.php at line 153
13. XF\Job\Manager->runUnique() in src/XF/Install/Controller/AbstractController.php at line 24
14. XF\Install\Controller\AbstractController->manualJobRunner() in src/XF/Install/Controller/Upgrade.php at line 267
15. XF\Install\Controller\Upgrade->actionRunJob() in src/XF/Mvc/Dispatcher.php at line 352
16. XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 258
17. XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 115
18. XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 57
19. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2604
20. XF\App->run() in src/XF.php at line 533
21. XF::runApp() in install/index.php at line 14