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

Gamer

By Gamer,
in Bug Reports

 Share Followers 0

Recommended Posts

Gamer

Gamer 0

Posted
Posted

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
  • 1 year later...
Craig

Craig 0

Posted
Posted
On 4/3/2022 at 1:24 AM, Craig said:

Hi. I have the same issue. I added the Actions.php file to the location specified but it does not fix the issue.

Craig

Here is the stack trace...

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 /home/ozpharmc/public_html/seniorstechsupport.com.au/x2/framework/db/CDbCommand.php(543)
#0 /home/ozpharmc/public_html/seniorstechsupport.com.au/x2/framework/db/CDbCommand.php(433): CDbCommand->queryInternal('fetchColumn', 0, Array)
#1 /home/ozpharmc/public_html/seniorstechsupport.com.au/x2/framework/db/ar/CActiveRecord.php(1609): CDbCommand->queryScalar()
#2 /home/ozpharmc/public_html/seniorstechsupport.com.au/x2/framework/web/CActiveDataProvider.php(228): CActiveRecord->count(Object(CDbCriteria))
#3 /home/ozpharmc/public_html/seniorstechsupport.com.au/x2/framework/web/CDataProvider.php(224): CActiveDataProvider->calculateTotalItemCount()
#4 /home/ozpharmc/public_html/seniorstechsupport.com.au/x2/framework/web/CActiveDataProvider.php(178): CDataProvider->getTotalItemCount()
#5 /home/ozpharmc/public_html/seniorstechsupport.com.au/x2/framework/web/CDataProvider.php(168): CActiveDataProvider->fetchData()
#6 /home/ozpharmc/public_html/seniorstechsupport.com.au/x2/framework/zii/widgets/CBaseListView.php(125): CDataProvider->getData()
#7 /home/ozpharmc/public_html/seniorstechsupport.com.au/x2/framework/zii/widgets/CListView.php(211): CBaseListView->init()
#8 /home/ozpharmc/public_html/seniorstechsupport.com.au/x2/framework/web/CBaseController.php(147): CListView->init()
#9 /home/ozpharmc/public_html/seniorstechsupport.com.au/x2/protected/controllers/x2base.php(836): CBaseController->createWidget('zii.widgets.CLi...', Array)
#10 /home/ozpharmc/public_html/seniorstechsupport.com.au/x2/protected/modules/actions/views/actions/index.php(119): x2base->widget('zii.widgets.CLi...', Array)
#11 /home/ozpharmc/public_html/seniorstechsupport.com.au/x2/framework/web/CBaseController.php(126): require('/home/ozpharmc/...')
#12 /home/ozpharmc/public_html/seniorstechsupport.com.au/x2/framework/web/CBaseController.php(95): CBaseController->renderInternal('/home/ozpharmc/...', Array, true)
#13 /home/ozpharmc/public_html/seniorstechsupport.com.au/x2/framework/web/CController.php(872): CBaseController->renderFile('/home/ozpharmc/...', Array, true)
#14 /home/ozpharmc/public_html/seniorstechsupport.com.au/x2/protected/controllers/x2base.php(736): CController->renderPartial('index', Array, true)
#15 /home/ozpharmc/public_html/seniorstechsupport.com.au/x2/protected/modules/actions/controllers/ActionsController.php(1112): x2base->render('index', Array)
#16 /home/ozpharmc/public_html/seniorstechsupport.com.au/x2/framework/web/actions/CInlineAction.php(49): ActionsController->actionIndex()
#17 /home/ozpharmc/public_html/seniorstechsupport.com.au/x2/framework/web/CController.php(308): CInlineAction->runWithParams(Array)
#18 /home/ozpharmc/public_html/seniorstechsupport.com.au/x2/framework/web/filters/CFilterChain.php(134): CController->runAction(Object(CInlineAction))
#19 /home/ozpharmc/public_html/seniorstechsupport.com.au/x2/protected/controllers/x2base.php(586): CFilterChain->run()
#20 /home/ozpharmc/public_html/seniorstechsupport.com.au/x2/framework/web/filters/CInlineFilter.php(58): x2base->filterSetPortlets(Object(CFilterChain))
#21 /home/ozpharmc/public_html/seniorstechsupport.com.au/x2/framework/web/filters/CFilterChain.php(131): CInlineFilter->filter(Object(CFilterChain))
#22 /home/ozpharmc/public_html/seniorstechsupport.com.au/x2/framework/web/filters/CFilter.php(40): CFilterChain->run()
#23 /home/ozpharmc/public_html/seniorstechsupport.com.au/x2/framework/web/filters/CFilterChain.php(131): CFilter->filter(Object(CFilterChain))
#24 /home/ozpharmc/public_html/seniorstechsupport.com.au/x2/framework/web/filters/CFilter.php(40): CFilterChain->run()
#25 /home/ozpharmc/public_html/seniorstechsupport.com.au/x2/framework/web/filters/CFilterChain.php(131): CFilter->filter(Object(CFilterChain))
#26 /home/ozpharmc/public_html/seniorstechsupport.com.au/x2/framework/web/CController.php(291): CFilterChain->run()
#27 /home/ozpharmc/public_html/seniorstechsupport.com.au/x2/framework/web/CController.php(265): CController->runActionWithFilters(Object(CInlineAction), Array)
#28 /home/ozpharmc/public_html/seniorstechsupport.com.au/x2/framework/web/CWebApplication.php(282): CController->run('index')
#29 /home/ozpharmc/public_html/seniorstechsupport.com.au/x2/protected/components/X2WebApplication.php(66): CWebApplication->runController('actions/actions...')
#30 /home/ozpharmc/public_html/seniorstechsupport.com.au/x2/framework/base/CApplication.php(185): X2WebApplication->processRequest()
#31 /home/ozpharmc/public_html/seniorstechsupport.com.au/x2/index.php(68): CApplication->run()
#32 {main}

X2Engine Version: 8.3
PHP Version: 7.3.33
I am using a shared hosting account running MySQL 8.0.28 on Fastcomet.com hosting (recently upgraded from version 5.7) and they cannot roll it back.

 

When will X2CRM be compatible with MySQL 8.x?

Link to post
Share on other sites
  • 1 month later...

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...
×
 Share
Followers 0
Go to topic listing
×
×
  • Create New...