Giftaid report: DB Error: No Such Field
When exporting a report keep getting this error in 5.13.4. What could be cause of this?
[message] => DB Error: no such field
[mode] => 16
[debug_info] =>
SELECT COUNT(contribution_civireport.total_amount ) as count,
SUM( contribution_civireport.total_amount ) as amount,
ROUND(AVG(contribution_civireport.total_amount), 2) as avg,
contribution_civireport.currency as currency,
SUM( contribution_civireport.fee_amount ) as fees,
SUM( contribution_civireport.net_amount ) as net
FROM civicrm_contact contact_civireport
INNER JOIN civicrm_contribution source_contact_table
ON contribution_civireport.id = source_contact_table.id
INNER JOIN civicrm_contribution contribution_civireport
ON contact_civireport.id = contribution_civireport.contact_id
AND contribution_civireport.is_test = 0
LEFT JOIN civicrm_phone phone_civireport
ON contact_civireport.id = phone_civireport.contact_id AND
phone_civireport.is_primary = 1
LEFT JOIN civicrm_address address_civireport
ON (contact_civireport.id =
address_civireport.contact_id) AND
address_civireport.is_primary = 1
LEFT JOIN civicrm_email email_civireport
ON (contact_civireport.id = email_civireport.contact_id AND
email_civireport.is_primary = 1)
LEFT JOIN civicrm_value_gift_aid_declaration value_gift_aid_declaration_civireport ON value_gift_aid_declaration_civireport.entity_id = contact_civireport.id
LEFT JOIN civicrm_value_gift_aid_submission value_gift_aid_submission_civireport ON value_gift_aid_submission_civireport.entity_id = contribution_civireport.id WHERE ( contact_civireport.is_deleted = 0 ) AND (1) AND ( contribution_civireport.receive_date >= 20150101000000 ) AND ( contribution_civireport.receive_date <= 20190526235959 ) AND ( contribution_civireport.financial_type_id IN (5, 6, 7, 8, 10, 1, 11, 12, 13, 31, 14, 18, 40, 43, 42, 19, 20, 21, 22, 23, 24, 28, 25, 26, 16, 27, 37, 44, 17, 30, 29, 33, 34) ) AND ( contribution_civireport.contribution_status_id IN (1) )
GROUP BY contribution_civireport.currency [nativecode=1054 ** Unknown column 'contribution_civireport.id' in 'on clause']