Author Topic: Error reconfiguring event (Read 1309 times)

sdybiec · June 10, 2008, 05:33:46 am

After creating an event in CiviEvent, we decided not to have email addresses listed on our event listing. When we attempted to remove the email addresses using the "Event Location and Contact Information" page, we got this error:

Code: [Select]

Sorry. A non-recoverable error has occurred.

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

Array
(
    [callback] => Array
        (
            [0] => CRM_Core_Error
            [1] => handle
        )

    [code] => -1
    [message] => DB Error: unknown error
    [mode] => 16
    [debug_info] => DELETE FROM civicrm_email  WHERE (  civicrm_email.id = 2086 )  [nativecode=1451 ** Cannot delete or update a parent row: a foreign key constraint fails (`uaprogre_civicrm19Fix/civicrm_loc_block`, CONSTRAINT `FK_civicrm_loc_block_email_id` FOREIGN KEY (`email_id`) REFERENCES `civicrm_email` (`id`))]
    [type] => DB_Error
    [user_info] => DELETE FROM civicrm_email  WHERE (  civicrm_email.id = 2086 )  [nativecode=1451 ** Cannot delete or update a parent row: a foreign key constraint fails (`uaprogre_civicrm19Fix/civicrm_loc_block`, CONSTRAINT `FK_civicrm_loc_block_email_id` FOREIGN KEY (`email_id`) REFERENCES `civicrm_email` (`id`))]
    [to_string] => [db_error: message="DB Error: unknown error" code=-1 mode=callback callback=CRM_Core_Error::handle prefix="" info="DELETE FROM civicrm_email  WHERE (  civicrm_email.id = 2086 )  [nativecode=1451 ** Cannot delete or update a parent row: a foreign key constraint fails (`uaprogre_civicrm19Fix/civicrm_loc_block`, CONSTRAINT `FK_civicrm_loc_block_email_id` FOREIGN KEY (`email_id`) REFERENCES `civicrm_email` (`id`))]"]

Our site is upgraded from a 1.9 site.

What do you make of this and how can I fix this?

$cott[/code]

Deepak Srivastava · July 01, 2008, 02:08:39 am

Here is the fix, if you haven't got it - run the following query on your civicrm db -

Code: [Select]

ALTER TABLE `civicrm_loc_block`
DROP FOREIGN KEY `FK_civicrm_loc_block_email_id`,
DROP FOREIGN KEY `FK_civicrm_loc_block_email_2_id`,
DROP FOREIGN KEY `FK_civicrm_loc_block_phone_id`,
DROP FOREIGN KEY  `FK_civicrm_loc_block_phone_2_id`,
DROP FOREIGN KEY `FK_civicrm_loc_block_im_id`,
DROP FOREIGN KEY  `FK_civicrm_loc_block_im_2_id`;

ALTER TABLE `civicrm_loc_block`
ADD CONSTRAINT `FK_civicrm_loc_block_email_id` FOREIGN KEY (`email_id`) REFERENCES `civicrm_email` (`id`) ON DELETE SET NULL,
ADD CONSTRAINT `FK_civicrm_loc_block_email_2_id` FOREIGN KEY (`email_2_id`) REFERENCES `civicrm_email` (`id`) ON DELETE SET NULL,
ADD CONSTRAINT `FK_civicrm_loc_block_phone_id` FOREIGN KEY (`phone_id`) REFERENCES `civicrm_phone` (`id`) ON DELETE SET NULL,
ADD CONSTRAINT `FK_civicrm_loc_block_phone_2_id` FOREIGN KEY (`phone_2_id`) REFERENCES `civicrm_phone` (`id`) ON DELETE SET NULL,
ADD CONSTRAINT `FK_civicrm_loc_block_im_id` FOREIGN KEY (`im_id`) REFERENCES `civicrm_im` (`id`) ON DELETE SET NULL,
ADD CONSTRAINT `FK_civicrm_loc_block_im_2_id` FOREIGN KEY (`im_2_id`) REFERENCES `civicrm_im` (`id`) ON DELETE SET NULL;

This basically sets the "ON DELETE SET NULL" constraint which i suspect wasn't done by upgrade.

CiviCRM Community Forums (archive)

News:

Author Topic: Error reconfiguring event (Read 1309 times)

sdybiec

Error reconfiguring event

Deepak Srivastava

Re: Error reconfiguring event