General error: 3995 Character set 'utf8_general_ci' cannot be used in conjunction with 'binary' in call to regexp_like

[Gamer 0]

Hello!

A freshly installed X2CRM community edition and I got that right off the bat. A bit frustrating, I admit. The error appears when one goes to All actions or All my actions page. How do I fix that? Thanks.

 It looks like the application ran into an unexpected error.

We apologize for the inconvenience and would like to do our best to fix this issue. If you would like to make a post on our forums we can actively interact with you in getting this resolved. If not, simply sending the error report helps us immensely and will only improve the quality of the software. Thanks!
Send Error Report
Here's a quick list of what will be included in the report:

Error Code: 500
Error Message: CDbCommand failed to execute the SQL statement: SQLSTATE[HY000]: General error: 3995 Character set 'utf8_general_ci' cannot be used in conjunction with 'binary' in call to regexp_like.
Stack Trace: [click to toggle display]
CDbException in /var/www/html/X2CRM-master/x2engine/framework/db/CDbCommand.php(543)
#0 /var/www/html/X2CRM-master/x2engine/framework/db/CDbCommand.php(433): CDbCommand->queryInternal('fetchColumn', 0, Array)
#1 /var/www/html/X2CRM-master/x2engine/framework/db/ar/CActiveRecord.php(1609): CDbCommand->queryScalar()
#2 /var/www/html/X2CRM-master/x2engine/framework/web/CActiveDataProvider.php(228): CActiveRecord->count(Object(CDbCriteria))
#3 /var/www/html/X2CRM-master/x2engine/framework/web/CDataProvider.php(224): CActiveDataProvider->calculateTotalItemCount()
#4 /var/www/html/X2CRM-master/x2engine/framework/web/CActiveDataProvider.php(178): CDataProvider->getTotalItemCount()
#5 /var/www/html/X2CRM-master/x2engine/framework/web/CDataProvider.php(168): CActiveDataProvider->fetchData()
#6 /var/www/html/X2CRM-master/x2engine/framework/zii/widgets/CBaseListView.php(125): CDataProvider->getData()
#7 /var/www/html/X2CRM-master/x2engine/framework/zii/widgets/CListView.php(211): CBaseListView->init()
#8 /var/www/html/X2CRM-master/x2engine/framework/web/CBaseController.php(147): CListView->init()
#9 /var/www/html/X2CRM-master/x2engine/protected/controllers/x2base.php(830): CBaseController->createWidget('zii.widgets.CLi...', Array)
#10 /var/www/html/X2CRM-master/x2engine/protected/modules/actions/views/actions/index.php(118): x2base->widget('zii.widgets.CLi...', Array)
#11 /var/www/html/X2CRM-master/x2engine/framework/web/CBaseController.php(126): require('/var/www/html/X...')
#12 /var/www/html/X2CRM-master/x2engine/framework/web/CBaseController.php(95): CBaseController->renderInternal('/var/www/html/X...', Array, true)
#13 /var/www/html/X2CRM-master/x2engine/framework/web/CController.php(872): CBaseController->renderFile('/var/www/html/X...', Array, true)
#14 /var/www/html/X2CRM-master/x2engine/protected/controllers/x2base.php(731): CController->renderPartial('index', Array, true)
#15 /var/www/html/X2CRM-master/x2engine/protected/modules/actions/controllers/ActionsController.php(999): x2base->render('index', Array)
#16 /var/www/html/X2CRM-master/x2engine/framework/web/actions/CInlineAction.php(49): ActionsController->actionIndex()
#17 /var/www/html/X2CRM-master/x2engine/framework/web/CController.php(308): CInlineAction->runWithParams(Array)
#18 /var/www/html/X2CRM-master/x2engine/framework/web/filters/CFilterChain.php(134): CController->runAction(Object(CInlineAction))
#19 /var/www/html/X2CRM-master/x2engine/protected/controllers/x2base.php(581): CFilterChain->run()
#20 /var/www/html/X2CRM-master/x2engine/framework/web/filters/CInlineFilter.php(58): x2base->filterSetPortlets(Object(CFilterChain))
#21 /var/www/html/X2CRM-master/x2engine/framework/web/filters/CFilterChain.php(131): CInlineFilter->filter(Object(CFilterChain))
#22 /var/www/html/X2CRM-master/x2engine/framework/web/filters/CFilter.php(40): CFilterChain->run()
#23 /var/www/html/X2CRM-master/x2engine/framework/web/filters/CFilterChain.php(131): CFilter->filter(Object(CFilterChain))
#24 /var/www/html/X2CRM-master/x2engine/framework/web/filters/CFilter.php(40): CFilterChain->run()
#25 /var/www/html/X2CRM-master/x2engine/framework/web/filters/CFilterChain.php(131): CFilter->filter(Object(CFilterChain))
#26 /var/www/html/X2CRM-master/x2engine/framework/web/CController.php(291): CFilterChain->run()
#27 /var/www/html/X2CRM-master/x2engine/framework/web/CController.php(265): CController->runActionWithFilters(Object(CInlineAction), Array)
#28 /var/www/html/X2CRM-master/x2engine/framework/web/CWebApplication.php(282): CController->run('index')
#29 /var/www/html/X2CRM-master/x2engine/protected/components/X2WebApplication.php(65): CWebApplication->runController('actions/actions...')
#30 /var/www/html/X2CRM-master/x2engine/framework/base/CApplication.php(185): X2WebApplication->processRequest()
#31 /var/www/html/X2CRM-master/x2engine/index.php(67): CApplication->run()
#32 {main}
X2Engine Version: 7.1
PHP Version: 7.1.33

 

[X2Peter 42]

Hello Gamer,

 

Which version of MySQL are you using?

[Gamer 0]

Mysql 8.0.

[Dhayalan 0]

Hello I am facing the same issue with X2CRM 5.4.3 , With Mysql 8

[X2Peter 42]

Hello All,

X2CRM does not currently support MySQL 8.0. I recommend using MySQL 5.*. However for this particular issue, copying the attached file to protected/modules/actions/models/Actions.php should fix the error message. 

Actions.php