From 1c6526aaeed597bc2a58458dfb8dc25fd168549a Mon Sep 17 00:00:00 2001 From: Pradeep Nayak Date: Tue, 14 Aug 2018 15:36:02 +0100 Subject: [PATCH] Fixed fatal error 'DB Error: no such field' on Contribution detail report --- CRM/Report/Form.php | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/CRM/Report/Form.php b/CRM/Report/Form.php index f3dbf456e8..844c877ac6 100644 --- a/CRM/Report/Form.php +++ b/CRM/Report/Form.php @@ -5419,7 +5419,7 @@ LEFT JOIN civicrm_contact {$field['alias']} ON {$field['alias']}.id = {$this->_a ), 'age' => array( 'title' => $options['prefix_label'] . ts('Age'), - 'dbAlias' => 'TIMESTAMPDIFF(YEAR, ' . $tableAlias . '.birth_date, CURDATE())', + 'dbAlias' => 'TIMESTAMPDIFF(YEAR, ' . $tableAlias . '_civireport.birth_date, CURDATE())', 'type' => CRM_Utils_Type::T_INT, 'is_fields' => TRUE, ), -- 2.25.1