Cannot filter by 'Member Since' in Membership Summary Report
When selecting any date range as a filter in the Membership Summary Report, I get the below error. Have replicated here: https://dmaster.demo.civicrm.org/civicrm/report/member/summary
This may be a quick fix, but I am creating this issue as I don't have time to dig into it now.
Nov 18 12:10:26 [error] $Fatal Error Details = Array
(
[callback] => Array
(
[0] => CRM_Core_Error
[1] => handle
)
[code] => -19
[message] => DB Error: no such field
[mode] => 16
[debug_info] => SELECT SQL_CALC_FOUND_ROWS COUNT( DISTINCT membership_civireport.id ) as civicrm_membership_member_count, membership_civireport.membership_type_id as civicrm_membership_membership_type_id, contribution_civireport.currency as civicrm_contribution_currency, IFNULL(SUM(contribution_civireport.total_amount), 0) as civicrm_contribution_total_amount_sum, COUNT(contribution_civireport.total_amount) as civicrm_contribution_total_amount_count, IFNULL(ROUND(AVG(contribution_civireport.total_amount),2), 0) as civicrm_contribution_total_amount_avg
FROM civicrm_membership membership_civireport
LEFT JOIN civicrm_contact contact_civireport ON ( membership_civireport.contact_id = contact_civireport.id )
LEFT JOIN civicrm_membership_status
ON (membership_civireport.status_id = civicrm_membership_status.id )
LEFT JOIN civicrm_membership_payment payment
ON ( membership_civireport.id = payment.membership_id )
LEFT JOIN civicrm_contribution contribution_civireport
ON payment.contribution_id = contribution_civireport.id WHERE membership_civireport.is_test = 0 AND
contact_civireport.is_deleted = 0 AND ( membership_civireport.membership_join_date >= 20191118000000 ) AND ( membership_civireport.membership_join_date <= 20191118235959 ) GROUP BY membership_civireport.membership_type_id WITH ROLLUP LIMIT 0, 50 [nativecode=1054 ** Unknown column 'membership_civireport.membership_join_date' in 'where clause']
[type] => DB_Error
[user_info] => SELECT SQL_CALC_FOUND_ROWS COUNT( DISTINCT membership_civireport.id ) as civicrm_membership_member_count, membership_civireport.membership_type_id as civicrm_membership_membership_type_id, contribution_civireport.currency as civicrm_contribution_currency, IFNULL(SUM(contribution_civireport.total_amount), 0) as civicrm_contribution_total_amount_sum, COUNT(contribution_civireport.total_amount) as civicrm_contribution_total_amount_count, IFNULL(ROUND(AVG(contribution_civireport.total_amount),2), 0) as civicrm_contribution_total_amount_avg
FROM civicrm_membership membership_civireport
LEFT JOIN civicrm_contact contact_civireport ON ( membership_civireport.contact_id = contact_civireport.id )
LEFT JOIN civicrm_membership_status
ON (membership_civireport.status_id = civicrm_membership_status.id )
LEFT JOIN civicrm_membership_payment payment
ON ( membership_civireport.id = payment.membership_id )
LEFT JOIN civicrm_contribution contribution_civireport
ON payment.contribution_id = contribution_civireport.id WHERE membership_civireport.is_test = 0 AND
contact_civireport.is_deleted = 0 AND ( membership_civireport.membership_join_date >= 20191118000000 ) AND ( membership_civireport.membership_join_date <= 20191118235959 ) GROUP BY membership_civireport.membership_type_id WITH ROLLUP LIMIT 0, 50 [nativecode=1054 ** Unknown column 'membership_civireport.membership_join_date' in 'where clause']
[to_string] => [db_error: message="DB Error: no such field" code=-19 mode=callback callback=CRM_Core_Error::handle prefix="" info="SELECT SQL_CALC_FOUND_ROWS COUNT( DISTINCT membership_civireport.id ) as civicrm_membership_member_count, membership_civireport.membership_type_id as civicrm_membership_membership_type_id, contribution_civireport.currency as civicrm_contribution_currency, IFNULL(SUM(contribution_civireport.total_amount), 0) as civicrm_contribution_total_amount_sum, COUNT(contribution_civireport.total_amount) as civicrm_contribution_total_amount_count, IFNULL(ROUND(AVG(contribution_civireport.total_amount),2), 0) as civicrm_contribution_total_amount_avg
FROM civicrm_membership membership_civireport
LEFT JOIN civicrm_contact contact_civireport ON ( membership_civireport.contact_id = contact_civireport.id )
LEFT JOIN civicrm_membership_status
ON (membership_civireport.status_id = civicrm_membership_status.id )
LEFT JOIN civicrm_membership_payment payment
ON ( membership_civireport.id = payment.membership_id )
LEFT JOIN civicrm_contribution contribution_civireport
ON payment.contribution_id = contribution_civireport.id WHERE membership_civireport.is_test = 0 AND
contact_civireport.is_deleted = 0 AND ( membership_civireport.membership_join_date >= 20191118000000 ) AND ( membership_civireport.membership_join_date <= 20191118235959 ) GROUP BY membership_civireport.membership_type_id WITH ROLLUP LIMIT 0, 50 [nativecode=1054 ** Unknown column 'membership_civireport.membership_join_date' in 'where clause']"]
)