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

Transaction ID limited to 16chars when exporting event participations

    Details

    • Type: Bug
    • Status: Done/Fixed
    • Priority: Major
    • Resolution: Fixed/Completed
    • Affects Version/s: 4.4.1
    • Fix Version/s: 4.4.2
    • Component/s: None
    • Labels:
      None

      Description

      When you export contributions you get a full Transaction ID, but when you export the Event Participations the Transaction ID is limited to 16 chars.

      The cause is: the Temp Table creates a 16 char field for Transaction ID on line 1278
      if (substr($fieldName, -3, 3) == '_id')

      { $sqlColumns[$fieldName] = "$fieldName varchar(16)"; }

      Solution: create an exception for Transaction ID
      if ($fieldName == "componentpaymentfield_transaction_id" ){ $sqlColumns[$fieldName] = "$fieldName varchar(255)"; }
      elseif (substr($fieldName, -3, 3) == '_id') { $sqlColumns[$fieldName] = "$fieldName varchar(16)"; }

      A more general solution might be needed if there are more "_id" fields that need a larger field

        Attachments

          Activity

            People

            • Assignee:
              lobo Donald A. Lobo
              Reporter:
              catorghans Hans Idink
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: