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')
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