Getting 500 error for "Topics"

[chad1964 2]

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 500

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[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_by
Stack 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.0
PHP Version: 7.1.33

[jack 7]

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

[chad1964 2]

Opened my.cnf file on the server and added the line

set sql_mode=''"

That solved this problem.