Jump to content
X2Community Forums

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


Recommended Posts

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

 

Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
×
×
  • Create New...