Details
-
Type:
Bug
-
Status: Done/Fixed
-
Priority:
Minor
-
Resolution: Fixed/Completed
-
Affects Version/s: 4.3.0
-
Fix Version/s: 4.2.8
-
Component/s: Core CiviCRM
-
Labels:None
Description
The error comes from work/civicrm/CRM/Upgrade/Incremental/sql/4.2.alpha1.mysql.tpl,
INSERT INTO civicrm_line_item ( entity_table, entity_id, price_field_id, label, qty, unit_price, line_total, participant_count, price_field_value_id )
SELECT 'civicrm_contribution', cc.id, @fieldID, 'Contribution Amount', ROUND(total_amount,0), '1.00', total_amount , 0, @fieldValueID
If total_amount < 0, the query fails with "value out of range", because the column is unsigned.