Details
-
Type: Bug
-
Status: Done/Fixed
-
Priority: Trivial
-
Resolution: Duplicate
-
Affects Version/s: 3.2
-
Fix Version/s: 3.2
-
Component/s: CiviContribute
-
Labels:None
Description
Error when viewing currency tab of people who have been soft credited a contribution: (because currency is field in contribution table & soft credit table)
DB Error: a515ac9c2796ca0e23adbe92c68fc9fc
Database Error Code: Column 'currency' in field list is ambiguous, 1052
Return to home page.
Error Details:
Array
(
[callback] => Array
(
[0] => CRM_Core_Error
[1] => handle
)
[code] => a515ac9c2796ca0e23adbe92c68fc9fc
[message] => DB Error: a515ac9c2796ca0e23adbe92c68fc9fc
[mode] => 16
[debug_info] => SELECT SUM(amount) as amount,
AVG(total_amount) as average,
currency
FROM civicrm_contribution_soft ccs
LEFT JOIN civicrm_contribution cc
ON ccs.contribution_id = cc.id
WHERE cc.is_test = 0 AND
ccs.contact_id = 3
GROUP BY currency [nativecode=1052 ** Column 'currency' in field list is ambiguous]
[type] => DB_Error
[user_info] => SELECT SUM(amount) as amount,
AVG(total_amount) as average,
currency
FROM civicrm_contribution_soft ccs
LEFT JOIN civicrm_contribution cc
ON ccs.contribution_id = cc.id
WHERE cc.is_test = 0 AND
ccs.contact_id = 3
GROUP BY currency [nativecode=1052 ** Column 'currency' in field list is ambiguous]
[to_string] => [db_error: message="DB Error: a515ac9c2796ca0e23adbe92c68fc9fc" code=0 mode=callback callback=CRM_Core_Error::handle prefix="" info="SELECT SUM(amount) as amount,
AVG(total_amount) as average,
currency
FROM civicrm_contribution_soft ccs
LEFT JOIN civicrm_contribution cc
ON ccs.contribution_id = cc.id
WHERE cc.is_test = 0 AND
ccs.contact_id = 3
GROUP BY currency [nativecode=1052 ** Column 'currency' in field list is ambiguous]"]
)