CiviCRM Community Forums (archive)

Hello,

I mention the following bug:

I search contributions of a specific financial type of the current year. The page offers X contributions with sum Y. When I export these set, one contribution appears five times and so the sum differs. The same wrong sum appears in the contribution report.

I checked the tables civicrm_contribution: I can find the right only X contributions.

May I have an error in my database. The SQL-Database has been updated regularly from version 3.4 to 4.4.

Greetings

Benedikt

many a times this has happened due to some inconsistencies in the DB data. i.e. 2 primary address / email / phone etc

might want to check and see if you can discover whats inconsistent in the duplicates. would be good to switch to temp tables so we can do a better job collecting and outputting the results

lobo

you'll need to run sql queries against the db and fix them as you find them. From our upgrade scripts (ThreeOne/ThreeOne.php) this should do the trick (please test before using)

UPDATE civicrm_address as address
INNER JOIN ( SELECT id, contact_id FROM civicrm_address WHERE is_primary = 1 GROUP BY contact_id HAVING count( id ) > 1 ) as dup_address
         ON ( address.contact_id = dup_address.contact_id AND address.id != dup_address.id )
        SET address.is_primary = 0";

and u can repeat the process for email/phone

lobo