- Affected version
- 2.1.10 pl2
- 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. src/XF/Db/AbstractStatement.php:228
Code:
Stack trace
SELECT change_key, group_ids
FROM xf_user_group_change
WHERE user_id = ?
AND change_key REGEXP '^warning_[0-9]+$'
------------
#0 src/XF/Db/Mysqli/Statement.php(196): XF\Db\AbstractStatement->getException()
#1 src/XF/Db/Mysqli/Statement.php(39): XF\Db\Mysqli\Statement->getException()
#2 src/XF/Db/Mysqli/Statement.php(54): XF\Db\Mysqli\Statement->prepare()
#3 src/XF/Db/AbstractAdapter.php(94): XF\Db\Mysqli\Statement->execute()
#4 src/XF/Db/AbstractAdapter.php(175): XF\Db\AbstractAdapter->query()
#5 src/XF/Service/User/ContentChange.php(384): XF\Db\AbstractAdapter->fetchPairs()
#6 src/XF/MultiPartRunnerTrait.php(48): XF\Service\User\ContentChange->stepApplyWarningGroupChanges()
#7 src/XF/Service/User/ContentChange.php(198): XF\Service\User\ContentChange->runLoop()
#8 src/XF/Service/User/Merge.php(137): XF\Service\User\ContentChange->apply()
#9 src/XF/MultiPartRunnerTrait.php(48): XF\Service\User\Merge->stepReassignContent()
#10 src/XF/Service/User/Merge.php(88): XF\Service\User\Merge->runLoop()
#11 src/XF/Job/UserMerge.php(39): XF\Service\User\Merge->merge()
#12 src/XF/Job/Manager.php(253): XF\Job\UserMerge->run()
#13 src/XF/Job/Manager.php(195): XF\Job\Manager->runJobInternal()
#14 src/XF/Job/Manager.php(79): XF\Job\Manager->runJobEntry()
#15 src/XF/Admin/Controller/Tools.php(139): XF\Job\Manager->runQueue()
#16 src/XF/Mvc/Dispatcher.php(350): XF\Admin\Controller\Tools->actionRunJob()
#17 src/XF/Mvc/Dispatcher.php(257): XF\Mvc\Dispatcher->dispatchClass()
#18 src/XF/Mvc/Dispatcher.php(113): XF\Mvc\Dispatcher->dispatchFromMatch()
#19 src/XF/Mvc/Dispatcher.php(55): XF\Mvc\Dispatcher->dispatchLoop()
#20 src/XF/App.php(2190): XF\Mvc\Dispatcher->run()
#21 src/XF.php(391): XF\App->run()
#22 admin.php(13): XF::runApp()
#23 {main}
