Author Topic: Can't remove email address (Read 676 times)

Denver Dave · July 03, 2009, 02:22:58 pm

CiviCRM v 1.9

We've discovered an interesting feature on a few records where the person had an email address and then decided to not have one. We also get the same error when trying to change the person's name, but oddly we can change their email address.

Any ideas why we can't remove the email address, but we can change it?

Could this because there are CiviMail mailings out there where the person participates? If so, we are having a heck of a time keeping these cleared out see related post:

http://forum.civicrm.org/index.php/topic,3330.0.html

Quote

Sorry. A non-recoverable error has occurred.

Database Error Code: Cannot delete or update a parent row: a foreign key constraint fails (`info_drupal/civicrm_mailing_event_queue`, CONSTRAINT `FK_civicrm_mailing_event_queue_email_id` FOREIGN KEY (`email_id`) REFERENCES `civicrm_email` (`id`)), 1451

Dave Greenberg · July 03, 2009, 03:08:28 pm

Dave - Yes, it's because those email addresses where part of past mailings. We've corrected this problem in newer releases by setting the ONDELETE CASCADE property on foreign key like this one. Of course we recommend that you upgrade - since 1.9 is quite old and no longer supported.

CiviCRM Community Forums (archive)

News:

Author Topic: Can't remove email address (Read 676 times)

Denver Dave

Can't remove email address

Dave Greenberg

Re: Can't remove email address