CiviCRM Community Forums (archive)

Hello To All
In CiviCrm when i use Custom Data(Home>Administer CiviCrm>Custom Data>add field) and add field  an error come. This error
"

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 (`nasiv2/civicrm_custom_field`, CONSTRAINT `FK_civicrm_custom_field_custom_group_id` FOREIGN KEY (`custom_group_id`) REFERENCES `civicrm_custom_group` (`id`) ON DELETE CASCADE), 1452

    Return to home page.

Error Details:

Array
(
    [callback] => Array
        (
           

• => CRM_Core_Error
[1] => handle
        )

   

=> -3
    [message] => DB Error: constraint violation
    [mode] => 16
    [debug_info] => INSERT INTO civicrm_custom_field (custom_group_id , label , data_type , html_type , default_value , is_required , is_searchable , is_search_range , weight , help_post , is_active , is_view , options_per_line , text_length , start_date_years , end_date_years , date_parts , note_columns , note_rows , column_name , option_group_id ) VALUES ( 6 , 'Created By' , 'String' , 'Text' ,  NULL ,  0 ,  0 ,  0 ,  1 ,  NULL ,  1 ,  0 ,  NULL ,  255 ,  NULL ,  NULL , 'M
d
Y' ,  60 ,  4 , 'created_by' ,  NULL )  [nativecode=1452 ** Cannot add or update a child row: a foreign key constraint fails (`nasiv2/civicrm_custom_field`, CONSTRAINT `FK_civicrm_custom_field_custom_group_id` FOREIGN KEY (`custom_group_id`) REFERENCES `civicrm_custom_group` (`id`) ON DELETE CASCADE)]
    [type] => DB_Error
    [user_info] => INSERT INTO civicrm_custom_field (custom_group_id , label , data_type , html_type , default_value , is_required , is_searchable , is_search_range , weight , help_post , is_active , is_view , options_per_line , text_length , start_date_years , end_date_years , date_parts , note_columns , note_rows , column_name , option_group_id ) VALUES ( 6 , 'Created By' , 'String' , 'Text' ,  NULL ,  0 ,  0 ,  0 ,  1 ,  NULL ,  1 ,  0 ,  NULL ,  255 ,  NULL ,  NULL , 'M
d
Y' ,  60 ,  4 , 'created_by' ,  NULL )  [nativecode=1452 ** Cannot add or update a child row: a foreign key constraint fails (`nasiv2/civicrm_custom_field`, CONSTRAINT `FK_civicrm_custom_field_custom_group_id` FOREIGN KEY (`custom_group_id`) REFERENCES `civicrm_custom_group` (`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_custom_field (custom_group_id , label , data_type , html_type , default_value , is_required , is_searchable , is_search_range , weight , help_post , is_active , is_view , options_per_line , text_length , start_date_years , end_date_years , date_parts , note_columns , note_rows , column_name , option_group_id ) VALUES ( 6 , 'Created By' , 'String' , 'Text' ,  NULL ,  0 ,  0 ,  0 ,  1 ,  NULL ,  1 ,  0 ,  NULL ,  255 ,  NULL ,  NULL , 'M
d
Y' ,  60 ,  4 , 'created_by' ,  NULL )  [nativecode=1452 ** Cannot add or update a child row: a foreign key constraint fails (`nasiv2/civicrm_custom_field`, CONSTRAINT `FK_civicrm_custom_field_custom_group_id` FOREIGN KEY (`custom_group_id`) REFERENCES `civicrm_custom_group` (`id`) ON DELETE CASCADE)]"]
)


"
Why This Error is coming ? and How we can solve it?
Thanks

Hi,

I did a forum search on 'REFERENCES `civicrm_custom_group` and got a couple of similar sounding problems - not sure if they apply because I don't know your version.