GX-Entwicklung

SQL ERROR: "Query error: Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'web17_gambio.pc.id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by - Invalid query: SELECT pc.id as group_id, pc.name as internal_name, pct.name as type, COUNT(pcp.product_id) as usage_count
FROM product_contents as pc
LEFT JOIN product_content_products as pcp ON pc.id = pcp.product_content_id
JOIN product_content_descriptions as pcd ON pc.id = pcd.product_content_id
JOIN product_content_resources as pcr ON pcd.id = pcr.product_content_description_id
JOIN product_content_types as pct ON pct.id = pcr.product_content_types_id
WHERE language_id = '2'
GROUP BY pcp.product_content_id, type" in /inc/xtc_db_error.inc.php:23 (Details)
#11 File: /inc/xtc_db_error.inc.php:23
#10 File: /vendor/gambio/codeigniter-db/CIDB.php:147
#9 File: /vendor/gambio/codeigniter-db/DB_driver.php:665
#8 File: /vendor/gambio/codeigniter-db/DB_query_builder.php:1342
#7 File: /GXMainComponents/Controllers/HttpView/Admin/ContentManager/ContentManagerProductContentsController.inc.php:577
#6 File: /GXMainComponents/Controllers/HttpView/Admin/ContentManager/ContentManagerProductContentsController.inc.php:92
#5
#4 File: /GXEngine/Services/System/Http/HttpViewController.inc.php:152
#3 File: /GXEngine/Services/System/Http/HttpViewController.inc.php:107
#2 File: /GXEngine/Services/System/Http/HttpDispatcher.inc.php:72
#1 File: /GXEngine/Services/System/Http/HttpService.inc.php:67
#0 File: /admin/admin.php:15
Request: GET /admin/admin.php?do=ContentManagerProductContents