Author Topic: Error viewing Contributions if Contact has a Soft Credit applied to them (Read 1200 times)

pbarmak · July 15, 2010, 10:49:15 am

In 3.2.beta3, if I create a contribution and soft credit Contact A, when I then go to Contact A's summary page and click on the Contributions tab, I get the following database error (ambiguous column). Doesn't happen unless there is a soft credit.

Code: [Select]

Sorry. A non-recoverable error has occurred.

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 = 1
                  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 = 1
                  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 = 1
                  GROUP BY currency  [nativecode=1052 ** Column 'currency' in field list is ambiguous]"]
)

[/code]

Dave Greenberg · July 15, 2010, 12:19:14 pm

Thx for reporting this. It has already been fixed - and fix is part of beta4 which was released today.

http://issues.civicrm.org/jira/browse/CRM-6464

CiviCRM Community Forums (archive)

News:

Author Topic: Error viewing Contributions if Contact has a Soft Credit applied to them (Read 1200 times)

pbarmak

Error viewing Contributions if Contact has a Soft Credit applied to them

Dave Greenberg

Re: Error viewing Contributions if Contact has a Soft Credit applied to them