Gamer 0 Posted February 15, 2021 Report Share Posted February 15, 2021 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 Quote Link to post Share on other sites
X2Peter 45 Posted February 15, 2021 Report Share Posted February 15, 2021 Hello Gamer, Which version of MySQL are you using? Quote Link to post Share on other sites
Gamer 0 Posted February 16, 2021 Author Report Share Posted February 16, 2021 Mysql 8.0. Quote Link to post Share on other sites
Dhayalan 0 Posted February 22, 2021 Report Share Posted February 22, 2021 Hello I am facing the same issue with X2CRM 5.4.3 , With Mysql 8 Quote Link to post Share on other sites
X2Peter 45 Posted February 23, 2021 Report Share Posted February 23, 2021 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 Quote Link to post Share on other sites
Craig 0 Posted April 2 Report Share Posted April 2 Hi. I have the same issue. I added the Actions.php file to the location specified but it does not fix the issue. Craig Quote Link to post Share on other sites
alt_f4 57 Posted April 5 Report Share Posted April 5 On 2/22/2021 at 2:05 PM, Dhayalan said: Hello I am facing the same issue with X2CRM 5.4.3 , With Mysql 8 Try updating X2 to 8.3 and MySQL <8.0 Quote Link to post Share on other sites
Craig 0 Posted April 7 Report Share Posted April 7 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: 500Error 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.3PHP Version: 7.3.33I 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? Quote Link to post Share on other sites
X2Peter 45 Posted May 12 Report Share Posted May 12 Hello Craig, We will add compatibility with MySQL 8.0 to our next release, 8.4. We plan on releasing 8.4 in about a month. 1 Quote Link to post Share on other sites
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.