chad1964 2 Posted December 14, 2020 Report Share Posted December 14, 2020 Below is the errors Stack Trace -Note - I still haven't gotten the webtracker to work in the other thread http://community.x2crm.com/topic/4175-getting-error-on-webtracker/When I click on the "Topics" Menu link I get this error -========================================Error 500It 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 ReportHere's a quick list of what will be included in the report:Error Code: 500Error Message: CDbCommand failed to execute the SQL statement: SQLSTATE[42000]: Syntax error or access violation: 1055 Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'flhomesa_crm.t.id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_byStack Trace: [click to toggle display]CDbException in /home/flhomesandcondos/public_html/crm/framework/db/CDbCommand.php(543)#0 /home/flhomesandcondos/public_html/crm/framework/db/CDbCommand.php(433): CDbCommand->queryInternal('fetchColumn', 0, Array)#1 /home/flhomesandcondos/public_html/crm/framework/db/ar/CActiveFinder.php(747): CDbCommand->queryScalar()#2 /home/flhomesandcondos/public_html/crm/framework/db/ar/CActiveFinder.php(151): CJoinElement->count(Object(CDbCriteria))#3 /home/flhomesandcondos/public_html/crm/framework/db/ar/CActiveRecord.php(1613): CActiveFinder->count(Object(CDbCriteria))#4 /home/flhomesandcondos/public_html/crm/framework/web/CActiveDataProvider.php(228): CActiveRecord->count(Object(CDbCriteria))#5 /home/flhomesandcondos/public_html/crm/framework/web/CDataProvider.php(224): CActiveDataProvider->calculateTotalItemCount()#6 /home/flhomesandcondos/public_html/crm/framework/web/CActiveDataProvider.php(178): CDataProvider->getTotalItemCount()#7 /home/flhomesandcondos/public_html/crm/framework/web/CDataProvider.php(168): CActiveDataProvider->fetchData()#8 /home/flhomesandcondos/public_html/crm/framework/zii/widgets/CBaseListView.php(125): CDataProvider->getData()#9 /home/flhomesandcondos/public_html/crm/framework/zii/widgets/CListView.php(211): CBaseListView->init()#10 /home/flhomesandcondos/public_html/crm/framework/web/CBaseController.php(147): CListView->init()#11 /home/flhomesandcondos/public_html/crm/protected/controllers/x2base.php(836): CBaseController->createWidget('zii.widgets.CLi...', Array)#12 /home/flhomesandcondos/public_html/crm/protected/modules/topics/views/topics/index.php(72): x2base->widget('zii.widgets.CLi...', Array)#13 /home/flhomesandcondos/public_html/crm/framework/web/CBaseController.php(126): require('/home/flhomesan...')#14 /home/flhomesandcondos/public_html/crm/framework/web/CBaseController.php(95): CBaseController->renderInternal('/home/flhomesan...', Array, true)#15 /home/flhomesandcondos/public_html/crm/framework/web/CController.php(872): CBaseController->renderFile('/home/flhomesan...', Array, true)#16 /home/flhomesandcondos/public_html/crm/protected/controllers/x2base.php(736): CController->renderPartial('index', Array, true)#17 /home/flhomesandcondos/public_html/crm/protected/modules/topics/controllers/TopicsController.php(254): x2base->render('index', Array)#18 [internal function]: TopicsController->actionIndex(NULL)#19 /home/flhomesandcondos/public_html/crm/framework/web/actions/CAction.php(109): ReflectionMethod->invokeArgs(Object(TopicsController), Array)#20 /home/flhomesandcondos/public_html/crm/framework/web/actions/CInlineAction.php(47): CAction->runWithParamsInternal(Object(TopicsController), Object(ReflectionMethod), Array)#21 /home/flhomesandcondos/public_html/crm/framework/web/CController.php(308): CInlineAction->runWithParams(Array)#22 /home/flhomesandcondos/public_html/crm/framework/web/filters/CFilterChain.php(134): CController->runAction(Object(CInlineAction))#23 /home/flhomesandcondos/public_html/crm/protected/controllers/x2base.php(586): CFilterChain->run()#24 /home/flhomesandcondos/public_html/crm/framework/web/filters/CInlineFilter.php(58): x2base->filterSetPortlets(Object(CFilterChain))#25 /home/flhomesandcondos/public_html/crm/framework/web/filters/CFilterChain.php(131): CInlineFilter->filter(Object(CFilterChain))#26 /home/flhomesandcondos/public_html/crm/framework/web/filters/CFilter.php(40): CFilterChain->run()#27 /home/flhomesandcondos/public_html/crm/framework/web/filters/CFilterChain.php(131): CFilter->filter(Object(CFilterChain))#28 /home/flhomesandcondos/public_html/crm/framework/web/filters/CFilter.php(40): CFilterChain->run()#29 /home/flhomesandcondos/public_html/crm/framework/web/filters/CFilterChain.php(131): CFilter->filter(Object(CFilterChain))#30 /home/flhomesandcondos/public_html/crm/framework/web/CController.php(291): CFilterChain->run()#31 /home/flhomesandcondos/public_html/crm/framework/web/CController.php(265): CController->runActionWithFilters(Object(CInlineAction), Array)#32 /home/flhomesandcondos/public_html/crm/framework/web/CWebApplication.php(282): CController->run('index')#33 /home/flhomesandcondos/public_html/crm/protected/components/X2WebApplication.php(65): CWebApplication->runController('topics/topics/i...')#34 /home/flhomesandcondos/public_html/crm/framework/base/CApplication.php(185): X2WebApplication->processRequest()#35 /home/flhomesandcondos/public_html/crm/index.php(67): CApplication->run()#36 {main}X2Engine Version: 8.0PHP Version: 7.1.33 Quote Link to post Share on other sites
jack 7 Posted December 15, 2020 Report Share Posted December 15, 2020 Hi Chad1964,I think the series of errors you are posting about all steam from the set up of your mysql data base. Can you try using the command "set global sql_mode='';" and see if that fixes your issue and if that does not work try "set sql_mode=''" -Jack Quote Link to post Share on other sites
chad1964 2 Posted December 16, 2020 Author Report Share Posted December 16, 2020 Opened my.cnf file on the server and added the lineset sql_mode=''"That solved this problem. 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.