XF 2.1 MySQL statement prepare error [3995]

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

  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 155
  6. XF\Db\AbstractAdapter->fetchAll() in src/XF/Install/Upgrade/2000010-200a.php at line 1185
  7. XF\Install\Upgrade\Version2000010->step24() in src/XF/Install/Controller/Upgrade.php at line 173
  8. XF\Install\Controller\Upgrade->actionRun() in src/XF/Mvc/Dispatcher.php at line 350
  9. XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 261
  10. XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 113
  11. XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 55
  12. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2191
  13. XF\App->run() in src/XF.php at line 391
  14. XF::runApp() in install/index.php at line 14
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?
Top Bottom