Uploaded image for project: 'CiviCRM'
  1. CiviCRM
  2. CRM-21509

Add to Group in Top Donors report fails with DB error

    Details

    • Versioning Impact:
      Patch (backwards-compatible bug fixes)
    • Documentation Required?:
      None
    • Funding Source:
      Contributed Code
    • Verified?:
      No

      Description

      Steps to replicate:
      ------------------------

      Go to Top Donors report and search for results
      Add contacts to any group and you get this error

      Database Error Code: Incorrect usage/placement of 'SQL_CALC_FOUND_ROWS', 1234
      Additional Details:
      Array
      (
          [callback] => Array
              (
                  [0] => CRM_Core_Error
                  [1] => handle
              )
      
          [code] => -1
          [message] => DB Error: unknown error
          [mode] => 16
          [debug_info] => SELECT * FROM (  SELECT SQL_CALC_FOUND_ROWS  contact_civireport.display_name as civicrm_contact_display_name, contact_civireport.id as civicrm_contact_id, SUM(contribution_civireport.total_amount) as civicrm_contribution_total_amount_sum, COUNT(contribution_civireport.total_amount) as civicrm_contribution_total_amount_count, ROUND(AVG(contribution_civireport.total_amount),2) as civicrm_contribution_total_amount_avg, contribution_civireport.currency as civicrm_contribution_currency  
              FROM civicrm_contact contact_civireport 
                  INNER JOIN civicrm_contribution contribution_civireport
                      ON contact_civireport.id = contribution_civireport.contact_id AND contribution_civireport.is_test = 0
                   LEFT  JOIN civicrm_email  email_civireport
                               ON contact_civireport.id = email_civireport.contact_id
                               AND email_civireport.is_primary = 1
                   LEFT  JOIN civicrm_phone  phone_civireport
                               ON contact_civireport.id = phone_civireport.contact_id AND
                                  phone_civireport.is_primary = 1  WHERE ( contact_civireport.is_deceased = 0 ) AND ( contact_civireport.is_deleted = 0 ) AND ( receive_date >= 20170101000000 ) AND ( receive_date <= 20171231235959 ) AND ( contribution_civireport.contribution_status_id IN (1) )  GROUP BY contact_civireport.id, contribution_civireport.currency
                           ORDER BY civicrm_contribution_total_amount_sum DESC
                       ) as abc   LIMIT 0, 50
                      [nativecode=1234 ** Incorrect usage/placement of 'SQL_CALC_FOUND_ROWS']
          [type] => DB_Error
          [user_info] => SELECT * FROM (  SELECT SQL_CALC_FOUND_ROWS  contact_civireport.display_name as civicrm_contact_display_name, contact_civireport.id as civicrm_contact_id, SUM(contribution_civireport.total_amount) as civicrm_contribution_total_amount_sum, COUNT(contribution_civireport.total_amount) as civicrm_contribution_total_amount_count, ROUND(AVG(contribution_civireport.total_amount),2) as civicrm_contribution_total_amount_avg, contribution_civireport.currency as civicrm_contribution_currency  
              FROM civicrm_contact contact_civireport 
                  INNER JOIN civicrm_contribution contribution_civireport
                      ON contact_civireport.id = contribution_civireport.contact_id AND contribution_civireport.is_test = 0
                   LEFT  JOIN civicrm_email  email_civireport
                               ON contact_civireport.id = email_civireport.contact_id
                               AND email_civireport.is_primary = 1
                   LEFT  JOIN civicrm_phone  phone_civireport
                               ON contact_civireport.id = phone_civireport.contact_id AND
                                  phone_civireport.is_primary = 1  WHERE ( contact_civireport.is_deceased = 0 ) AND ( contact_civireport.is_deleted = 0 ) AND ( receive_date >= 20170101000000 ) AND ( receive_date <= 20171231235959 ) AND ( contribution_civireport.contribution_status_id IN (1) )  GROUP BY contact_civireport.id, contribution_civireport.currency
                           ORDER BY civicrm_contribution_total_amount_sum DESC
                       ) as abc   LIMIT 0, 50
                      [nativecode=1234 ** Incorrect usage/placement of 'SQL_CALC_FOUND_ROWS']
          [to_string] => [db_error: message="DB Error: unknown error" code=-1 mode=callback callback=CRM_Core_Error::handle prefix="" info="SELECT * FROM (  SELECT SQL_CALC_FOUND_ROWS  contact_civireport.display_name as civicrm_contact_display_name, contact_civireport.id as civicrm_contact_id, SUM(contribution_civireport.total_amount) as civicrm_contribution_total_amount_sum, COUNT(contribution_civireport.total_amount) as civicrm_contribution_total_amount_count, ROUND(AVG(contribution_civireport.total_amount),2) as civicrm_contribution_total_amount_avg, contribution_civireport.currency as civicrm_contribution_currency  
              FROM civicrm_contact contact_civireport 
                  INNER JOIN civicrm_contribution contribution_civireport
                      ON contact_civireport.id = contribution_civireport.contact_id AND contribution_civireport.is_test = 0
                   LEFT  JOIN civicrm_email  email_civireport
                               ON contact_civireport.id = email_civireport.contact_id
                               AND email_civireport.is_primary = 1
                   LEFT  JOIN civicrm_phone  phone_civireport
                               ON contact_civireport.id = phone_civireport.contact_id AND
                                  phone_civireport.is_primary = 1  WHERE ( contact_civireport.is_deceased = 0 ) AND ( contact_civireport.is_deleted = 0 ) AND ( receive_date >= 20170101000000 ) AND ( receive_date <= 20171231235959 ) AND ( contribution_civireport.contribution_status_id IN (1) )  GROUP BY contact_civireport.id, contribution_civireport.currency
                           ORDER BY civicrm_contribution_total_amount_sum DESC
                       ) as abc   LIMIT 0, 50
                      [nativecode=1234 ** Incorrect usage/placement of 'SQL_CALC_FOUND_ROWS']"]
      )
      

        Attachments

          Activity

            People

            • Assignee:
              yashodha Yashodha Chaku
              Reporter:
              yashodha Yashodha Chaku
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: