exec_SELECTquery
caller TYPO3\CMS\Core\Database\DatabaseConnection::exec_SELECTquery
ERROR Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'nexxtep_live_2016.tx_jobmarket_type.uid' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
lastBuiltQuery SELECT COUNT( DISTINCT tx_jobmarket_main.uid ) AS 'hits', tx_jobmarket_type.uid AS 'tx_jobmarket_type.uid', tx_jobmarket_type.title AS 'tx_jobmarket_type.title' FROM tx_jobmarket_main
LEFT JOIN tx_jobmarket_main_mm_tx_jobmarket_type AS tx_jobmarket_main_mm_tx_jobmarket_type
ON
(
tx_jobmarket_main.uid = tx_jobmarket_main_mm_tx_jobmarket_type.uid_local

)
LEFT JOIN tx_jobmarket_type
ON
(
tx_jobmarket_main_mm_tx_jobmarket_type.uid_foreign = tx_jobmarket_type.uid
AND tx_jobmarket_type.deleted=0 AND tx_jobmarket_type.hidden=0
AND tx_jobmarket_type.pid IN (317)
)
LEFT JOIN tx_jobmarket_main_mm_tx_jobmarket_sector AS tx_jobmarket_main_mm_tx_jobmarket_sector
ON
(
tx_jobmarket_main.uid = tx_jobmarket_main_mm_tx_jobmarket_sector.uid_local

)
LEFT JOIN tx_jobmarket_sector
ON
(
tx_jobmarket_main_mm_tx_jobmarket_sector.uid_foreign = tx_jobmarket_sector.uid
AND tx_jobmarket_sector.deleted=0 AND tx_jobmarket_sector.hidden=0
AND tx_jobmarket_sector.pid IN (317)
)
LEFT JOIN tx_jobmarket_main_mm_tx_jobmarket_sectorgroup AS tx_jobmarket_main_mm_tx_jobmarket_sectorgroup
ON
(
tx_jobmarket_main.uid = tx_jobmarket_main_mm_tx_jobmarket_sectorgroup.uid_local

)
LEFT JOIN tx_jobmarket_sectorgroup
ON
(
tx_jobmarket_main_mm_tx_jobmarket_sectorgroup.uid_foreign = tx_jobmarket_sectorgroup.uid
AND tx_jobmarket_sectorgroup.deleted=0 AND tx_jobmarket_sectorgroup.hidden=0
AND tx_jobmarket_sectorgroup.pid IN (317)
)
LEFT JOIN tx_jobmarket_main_mm_tx_jobmarket_region AS tx_jobmarket_main_mm_tx_jobmarket_region
ON
(
tx_jobmarket_main.uid = tx_jobmarket_main_mm_tx_jobmarket_region.uid_local

)
LEFT JOIN tx_jobmarket_region
ON
(
tx_jobmarket_main_mm_tx_jobmarket_region.uid_foreign = tx_jobmarket_region.uid
AND tx_jobmarket_region.deleted=0 AND tx_jobmarket_region.hidden=0
AND tx_jobmarket_region.pid IN (317)
)
LEFT JOIN tx_jobmarket_main_mm_tx_jobmarket_contractor AS tx_jobmarket_main_mm_tx_jobmarket_contractor
ON
(
tx_jobmarket_main.uid = tx_jobmarket_main_mm_tx_jobmarket_contractor.uid_local

)
LEFT JOIN tx_jobmarket_contractor
ON
(
tx_jobmarket_main_mm_tx_jobmarket_contractor.uid_foreign = tx_jobmarket_contractor.uid
AND tx_jobmarket_contractor.deleted=0 AND tx_jobmarket_contractor.hidden=0
AND tx_jobmarket_contractor.pid IN (317)
) WHERE tx_jobmarket_main.deleted=0 AND tx_jobmarket_main.hidden=0 AND tx_jobmarket_main.starttime<=1670417640 AND (tx_jobmarket_main.endtime=0 OR tx_jobmarket_main.endtime>1670417640) AND tx_jobmarket_main.pid IN (317) AND tx_jobmarket_main.sys_language_uid <= 0 GROUP BY tx_jobmarket_type.title ORDER BY tx_jobmarket_type.title ASC
debug_backtrace require(3-6.2-core-patches-TYPO3_6-2-25-patched/typo3/sysext/cms/tslib/index_ts.php),3-6.2-core-patches-TYPO3_6-2-25-patched/index.php#27 // TYPO3\CMS\Frontend\Controller\TypoScriptFrontendController->INTincScript#232 // TYPO3\CMS\Frontend\Controller\TypoScriptFrontendController->recursivelyReplaceIntPlaceholdersInContent#3645 // TYPO3\CMS\Frontend\Controller\TypoScriptFrontendController->INTincScript_process#3678 // TYPO3\CMS\Frontend\ContentObject\ContentObjectRenderer->USER#3730 // TYPO3\CMS\Frontend\ContentObject\UserContentObject->render#862 // TYPO3\CMS\Frontend\ContentObject\ContentObjectRenderer->callUserFunction#41 // call_user_func_array#6665 // tx_browser_pi1->main# // tx_browser_pi1_viewlist->main#772 // tx_browser_pi1_viewlist->content_setDefault#219 // tx_browser_pi1_viewlist->subpart_setSearchbox#725 // tx_browser_pi1_viewlist->subpart_setSearchboxFilter#2147 // tx_browser_pi1_filter_4x->get#2167 // tx_browser_pi1_filter_4x->get_filter#357 // tx_browser_pi1_filter_4x->get_rows#1812 // tx_browser_pi1_filter_4x->get_rowsWiHits#3070 // tx_browser_pi1_filter_4x->sql_resWiHits#3095 // tx_browser_pi1_sql_functions->exec_SELECTquery#3461 // TYPO3\CMS\Core\Database\DatabaseConnection->exec_SELECTquery#779 // TYPO3\CMS\Core\Database\DatabaseConnection->debug#308
Offene Stellen - nexxtep

SQL Error

The SQL query has an error. Please use the DRS - the Development Reporting System. The DRS will display the query and the error. Enabling the DRS: Modul/Admin Tools/Ext Manager -> Extension Browser -> Enable DRS.