- Issue created by @mahdiwadi
Description: This error will appear after a fresh install of Drupal 10.3.6 and 10.0.11 (without Charts).
Error messages:
Drupal\Core\Database\DatabaseExceptionWrapper: SQLSTATE[42000]: Syntax error or access violation: 1055 Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'thci.r.id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by: SELECT COUNT(*) AS "expression" FROM (SELECT "r"."id" AS "id", "r"."title" AS "title", "r"."views" AS "views", "r"."nid" AS "nid", SUM(r.views) AS "total_views", 1 AS "expression" FROM "content_reporting_reports" "r" GROUP BY "r"."nid", "r"."uid") "subquery"; Array ( ) in Drupal\content_reporting\Controller\ContentReportingController->getReport() (line 230 of modules/contrib/content_reporting/src/Controller/ContentReportingController.php).
Active
1.1
Code