• Downloading from our site will require you to have a paid membership. Upgrade to a Premium Membership from 10$ a month today!

    Dont forget read our Rules! Also anyone caught Sharing this content will be banned. By using this site you are agreeing to our rules so read them. Saying I did not know is simply not an excuse! You have been warned.

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


Well-Known Member
Staff member
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
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

Facebook Comments

Similar threads

New posts New threads New resources