GitLab

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']"]
)