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

trxn_id and invoice_id fields are UNIQUE when more than one Contribution could be in the same transaction or invoice

    Details

    • Type: Bug
    • Status: Done/Fixed
    • Priority: Major
    • Resolution: Incomplete
    • Affects Version/s: 4.3.3
    • Fix Version/s: Unscheduled
    • Component/s: CiviContribute
    • Labels:
      None
    • Documentation Required?:
      None
    • Funding Source:
      Needs Funding

      Description

      These two fields should just have the UNIQUE restraint removed.

      I note that the trxn_id is scheduled for removal once all payment information is confidently being stored in the financial_trxn table.

      This can be a major issue for people trying to link contributions directly to Invoices or Payments.

        Attachments

          Activity

            People

            • Assignee:
              andrew Andrew Perry
              Reporter:
              andrew Andrew Perry
            • Votes:
              1 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: