Details
-
Type:
Bug
-
Status: Done/Fixed
-
Priority:
Major
-
Resolution: Fixed/Completed
-
Affects Version/s: 1.9
-
Fix Version/s: 1.9
-
Component/s: None
-
Labels:None
Description
Tried to "Delete" a mailing using the "Delete" action in Browse (Sent Mailings). Got the error below...
Database Error Code: Cannot delete or update a parent row: a foreign key constraint fails (`civicrm_19/civicrm_mailing_job`, CONSTRAINT `FK_civicrm_mailing_job_mailing_id` FOREIGN KEY (`mailing_id`) REFERENCES `civicrm_mailing` (`id`)), 1451
Prior to delete, I'm pretty sure there were multiple entries in the mailing_job table for this mailing id. I think there was still one job entry - so it looks like the "child" delete function might only be expecting one job ???