Activity Summary civireport gives fatal error when grouping activity date by quarter
Not working since at least 5.20. Haven't checked farther back.
INSERT INTO civicrm_tmp_e_dflt_c96bd73d5a616c0a85f8b776fdaf8a13 ( civicrm_contact_id,civicrm_activity_activity_date_time_start,civicrm_activity_activity_date_time_interval,civicrm_activity_activity_date_time_subtotal,civicrm_activity_activity_type_id,civicrm_activity_duration,civicrm_activity_id_count )
SELECT SQL_CALC_FOUND_ROWS contact_civireport.id as civicrm_contact_id, STR_TO_DATE(CONCAT( 3 * QUARTER( activity_civireport.activity_date_time ) -2 , '/', '1', '/', YEAR( activity_civireport.activity_date_time ) ), '%m/%d/%Y') AS civicrm_activity_activity_date_time_start, QUARTER(activity_civireport.activity_date_time) AS civicrm_activity_activity_date_time_subtotal, QUARTER(activity_civireport.activity_date_time) AS civicrm_activity_activity_date_time_interval, GROUP_CONCAT(DISTINCT activity_civireport.activity_type_id ORDER BY activity_civireport.activity_type_id ) as civicrm_activity_activity_type_id, activity_civireport.duration as civicrm_activity_duration, COUNT(DISTINCT(activity_civireport.id)) as civicrm_activity_id_count
FROM civicrm_activity activity_civireport
LEFT JOIN civicrm_activity_contact target_activity
ON activity_civireport.id = target_activity.activity_id AND
target_activity.record_type_id = 3
LEFT JOIN civicrm_activity_contact assignment_activity
ON activity_civireport.id = assignment_activity.activity_id AND
assignment_activity.record_type_id = 1
LEFT JOIN civicrm_activity_contact source_activity
ON activity_civireport.id = source_activity.activity_id AND
source_activity.record_type_id = 2
LEFT JOIN civicrm_contact contact_civireport
ON target_activity.contact_id = contact_civireport.id
LEFT JOIN civicrm_contact civicrm_contact_assignee
ON assignment_activity.contact_id = civicrm_contact_assignee.id
LEFT JOIN civicrm_contact civicrm_contact_source
ON source_activity.contact_id = civicrm_contact_source.id
LEFT JOIN civicrm_option_value
ON ( activity_civireport.activity_type_id = civicrm_option_value.value )
LEFT JOIN civicrm_option_group
ON civicrm_option_group.id = civicrm_option_value.option_group_id
LEFT JOIN civicrm_case_activity
ON civicrm_case_activity.activity_id = activity_civireport.id
LEFT JOIN civicrm_case
ON civicrm_case_activity.case_id = civicrm_case.id
LEFT JOIN civicrm_case_contact
ON civicrm_case_contact.case_id = civicrm_case.id WHERE civicrm_option_group.name = "activity_type" AND
activity_civireport.is_test = 0 AND
activity_civireport.is_deleted = 0 AND
activity_civireport.is_current_revision = 1 AND ((`activity_civireport`.`activity_type_id` IS NULL OR (`activity_civireport`.`activity_type_id` IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 53, 33, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 34, 35, 36, 37, 38, 39, 40, 41, 42, 43, 44, 45, 46, 47, 48, 49, 50, 51, 52, 54, 55, 56, 58, 60, 62, 64, 66))) OR civicrm_contact_source.is_deleted=0 OR civicrm_contact_assignee.is_deleted=0) GROUP BY YEAR(activity_civireport.activity_date_time), QUARTER(activity_civireport.activity_date_time), contact_civireport.id, STR_TO_DATE(CONCAT( 3 * QUARTER( activity_civireport.activity_date_time ) -2 , '/', '1', '/', YEAR( activity_civireport.activity_date_time ) ), '%m/%d/%Y'), QUARTER(activity_civireport.activity_date_time), activity_civireport.duration ORDER BY activity_civireport.activity_type_id ASC LIMIT 0, 50 [nativecode=1055 ** Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column 'core16560724hxcivi_syiur.activity_civireport.activity_type_id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by]