Gamer 0 Posted February 15 Report Share Posted February 15 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 42 Posted February 15 Report Share Posted February 15 Hello Gamer, Which version of MySQL are you using? Quote Link to post Share on other sites
Gamer 0 Posted February 16 Author Report Share Posted February 16 Mysql 8.0. Quote Link to post Share on other sites
Dhayalan 0 Posted Monday at 01:05 PM Report Share Posted Monday at 01:05 PM Hello I am facing the same issue with X2CRM 5.4.3 , With Mysql 8 Quote Link to post Share on other sites
X2Peter 42 Posted Tuesday at 01:02 AM Report Share Posted Tuesday at 01:02 AM 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
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.