Vereine in und rund um Wien

UNCAUGHT EXCEPTION FOR VIEW: tx_cfcleaguefe_actions_ClubList
CODE: 0
MESSAGE: SQL QUERY IS NOT VALID
Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column 'jufuba2017.tx_cfcleague_club.name' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
SELECT LEFT(UCASE(name),1) As first_char, count(LEFT(UCASE(name),1)) As size FROM tx_cfcleague_club WHERE 1=1 AND tx_cfcleague_club.deleted=0 AND tx_cfcleague_club.hidden=0 GROUP BY LEFT(UCASE(name),1) ORDER BY tx_cfcleague_club.name ASC
STACK:
tx_rnbase_util_Exception: SQL QUERY IS NOT VALID<br/><b>Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column 'jufuba2017.tx_cfcleague_club.name' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by</b><br />SELECT LEFT(UCASE(name),1) As first_char, count(LEFT(UCASE(name),1)) As size FROM tx_cfcleague_club WHERE 1=1 AND tx_cfcleague_club.deleted=0 AND tx_cfcleague_club.hidden=0 GROUP BY LEFT(UCASE(name),1) ORDER BY tx_cfcleague_club.name ASC in /var/www/typo3_src/typo3_src-7.6.30/typo3/sysext/core/Classes/Utility/GeneralUtility.php:4575
Stack trace:
#0 /var/www/typo3_src/typo3_src-7.6.30/typo3/sysext/core/Classes/Utility/GeneralUtility.php(4547): TYPO3\CMS\Core\Utility\GeneralUtility::instantiateClass('tx_rnbase_util_...', Array)
#1 /var/www/vhosts/jufuba.at/jufuba2017/typo3conf/ext/rn_base/class.tx_rnbase.php(90): TYPO3\CMS\Core\Utility\GeneralUtility::makeInstance('tx_rnbase_util_...', 'SQL QUERY IS NO...', 0, Array)
#2 /var/www/vhosts/jufuba.at/jufuba2017/typo3conf/ext/rn_base/util/class.tx_rnbase_util_Misc.php(192): tx_rnbase::makeInstance('tx_rnbase_util_...', 'SQL QUERY IS NO...', 0, Array)
#3 /var/www/vhosts/jufuba.at/jufuba2017/typo3conf/ext/rn_base/Classes/Database/Connection.php(724): tx_rnbase_util_Misc::mayday('SQL QUERY IS NO...', 'rn_base')
#4 /var/www/vhosts/jufuba.at/jufuba2017/typo3conf/ext/rn_base/Classes/Database/Connection.php(173): Tx_Rnbase_Database_Connection->watchOutDB(false, Object(TYPO3\CMS\Core\Database\DatabaseConnection))
#5 /var/www/vhosts/jufuba.at/jufuba2017/typo3conf/ext/rn_base/util/class.tx_rnbase_util_SearchBase.php(352): Tx_Rnbase_Database_Connection->doSelect('LEFT(UCASE(name...', Array, Array, false)
#6 /var/www/vhosts/jufuba.at/jufuba2017/typo3conf/ext/cfc_league/services/class.tx_cfcleague_services_Teams.php(230): tx_rnbase_util_SearchBase->search(Array, Array)
#7 /var/www/vhosts/jufuba.at/jufuba2017/typo3conf/ext/cfc_league_fe/actions/class.tx_cfcleaguefe_actions_ClubList.php(132): tx_cfcleague_services_Teams->searchClubs(Array, Array)
#8 /var/www/vhosts/jufuba.at/jufuba2017/typo3conf/ext/cfc_league_fe/actions/class.tx_cfcleaguefe_actions_ClubList.php(91): tx_cfcleaguefe_actions_ClubList->findPagerData(Object(tx_cfcleague_services_Teams), Object(Tx_Rnbase_Configuration_Processor), 'name')
#9 /var/www/vhosts/jufuba.at/jufuba2017/typo3conf/ext/cfc_league_fe/actions/class.tx_cfcleaguefe_actions_ClubList.php(50): tx_cfcleaguefe_actions_ClubList->handleCharBrowser(Object(tx_rnbase_parameters), Object(Tx_Rnbase_Configuration_Processor), Object(ArrayObject), Array, Array)
#10 /var/www/vhosts/jufuba.at/jufuba2017/typo3conf/ext/rn_base/action/class.tx_rnbase_action_BaseIOC.php(87): tx_cfcleaguefe_actions_ClubList->handleRequest(Object(tx_rnbase_parameters), Object(Tx_Rnbase_Configuration_Processor), Object(ArrayObject))
#11 /var/www/vhosts/jufuba.at/jufuba2017/typo3conf/ext/rn_base/class.tx_rnbase_controller.php(254): tx_rnbase_action_BaseIOC->execute(Object(tx_rnbase_parameters), Object(Tx_Rnbase_Configuration_Processor))
#12 /var/www/vhosts/jufuba.at/jufuba2017/typo3conf/ext/rn_base/class.tx_rnbase_controller.php(228): tx_rnbase_controller->doAction('tx_cfcleaguefe_...', Object(tx_rnbase_parameters), Object(Tx_Rnbase_Configuration_Processor))
#13 [internal function]: tx_rnbase_controller->main('', Array)
#14 /var/www/typo3_src/typo3_src-7.6.30/typo3/sysext/frontend/Classes/ContentObject/ContentObjectRenderer.php(7322): call_user_func_array(Array, Array)
#15 /var/www/typo3_src/typo3_src-7.6.30/typo3/sysext/frontend/Classes/ContentObject/UserContentObject.php(40): TYPO3\CMS\Frontend\ContentObject\ContentObjectRenderer->callUserFunction('tx_rnbase_contr...', Array, '')
#16 /var/www/typo3_src/typo3_src-7.6.30/typo3/sysext/frontend/Classes/ContentObject/ContentObjectRenderer.php(943): TYPO3\CMS\Frontend\ContentObject\UserContentObject->render(Array)
#17 /var/www/typo3_src/typo3_src-7.6.30/typo3/sysext/frontend/Classes/ContentObject/ContentObjectRenderer.php(859): TYPO3\CMS\Frontend\ContentObject\ContentObjectRenderer->render(Object(TYPO3\CMS\Frontend\ContentObject\UserContentObject), Array)
#18 /var/www/typo3_src/typo3_src-7.6.30/typo3/sysext/frontend/Classes/ContentObject/ContentObjectRenderer.php(841): TYPO3\CMS\Frontend\ContentObject\ContentObjectRenderer->cObjGetSingle('USER', Array, 'plugin.tx_cfcle...')
#19 /var/www/typo3_src/typo3_src-7.6.30/typo3/sysext/fluid/Classes/ViewHelpers/CObjectViewHelper.php(119): TYPO3\CMS\Frontend\ContentObject\ContentObjectRenderer->cObjGetSingle('USER', Array)
#20 [internal function]: TYPO3\CMS\Fluid\ViewHelpers\CObjectViewHelper->render('tt_content.list...', Array, NULL, '')
#21 /var/www/typo3_src/typo3_src-7.6.30/typo3/sysext/fluid/Classes/Core/ViewHelper/AbstractViewHelper.php(268): call_user_func_array(Array, Array)
#22 /var/www/typo3_src/typo3_src-7.6.30/typo3/sysext/fluid/Classes/Core/ViewHelper/AbstractViewHelper.php(249): TYPO3\CMS\Fluid\Core\ViewHelper\AbstractViewHelper->callRenderMethod()
#23 /var/www/vhosts/jufuba.at/jufuba2017/typo3temp/Cache/Code/fluid_template/Standalone_template_file_List_0a92cb74f91117c9b9227b1c58efd3273092ba84.php(47): TYPO3\CMS\Fluid\Core\ViewHelper\AbstractViewHelper->initializeArgumentsAndRender()
#24 /var/www/typo3_src/typo3_src-7.6.30/typo3/sysext/fluid/Classes/View/AbstractTemplateView.php(230): FluidCache_Standalone_template_file_List_0a92cb74f91117c9b9227b1c58efd3273092ba84->section_040f06fd774092478d450774f5ba30c5da78acc8(Object(TYPO3\CMS\Fluid\Core\Rendering\RenderingContext))
#25 /var/www/typo3_src/typo3_src-7.6.30/typo3/sysext/fluid/Classes/ViewHelpers/RenderViewHelper.php(121): TYPO3\CMS\Fluid\View\AbstractTemplateView->renderSection('content', Array, false)
#26 /var/www/vhosts/jufuba.at/jufuba2017/typo3temp/Cache/Code/fluid_template/Standalone_layout_HeaderContentFooter_0fb6cdf0c2e827321bd6c93ae8c9702503a503f1.php(194): TYPO3\CMS\Fluid\ViewHelpers\RenderViewHelper::renderStatic(Array, Object(Closure), Object(TYPO3\CMS\Fluid\Core\Rendering\RenderingContext))
#27 /var/www/typo3_src/typo3_src-7.6.30/typo3/sysext/fluid/Classes/View/AbstractTemplateView.php(189): FluidCache_Standalone_layout_HeaderContentFooter_0fb6cdf0c2e827321bd6c93ae8c9702503a503f1->render(Object(TYPO3\CMS\Fluid\Core\Rendering\RenderingContext))
#28 /var/www/typo3_src/typo3_src-7.6.30/typo3/sysext/frontend/Classes/ContentObject/FluidTemplateContentObject.php(300): TYPO3\CMS\Fluid\View\AbstractTemplateView->render()
#29 /var/www/typo3_src/typo3_src-7.6.30/typo3/sysext/frontend/Classes/ContentObject/FluidTemplateContentObject.php(102): TYPO3\CMS\Frontend\ContentObject\FluidTemplateContentObject->renderFluidView()
#30 /var/www/typo3_src/typo3_src-7.6.30/typo3/sysext/frontend/Classes/ContentObject/ContentObjectRenderer.php(943): TYPO3\CMS\Frontend\ContentObject\FluidTemplateContentObject->render(Array)
#31 /var/www/typo3_src/typo3_src-7.6.30/typo3/sysext/frontend/Classes/ContentObject/ContentObjectRenderer.php(859): TYPO3\CMS\Frontend\ContentObject\ContentObjectRenderer->render(Object(TYPO3\CMS\Frontend\ContentObject\FluidTemplateContentObject), Array)
#32 /var/www/typo3_src/typo3_src-7.6.30/typo3/sysext/frontend/Classes/ContentObject/ContentObjectRenderer.php(841): TYPO3\CMS\Frontend\ContentObject\ContentObjectRenderer->cObjGetSingle('FLUIDTEMPLATE', Array, 'lib.fluidConten...')
#33 /var/www/typo3_src/typo3_src-7.6.30/typo3/sysext/frontend/Classes/ContentObject/CaseContentObject.php(44): TYPO3\CMS\Frontend\ContentObject\ContentObjectRenderer->cObjGetSingle('FLUIDTEMPLATE', Array, 'list')
#34 /var/www/typo3_src/typo3_src-7.6.30/typo3/sysext/frontend/Classes/ContentObject/ContentObjectRenderer.php(943): TYPO3\CMS\Frontend\ContentObject\CaseContentObject->render(Array)
#35 /var/www/typo3_src/typo3_src-7.6.30/typo3/sysext/frontend/Classes/ContentObject/ContentObjectRenderer.php(859): TYPO3\CMS\Frontend\ContentObject\ContentObjectRenderer->render(Object(TYPO3\CMS\Frontend\ContentObject\CaseContentObject), Array)
#36 /var/www/typo3_src/typo3_src-7.6.30/typo3/sysext/frontend/Classes/ContentObject/ContentObjectRenderer.php(841): TYPO3\CMS\Frontend\ContentObject\ContentObjectRenderer->cObjGetSingle('CASE', Array, 'tt_content')
#37 /var/www/typo3_src/typo3_src-7.6.30/typo3/sysext/frontend/Classes/ContentObject/ContentContentObject.php(97): TYPO3\CMS\Frontend\ContentObject\ContentObjectRenderer->cObjGetSingle('CASE', Array, '')
#38 /var/www/typo3_src/typo3_src-7.6.30/typo3/sysext/frontend/Classes/ContentObject/ContentObjectRenderer.php(943): TYPO3\CMS\Frontend\ContentObject\ContentContentObject->render(Array)
#39 /var/www/typo3_src/typo3_src-7.6.30/typo3/sysext/frontend/Classes/ContentObject/ContentObjectRenderer.php(859): TYPO3\CMS\Frontend\ContentObject\ContentObjectRenderer->render(Object(TYPO3\CMS\Frontend\ContentObject\ContentContentObject), Array)
#40 /var/www/typo3_src/typo3_src-7.6.30/typo3/sysext/frontend/Classes/ContentObject/FluidTemplateContentObject.php(263): TYPO3\CMS\Frontend\ContentObject\ContentObjectRenderer->cObjGetSingle('CONTENT', Array)
#41 /var/www/typo3_src/typo3_src-7.6.30/typo3/sysext/frontend/Classes/ContentObject/FluidTemplateContentObject.php(97): TYPO3\CMS\Frontend\ContentObject\FluidTemplateContentObject->getContentObjectVariables(Array)
#42 /var/www/typo3_src/typo3_src-7.6.30/typo3/sysext/frontend/Classes/ContentObject/ContentObjectRenderer.php(943): TYPO3\CMS\Frontend\ContentObject\FluidTemplateContentObject->render(Array)
#43 /var/www/typo3_src/typo3_src-7.6.30/typo3/sysext/frontend/Classes/ContentObject/ContentObjectRenderer.php(859): TYPO3\CMS\Frontend\ContentObject\ContentObjectRenderer->render(Object(TYPO3\CMS\Frontend\ContentObject\FluidTemplateContentObject), Array)
#44 /var/www/typo3_src/typo3_src-7.6.30/typo3/sysext/frontend/Classes/ContentObject/ContentObjectRenderer.php(805): TYPO3\CMS\Frontend\ContentObject\ContentObjectRenderer->cObjGetSingle('FLUIDTEMPLATE', Array, '10')
#45 /var/www/typo3_src/typo3_src-7.6.30/typo3/sysext/frontend/Classes/Page/PageGenerator.php(210): TYPO3\CMS\Frontend\ContentObject\ContentObjectRenderer->cObjGet(Array)
#46 /var/www/typo3_src/typo3_src-7.6.30/typo3/sysext/frontend/Classes/Http/RequestHandler.php(216): TYPO3\CMS\Frontend\Page\PageGenerator::renderContent()
#47 /var/www/typo3_src/typo3_src-7.6.30/typo3/sysext/core/Classes/Core/Bootstrap.php(308): TYPO3\CMS\Frontend\Http\RequestHandler->handleRequest(Object(TYPO3\CMS\Core\Http\ServerRequest))
#48 /var/www/typo3_src/typo3_src-7.6.30/typo3/sysext/frontend/Classes/Http/Application.php(78): TYPO3\CMS\Core\Core\Bootstrap->handleRequest(Object(TYPO3\CMS\Core\Http\ServerRequest))
#49 /var/www/typo3_src/typo3_src-7.6.30/index.php(33): TYPO3\CMS\Frontend\Http\Application->run()
#50 /var/www/typo3_src/typo3_src-7.6.30/index.php(34): {closure}()
#51 {main}