CiviCRM Community Forums (archive)

Hi,

I'd like to run a SQL query in phpMyAdmin to mass update all of the contribution records in my DB from contribution type Donation to Member Dues. I tried running this:

update civicrm_contribution set contribution_type_id = 3
...but received this error message:

#1452 - Cannot add or update a child row: a foreign key constraint fails (`jimmyjam_civi1/civicrm_contribution`, CONSTRAINT `FK_civicrm_contribution_contribution_type_id` FOREIGN KEY (`contribution_type_id`) REFERENCES `civicrm_contribution_type` (`id`) ON DELETE SE)

Thanks,
James