Jump to content
X2Community Forums

Getting 500 error for "Topics"


Recommended Posts

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
Link to post
Share on other sites

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

Link to post
Share on other sites

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...
×
×
  • Create New...