Error when upgrading

[Crazy-Achmet]

I've did another update run from XF 1.5 and i get this error:

XF\Db\Exception: MySQL statement prepare error [3995]: Character set 'binary' cannot be used in conjunction with 'utf8mb4_0900_ai_ci' in call to regexp_like. in src/XF/Db/AbstractStatement.php at line 228

1. XF\Db\AbstractStatement->getException() in src/XF/Db/Mysqli/Statement.php at line 196
2. XF\Db\Mysqli\Statement->getException() in src/XF/Db/Mysqli/Statement.php at line 39
3. XF\Db\Mysqli\Statement->prepare() in src/XF/Db/Mysqli/Statement.php at line 54
4. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
5. XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 170
6. XF\Db\AbstractAdapter->fetchAllColumn() in src/addons/SV/PostFriction/Job/Upgrade/Upgrade2000401Step2.php at line 24
7. SV\PostFriction\Job\Upgrade\Upgrade2000401Step2->getNextIds() in src/XF/Job/AbstractRebuildJob.php at line 30
8. XF\Job\AbstractRebuildJob->run() in src/XF/Job/Manager.php at line 258
9. XF\Job\Manager->runJobInternal() in src/XF/Job/Manager.php at line 200
10. XF\Job\Manager->runJobEntry() in src/XF/Job/Manager.php at line 116
11. XF\Job\Manager->runByIds() in src/XF/Admin/Controller/Tools.php at line 120
12. XF\Admin\Controller\Tools->actionRunJob() in src/XF/Mvc/Dispatcher.php at line 350
13. XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 257
14. XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 113
15. XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 55
16. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2300
17. XF\App->run() in src/XF.php at line 488
18. XF::runApp() in admin.php at line 13

 

[Crazy-Achmet]

Guess it's because of mySQL 8 and this bug? https://xenforo.com/community/threads/mysql-8-0-22-xf_phrase-rlike-compatibility.186800/

XF is already on 2.2.2

 

[Xon]

Fixed for the next version