Skip to content

Fix mailing report on full_group by mode

Monish Deb requested to merge github/fork/jitendrapurohit/full_group_by_fix into master

Created by: jitendrapurohit

Activity id from civicrm_mandrill_activity table is added to the report in this ext. With full group by mode enabled, it does not appear in the group by clause and results in fatal db error on mailing reports. To replicate -

  • go to a mailing report, eg: civicrm/mailing/report?mid=<mailing id>&reset=1
  • Click the 'Report' option for Click-throughs -> Error.

Merge request reports