Jump to content


Photo

Error 500 - bei Firmenaufruf

staff response

  • Please log in to reply
3 replies to this topic

#1 Benjamin

Benjamin

    Newbie

  • Members
  • Pip
  • 2 posts

Posted 12 May 2017 - 12:13 PM

Hallo Zusammen, 

 

ich habe mit heute das x2crm in der Version 6.5.2 installiert und eine "Testfirma" als Kontakt angelegt. 

Wenn ich nun die Testfirma aufrufen möchte, in dem ich wie folgt vorgehe: 

 

- Einloggen

- Firmen "klick"

- Testfirma "klick"

 

dann kommt nur Error 500 

 

Leider habe ich keine mir die Firma aufzurufen und somit zu arbeiten. Ist es ein Rechtsproblem oder woran kann es liegen? 

 

 

 

Hier ist eine kurze Liste von dem, was in den Bericht aufgenommen wird:

Error Code: 500
Fehlermeldung: CDbCommand konnte das SQL-Statement nicht ausführen: SQLSTATE[42000]: Syntax error or access violation: 1055 Expression #7 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'x2crm.x2_actions.complete' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

X2Engine Version: 6.5.2
PHP Version: 5.6.30-10+deb.sury.org~xenial+2

 

Und noch die Stapelüberwachung 

 

 

 

Stapelüberwachung:
CDbException in /var/www/html/x2crm/x2engine/protected/components/sortableWidget/SortableWidget.php(941)
#0 /var/www/html/x2crm/x2engine/framework/db/CDbCommand.php(396): CDbCommand->queryInternal('fetchAll', Array, Array)
#1 /var/www/html/x2crm/x2engine/protected/components/sortableWidget/recordViewWidgets/ActionHistoryChartWidget.php(117): CDbCommand->queryAll()
#2 /var/www/html/x2crm/x2engine/protected/components/sortableWidget/recordViewWidgets/ActionHistoryChartWidget.php(298): ActionHistoryChartWidget::getChartData('1494571312', 1494792605, '2', 'Accounts', NULL)
#3 /var/www/html/x2crm/x2engine/protected/components/sortableWidget/recordViewWidgets/ActionHistoryChartWidget.php(135): ActionHistoryChartWidget->getInitialChartData('1494571312', '2', 'Accounts', NULL)
#4 /var/www/html/x2crm/x2engine/framework/base/CComponent.php(111): ActionHistoryChartWidget->getSetupScript()
#5 /var/www/html/x2crm/x2engine/protected/components/sortableWidget/SortableWidget.php(941): CComponent->__get('setupScript')
#6 /var/www/html/x2crm/x2engine/protected/components/sortableWidget/SortableWidget.php(909): SortableWidget->renderWidgetContents()
#7 /var/www/html/x2crm/x2engine/protected/components/sortableWidget/views/recordViewWidget.php(42): SortableWidget->renderWidget()
#8 /var/www/html/x2crm/x2engine/framework/web/CBaseController.php(130): require('/var/www/html/x...')
#9 /var/www/html/x2crm/x2engine/framework/web/CBaseController.php(95): CBaseController->renderInternal('/var/www/html/x...', Array, false)
#10 /var/www/html/x2crm/x2engine/protected/components/X2Widget.php(81): CBaseController->renderFile('/var/www/html/x...', Array, false)
#11 /var/www/html/x2crm/x2engine/framework/web/widgets/CWidget.php(244): X2Widget->renderFile('/var/www/html/x...', Array, false)
#12 /var/www/html/x2crm/x2engine/protected/components/sortableWidget/SortableWidget.php(1055): CWidget->render('application.com...', Array)
#13 /var/www/html/x2crm/x2engine/protected/controllers/x2base.php(828): SortableWidget->run()
#14 /var/www/html/x2crm/x2engine/protected/components/sortableWidget/SortableWidget.php(396): x2base->widget('application.com...', Array)
#15 /var/www/html/x2crm/x2engine/protected/components/sortableWidget/RecordViewWidgetManager.php(126): SortableWidget::instantiateWidget('ActionHistoryCh...', Object(Profile), 'recordView', Array)
#16 /var/www/html/x2crm/x2engine/protected/components/sortableWidget/views/_twoColumnSortableWidgetLayout.php(53): RecordViewWidgetManager->displayWidgets(1)
#17 /var/www/html/x2crm/x2engine/framework/web/CBaseController.php(130): require('/var/www/html/x...')
#18 /var/www/html/x2crm/x2engine/framework/web/CBaseController.php(95): CBaseController->renderInternal('/var/www/html/x...', NULL, false)
#19 /var/www/html/x2crm/x2engine/protected/components/X2Widget.php(81): CBaseController->renderFile('/var/www/html/x...', NULL, false)
#20 /var/www/html/x2crm/x2engine/framework/web/widgets/CWidget.php(244): X2Widget->renderFile('/var/www/html/x...', NULL, false)
#21 /var/www/html/x2crm/x2engine/protected/components/sortableWidget/TwoColumnSortableWidgetManager.php(108): CWidget->render('_twoColumnSorta...')
#22 /var/www/html/x2crm/x2engine/protected/controllers/x2base.php(828): TwoColumnSortableWidgetManager->run()
#23 /var/www/html/x2crm/x2engine/protected/components/X2WidgetList.php(79): x2base->widget('RecordViewWidge...', Array)
#24 /var/www/html/x2crm/x2engine/protected/controllers/x2base.php(828): X2WidgetList->run()
#25 /var/www/html/x2crm/x2engine/protected/modules/accounts/views/accounts/view.php(145): x2base->widget('X2WidgetList', Array)
#26 /var/www/html/x2crm/x2engine/framework/web/CBaseController.php(126): require('/var/www/html/x...')
#27 /var/www/html/x2crm/x2engine/framework/web/CBaseController.php(95): CBaseController->renderInternal('/var/www/html/x...', Array, true)
#28 /var/www/html/x2crm/x2engine/framework/web/CController.php(869): CBaseController->renderFile('/var/www/html/x...', Array, true)
#29 /var/www/html/x2crm/x2engine/protected/controllers/x2base.php(726): CController->renderPartial('view', Array, true)
#30 /var/www/html/x2crm/x2engine/protected/controllers/x2base.php(265): x2base->render('view', Array)
#31 /var/www/html/x2crm/x2engine/protected/modules/accounts/controllers/AccountsController.php(134): x2base->view(Object(Accounts), 'accounts')
#32 [internal function]: AccountsController->actionView('2')
#33 /var/www/html/x2crm/x2engine/framework/web/actions/CAction.php(109): ReflectionMethod->invokeArgs(Object(AccountsController), Array)
#34 /var/www/html/x2crm/x2engine/framework/web/actions/CInlineAction.php(47): CAction->runWithParamsInternal(Object(AccountsController), Object(ReflectionMethod), Array)
#35 /var/www/html/x2crm/x2engine/framework/web/CController.php(308): CInlineAction->runWithParams(Array)
#36 /var/www/html/x2crm/x2engine/framework/web/filters/CFilterChain.php(133): CController->runAction(Object(CInlineAction))
#37 /var/www/html/x2crm/x2engine/protected/controllers/x2base.php(578): CFilterChain->run()
#38 /var/www/html/x2crm/x2engine/framework/web/filters/CInlineFilter.php(58): x2base->filterSetPortlets(Object(CFilterChain))
#39 /var/www/html/x2crm/x2engine/framework/web/filters/CFilterChain.php(130): CInlineFilter->filter(Object(CFilterChain))
#40 /var/www/html/x2crm/x2engine/framework/web/filters/CFilter.php(40): CFilterChain->run()
#41 /var/www/html/x2crm/x2engine/framework/web/filters/CFilterChain.php(130): CFilter->filter(Object(CFilterChain))
#42 /var/www/html/x2crm/x2engine/framework/web/filters/CFilter.php(40): CFilterChain->run()
#43 /var/www/html/x2crm/x2engine/framework/web/filters/CFilterChain.php(130): CFilter->filter(Object(CFilterChain))
#44 /var/www/html/x2crm/x2engine/framework/web/CController.php(291): CFilterChain->run()
#45 /var/www/html/x2crm/x2engine/framework/web/CController.php(265): CController->runActionWithFilters(Object(CInlineAction), Array)
#46 /var/www/html/x2crm/x2engine/framework/web/CWebApplication.php(282): CController->run('view')
#47 /var/www/html/x2crm/x2engine/framework/web/CWebApplication.php(141): CWebApplication->runController('accounts/accoun...')
#48 /var/www/html/x2crm/x2engine/framework/base/CApplication.php(185): CWebApplication->processRequest()
#49 /var/www/html/x2crm/x2engine/index.php(65): CApplication->run()
#50 {main}

 

