I am try to add GROUP BY and MAX aggregation function with multiple joins in PDO query but drupal core side getting sql_mode=only_full_group_by error issue with multiple fields group by.
Error:
"GROUP BY clause and contains nonaggregated column 'dbname.field_name' which is not functionally dependent on columns in GROUP BY clause. this is incompatible with sql_mode=only_full_group_by issue."
Closed: works as designed
10.0 ✨
Not all content is available!
It's likely this issue predates Contrib.social: some issue and comment data are missing.
Please note that on MySQL ONLY_FULL_GROUP_BY SQL mode is enabled by default, but on MariaDB is disabled by default.
Today - March 17, 2025: Happy ST. Patricks Day!
Editing the settings.php file as show in #9 Worked great!