XF 2.1 MySQL statement prepare error [3995]

[zargarzone]

hi dears
i want to update my forum but facing this error anybody help me please



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

2. XF\Db\AbstractStatement->getException() in src/XF/Db/Mysqli/Statement.php at line 196
4. XF\Db\Mysqli\Statement->getException() in src/XF/Db/Mysqli/Statement.php at line 39
6. XF\Db\Mysqli\Statement->prepare() in src/XF/Db/Mysqli/Statement.php at line 54
8. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
10. XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 155
12. XF\Db\AbstractAdapter->fetchAll() in src/XF/Install/Upgrade/2000010-200a.php at line 1185
14. XF\Install\Upgrade\Version2000010->step24() in src/XF/Install/Controller/Upgrade.php at line 173
16. XF\Install\Controller\Upgrade->actionRun() in src/XF/Mvc/Dispatcher.php at line 350
18. XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 261
20. XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 113
22. XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 55
24. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2191
26. XF\App->run() in src/XF.php at line 391
28. XF::runApp() in install/index.php at line 14

 

[TPerry]

Looks like you may have an add-on that is not able to be upgraded using the current version?
What XF version are you attempting to upgrade from and to.
Have you confirmed that all those add-ons that you use have an XF 2.x version, and have an upgrade path available to them?