Was mache ich falsch bzw. wie kann ich das Problem lösen? 

 

Danke Euch!



#2 X2Raymond

X2Raymond

    Advanced Member

  • Administrators
  • 939 posts
  • LocationSanta Cruz, CA

Posted 12 May 2017 - 12:23 PM

Hallo Benjamin,

Dieses Problem wurde bei neueren MySQL-Servern gefunden, bei denen die Defaults jetzt nur_full_group_by setzen. Bitte sehen Sie meine Antwort in einem anderen Thread hier für eine Lösung: http://community.x2c...ors/#entry12910

Hier ist der Link zur Google Translated Version des Beitrags auf Deutsch: https://translate.go...t-text=&act=url

Raymond



#3 Benjamin

Benjamin

    Newbie

  • Members
  • Pip
  • 2 posts

Posted 12 May 2017 - 08:56 PM

Hallo Raymond, 

 

vielen Dank für Deine Antwort, aber in welcher Datei muss ich 

SET GLOBAL sql_mode = (SELECT REPLACE (@@ sql_mode, 'ONLY_FULL_GROUP_BY', '')); 

eingeben bzw. an welcher Stelle muss ich ihn ausführen lassen? 

 

Danke Dir!



#4 X2Raymond

X2Raymond

    Advanced Member

  • Administrators
  • 939 posts
  • LocationSanta Cruz, CA

Posted 15 May 2017 - 10:56 AM

Hallo Benjamin,

Sie möchten diesen Befehl auf Ihrer MySQL-Befehlszeilenschnittstelle oder über ein kompatibles Tool wie PHPMyAdmin ausführen. Sie müssen als Root-Benutzer eine Verbindung herstellen, um die globalen Einstellungen erfolgreich zu ändern.

Raymond







0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users