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

Disable Price Set Needs "is_active" Filter in Query

    Details

    • Type: Bug
    • Status: Done/Fixed
    • Priority: Minor
    • Resolution: Fixed/Completed
    • Affects Version/s: 3.4.8
    • Fix Version/s: 4.2.0
    • Component/s: CiviEvent
    • Labels:
      None

      Description

      When trying to disable a Price Set, the check for events or contributions used by the set does not exclude Inactive Events. According to the error message ("The price set is used by one or more active events ..."), it should be excluding those.

      It looks like CRM/Price/BAO/Set.php, getUsedBy, is missing an additional WHERE clause filter on the query. Seems as it needs something like:
      (ce.is_active IS NULL OR ce.is_active = 1) AND

        Attachments

          Activity

            People

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

              Dates

              • Created:
                Updated:
                Resolved: