CiviCRM Community Forums (archive)

By running the SQL query provided below, I get over 200 records where the sum of the line item amount does NOT match the contribution total_amount.   Is there ever a legitimate reason for this? Or is this a bug?    I am running version 4.3.8 ( which was upgraded from version 4.2.7)      Should I attempt to craft an SQL update statement to fix the issue?

SELECT c.id, c.contact_id, COUNT( li.id ) , SUM( line_total ) , c.total_amount, c.source
FROM civicrm_line_item li
JOIN civicrm_participant part ON li.entity_id = part.id
AND li.entity_table =  'civicrm_participant'
JOIN civicrm_participant_payment ep ON IFNULL( part.registered_by_id, part.id ) = ep.participant_id
JOIN civicrm_contribution c ON ep.contribution_id = c.id
GROUP BY c.id
HAVING SUM( li.line_total ) <> c.total_amount