fix "group by" queries when sql_mode is `only_full_group_by`

Project60 / org.project60.sepa

SEPA direct debit integration with civicrm

19 stars 46 forks source link

fix "group by" queries when sql_mode is `only_full_group_by` #633

Closed masetto closed 1 year ago

masetto commented 2 years ago

I try to fix sql_mode=only_full_group_by incompatibility.

Where I was quite sure, I added the missing columns in the 'group by'. Other times I wrapped the query CRM_Utils_SQL::disableFullGroupByMode() directives as suggested by @bjendres.

See this issue: SEPA Mandates: this is incompatible with sql_mode=only_full_group_by.

bjendres commented 1 year ago

Thanks @eptbertram

bjendres commented 1 year ago

Sorry, thanks @masetto !!