Jump to content


Photo

Error 500 on service ticket update

error 500

  • Please log in to reply
1 reply to this topic

#1 nivsys

nivsys

    Member

  • Members
  • PipPip
  • 11 posts

Posted 23 July 2016 - 07:51 AM

Hi,

 

Getting an error 500 when trying to update a service ticket. Error report is

 

 

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 #7 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'x2engine.x2_actions.complete' 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 /var/www/html/x2engine/protected/components/sortableWidget/SortableWidget.php(941)
#0 /var/www/html/x2engine/framework/db/CDbCommand.php(396): CDbCommand->queryInternal('fetchAll', Array, Array)
#1 /var/www/html/x2engine/protected/components/sortableWidget/recordViewWidgets/ActionHistoryChartWidget.php(117): CDbCommand->queryAll()
#2 /var/www/html/x2engine/protected/components/sortableWidget/recordViewWidgets/ActionHistoryChartWidget.php(297): ActionHistoryChartWidget::getChartData('1468863344', 1469455203, '1000', 'services', NULL)
#3 /var/www/html/x2engine/protected/components/sortableWidget/recordViewWidgets/ActionHistoryChartWidget.php(134): ActionHistoryChartWidget->getInitialChartData('1468863344', '1000', 'Services', NULL)
#4 /var/www/html/x2engine/framework/base/CComponent.php(111): ActionHistoryChartWidget->getSetupScript()
#5 /var/www/html/x2engine/protected/components/sortableWidget/SortableWidget.php(941): CComponent->__get('setupScript')
#6 /var/www/html/x2engine/protected/components/sortableWidget/SortableWidget.php(909): SortableWidget->renderWidgetContents()
#7 /var/www/html/x2engine/protected/components/sortableWidget/views/recordViewWidget.php(42): SortableWidget->renderWidget()
#8 /var/www/html/x2engine/framework/web/CBaseController.php(130): require('/var/www/html/x...')
#9 /var/www/html/x2engine/framework/web/CBaseController.php(95): CBaseController->renderInternal('/var/www/html/x...', Array, false)
#10 /var/www/html/x2engine/protected/components/X2Widget.php(81): CBaseController->renderFile('/var/www/html/x...', Array, false)
#11 /var/www/html/x2engine/framework/web/widgets/CWidget.php(244): X2Widget->renderFile('/var/www/html/x...', Array, false)
#12 /var/www/html/x2engine/protected/components/sortableWidget/SortableWidget.php(1054): CWidget->render('application.com...', Array)
#13 /var/www/html/x2engine/protected/controllers/x2base.php(828): SortableWidget->run()
#14 /var/www/html/x2engine/protected/components/sortableWidget/SortableWidget.php(394): x2base->widget('application.com...', Array)
#15 /var/www/html/x2engine/protected/components/sortableWidget/RecordViewWidgetManager.php(126): SortableWidget::instantiateWidget('ActionHistoryCh...', Object(Profile), 'recordView', Array)
#16 /var/www/html/x2engine/protected/components/sortableWidget/views/_twoColumnSortableWidgetLayout.php(53): RecordViewWidgetManager->displayWidgets(1)
#17 /var/www/html/x2engine/framework/web/CBaseController.php(130): require('/var/www/html/x...')
#18 /var/www/html/x2engine/framework/web/CBaseController.php(95): CBaseController->renderInternal('/var/www/html/x...', NULL, false)
#19 /var/www/html/x2engine/protected/components/X2Widget.php(81): CBaseController->renderFile('/var/www/html/x...', NULL, false)
#20 /var/www/html/x2engine/framework/web/widgets/CWidget.php(244): X2Widget->renderFile('/var/www/html/x...', NULL, false)
#21 /var/www/html/x2engine/protected/components/sortableWidget/TwoColumnSortableWidgetManager.php(108): CWidget->render('_twoColumnSorta...')
#22 /var/www/html/x2engine/protected/controllers/x2base.php(828): TwoColumnSortableWidgetManager->run()
#23 /var/www/html/x2engine/protected/components/X2WidgetList.php(79): x2base->widget('RecordViewWidge...', Array)
#24 /var/www/html/x2engine/protected/controllers/x2base.php(828): X2WidgetList->run()
#25 /var/www/html/x2engine/protected/modules/services/views/services/view.php(191): x2base->widget('X2WidgetList', Array)
#26 /var/www/html/x2engine/framework/web/CBaseController.php(126): require('/var/www/html/x...')
#27 /var/www/html/x2engine/framework/web/CBaseController.php(95): CBaseController->renderInternal('/var/www/html/x...', Array, true)
#28 /var/www/html/x2engine/framework/web/CController.php(869): CBaseController->renderFile('/var/www/html/x...', Array, true)
#29 /var/www/html/x2engine/protected/controllers/x2base.php(726): CController->renderPartial('view', Array, true)
#30 /var/www/html/x2engine/protected/controllers/x2base.php(264): x2base->render('view', Array)
#31 /var/www/html/x2engine/protected/modules/services/controllers/ServicesController.php(120): x2base->view(Object(Services), 'services')
#32 [internal function]: ServicesController->actionView('1000')
#33 /var/www/html/x2engine/framework/web/actions/CAction.php(109): ReflectionMethod->invokeArgs(Object(ServicesController), Array)
#34 /var/www/html/x2engine/framework/web/actions/CInlineAction.php(47): CAction->runWithParamsInternal(Object(ServicesController), Object(ReflectionMethod), Array)
#35 /var/www/html/x2engine/framework/web/CController.php(308): CInlineAction->runWithParams(Array)
#36 /var/www/html/x2engine/framework/web/filters/CFilterChain.php(133): CController->runAction(Object(CInlineAction))
#37 /var/www/html/x2engine/protected/controllers/x2base.php(578): CFilterChain->run()
#38 /var/www/html/x2engine/framework/web/filters/CInlineFilter.php(58): x2base->filterSetPortlets(Object(CFilterChain))
#39 /var/www/html/x2engine/framework/web/filters/CFilterChain.php(130): CInlineFilter->filter(Object(CFilterChain))
#40 /var/www/html/x2engine/framework/web/filters/CFilter.php(40): CFilterChain->run()
#41 /var/www/html/x2engine/framework/web/filters/CFilterChain.php(130): CFilter->filter(Object(CFilterChain))
#42 /var/www/html/x2engine/framework/web/filters/CFilter.php(40): CFilterChain->run()
#43 /var/www/html/x2engine/framework/web/filters/CFilterChain.php(130): CFilter->filter(Object(CFilterChain))
#44 /var/www/html/x2engine/framework/web/CController.php(291): CFilterChain->run()
#45 /var/www/html/x2engine/framework/web/CController.php(265): CController->runActionWithFilters(Object(CInlineAction), Array)
#46 /var/www/html/x2engine/framework/web/CWebApplication.php(282): CController->run('view')
#47 /var/www/html/x2engine/framework/web/CWebApplication.php(141): CWebApplication->runController('services/servic...')
#48 /var/www/html/x2engine/framework/base/CApplication.php(185): CWebApplication->processRequest()
#49 /var/www/html/x2engine/index.php(65): CApplication->run()
#50 {main}

X2Engine Version: 6.0.2
PHP Version: 7.0.8-0ubuntu0.16.04.1



#2 nivsys

nivsys

    Member

  • Members
  • PipPip
  • 11 posts

Posted 27 July 2016 - 06:49 PM

Any ideas?







0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users