CiviCRM Community Forums (archive)

Hi,
I received the following error message and details when I tried to edit a contact.  What should I do to prevent this?

Thanks, Nicholas

************
unrecoverable error
    Sorry. A non-recoverable error has occurred.

    DB Error: constraint violation

    Database Error Code: Cannot add or update a child row: a foreign key constraint fails (`goodforkidscivicrm/civicrm_value_kids_2`, CONSTRAINT `FK_civicrm_value_kids_2_entity_id` FOREIGN KEY (`entity_id`) REFERENCES `civicrm_participant` (`id`) ON DELETE CASCADE), 1452

Error Details:

Array
(
    [callback] => Array
        (
           

• => CRM_Core_Error
[1] => handle
        )

   

=> -3
    [message] => DB Error: constraint violation
    [mode] => 16
    [debug_info] => INSERT INTO civicrm_value_kids_2  ( child_coaching_scholarship_start_30,child_coaching_scholarship_locat_31,child_coaching_scholarship_coach_42,child_activity_7,child_art_type_8,child_sport_type_9,child_dance_type_10,child_coaching_scholarship_appli_26,child_coaching_scholarship_award_18,child_coaching_scholarship_day_1_33,child_coaching_scholarship_day_1_34,child_coaching_scholarship_day_1_35,child_coaching_scholarship_day_2_36,child_coaching_scholarship_day_2_37,child_coaching_scholarship_day_2_38,child_coaching_scholarship_day_3_39,child_coaching_scholarship_day_3_40,child_coaching_scholarship_day_3_41,coaching_scholarship_total_hours_56,entity_id ) VALUES ( null,'','','','','','',null,null,'','hh:mm  am/pm','hh:mm  am/pm','','hh:mm  am/pm','hh:mm  am/pm','','hh:mm  am/pm','hh:mm  am/pm',0,153 ) ON DUPLICATE KEY UPDATE child_coaching_scholarship_start_30 = null,child_coaching_scholarship_locat_31 = '',child_coaching_scholarship_coach_42 = '',child_activity_7 = '',child_art_type_8 = '',child_sport_type_9 = '',child_dance_type_10 = '',child_coaching_scholarship_appli_26 = null,child_coaching_scholarship_award_18 = null,child_coaching_scholarship_day_1_33 = '',child_coaching_scholarship_day_1_34 = 'hh:mm  am/pm',child_coaching_scholarship_day_1_35 = 'hh:mm  am/pm',child_coaching_scholarship_day_2_36 = '',child_coaching_scholarship_day_2_37 = 'hh:mm  am/pm',child_coaching_scholarship_day_2_38 = 'hh:mm  am/pm',child_coaching_scholarship_day_3_39 = '',child_coaching_scholarship_day_3_40 = 'hh:mm  am/pm',child_coaching_scholarship_day_3_41 = 'hh:mm  am/pm',coaching_scholarship_total_hours_56 = 0 [nativecode=1452 ** Cannot add or update a child row: a foreign key constraint fails (`goodforkidscivicrm/civicrm_value_kids_2`, CONSTRAINT `FK_civicrm_value_kids_2_entity_id` FOREIGN KEY (`entity_id`) REFERENCES `civicrm_participant` (`id`) ON DELETE CASCADE)]
    [type] => DB_Error
    [user_info] => INSERT INTO civicrm_value_kids_2  ( child_coaching_scholarship_start_30,child_coaching_scholarship_locat_31,child_coaching_scholarship_coach_42,child_activity_7,child_art_type_8,child_sport_type_9,child_dance_type_10,child_coaching_scholarship_appli_26,child_coaching_scholarship_award_18,child_coaching_scholarship_day_1_33,child_coaching_scholarship_day_1_34,child_coaching_scholarship_day_1_35,child_coaching_scholarship_day_2_36,child_coaching_scholarship_day_2_37,child_coaching_scholarship_day_2_38,child_coaching_scholarship_day_3_39,child_coaching_scholarship_day_3_40,child_coaching_scholarship_day_3_41,coaching_scholarship_total_hours_56,entity_id ) VALUES ( null,'','','','','','',null,null,'','hh:mm  am/pm','hh:mm  am/pm','','hh:mm  am/pm','hh:mm  am/pm','','hh:mm  am/pm','hh:mm  am/pm',0,153 ) ON DUPLICATE KEY UPDATE child_coaching_scholarship_start_30 = null,child_coaching_scholarship_locat_31 = '',child_coaching_scholarship_coach_42 = '',child_activity_7 = '',child_art_type_8 = '',child_sport_type_9 = '',child_dance_type_10 = '',child_coaching_scholarship_appli_26 = null,child_coaching_scholarship_award_18 = null,child_coaching_scholarship_day_1_33 = '',child_coaching_scholarship_day_1_34 = 'hh:mm  am/pm',child_coaching_scholarship_day_1_35 = 'hh:mm  am/pm',child_coaching_scholarship_day_2_36 = '',child_coaching_scholarship_day_2_37 = 'hh:mm  am/pm',child_coaching_scholarship_day_2_38 = 'hh:mm  am/pm',child_coaching_scholarship_day_3_39 = '',child_coaching_scholarship_day_3_40 = 'hh:mm  am/pm',child_coaching_scholarship_day_3_41 = 'hh:mm  am/pm',coaching_scholarship_total_hours_56 = 0 [nativecode=1452 ** Cannot add or update a child row: a foreign key constraint fails (`goodforkidscivicrm/civicrm_value_kids_2`, CONSTRAINT `FK_civicrm_value_kids_2_entity_id` FOREIGN KEY (`entity_id`) REFERENCES `civicrm_participant` (`id`) ON DELETE CASCADE)]
    [to_string] => [db_error: message="DB Error: constraint violation" code=-3 mode=callback callback=CRM_Core_Error::handle prefix="" info="INSERT INTO civicrm_value_kids_2  ( child_coaching_scholarship_start_30,child_coaching_scholarship_locat_31,child_coaching_scholarship_coach_42,child_activity_7,child_art_type_8,child_sport_type_9,child_dance_type_10,child_coaching_scholarship_appli_26,child_coaching_scholarship_award_18,child_coaching_scholarship_day_1_33,child_coaching_scholarship_day_1_34,child_coaching_scholarship_day_1_35,child_coaching_scholarship_day_2_36,child_coaching_scholarship_day_2_37,child_coaching_scholarship_day_2_38,child_coaching_scholarship_day_3_39,child_coaching_scholarship_day_3_40,child_coaching_scholarship_day_3_41,coaching_scholarship_total_hours_56,entity_id ) VALUES ( null,'','','','','','',null,null,'','hh:mm  am/pm','hh:mm  am/pm','','hh:mm  am/pm','hh:mm  am/pm','','hh:mm  am/pm','hh:mm  am/pm',0,153 ) ON DUPLICATE KEY UPDATE child_coaching_scholarship_start_30 = null,child_coaching_scholarship_locat_31 = '',child_coaching_scholarship_coach_42 = '',child_activity_7 = '',child_art_type_8 = '',child_sport_type_9 = '',child_dance_type_10 = '',child_coaching_scholarship_appli_26 = null,child_coaching_scholarship_award_18 = null,child_coaching_scholarship_day_1_33 = '',child_coaching_scholarship_day_1_34 = 'hh:mm  am/pm',child_coaching_scholarship_day_1_35 = 'hh:mm  am/pm',child_coaching_scholarship_day_2_36 = '',child_coaching_scholarship_day_2_37 = 'hh:mm  am/pm',child_coaching_scholarship_day_2_38 = 'hh:mm  am/pm',child_coaching_scholarship_day_3_39 = '',child_coaching_scholarship_day_3_40 = 'hh:mm  am/pm',child_coaching_scholarship_day_3_41 = 'hh:mm  am/pm',coaching_scholarship_total_hours_56 = 0 [nativecode=1452 ** Cannot add or update a child row: a foreign key constraint fails (`goodforkidscivicrm/civicrm_value_kids_2`, CONSTRAINT `FK_civicrm_value_kids_2_entity_id` FOREIGN KEY (`entity_id`) REFERENCES `civicrm_participant` (`id`) ON DELETE CASCADE)]"]

**********************

Thanks Lobo.  You were right in that originally I had designated a custom group as Participant then changed it in the database to Individual.  This is what caused the error.

I have re-created the group as an individual, deleted the original group, and can edit contacts without any issues.

Thanks,
Nicholas