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

Extraneous civicrm_price_set_entity rows created when submitting online contribution / membership signups

    Details

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

      Description

      My understanding is that the purpose of the price_set_entity table is to link online contribution pages to price sets, and events to price sets. The sample data properly contains rows which do this for the 3 sample online contribution pages, and the 3 sample events.

      However, I am seeing sample data rows AND new rows created in this table linking price sets to specific contribution records. I don't understand why this would be needed - AND the insert behavior is inconsistent. If there's some reason we need these entries in price_set_entity - let's discuss please.

      BUG 1: There are additional entries in the sample data linking price set 1 to each of the 13 sample contribution records.

      BUG 2: When I make an online contribution (using sample contribution pages) - a new row is inserted in civicrm_price_set_entity linking the contribution page's price set to the contribution. Why is this needed? Note that rows are NOT inserted into this table for any of these other actions:

      • offline contribution (quick config)
      • online event registration (quick config)
      • offline event registration (quick config)
      • online or offline event registration (explicit price set)

        Attachments

          Activity

            People

            • Assignee:
              dgg David Greenberg
              Reporter:
              dgg David Greenberg
            • Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: