CiviCRM Community Forums (archive)

Hi,
I have a new CiviCRM installation (4.1.3) using Drupal 7.  Everything seems to be working fine except that I can't create or edit profiles.  When creating a profile I receive the following error after hitting save:

Sorry. A non-recoverable error has occurred.
DB Error: constraint violation

Return to home page.
I've tried emptying my cache table, refreshing the sessions, and refreshing the back end.  Has anyone else run into this issue and have found a work around or who think might know the solution?

Thanks,
- Dave

Update 2012-06-21, here's the detailed error message:

Database Error Code: Cannot add or update a child row: a foreign key constraint fails (`630312_db_civicrm`.`civicrm_uf_group`, CONSTRAINT `FK_civicrm_uf_group_created_id` FOREIGN KEY (`created_id`) REFERENCES `civicrm_contact` (`id`) ON DELETE SET NULL), 1452
Additional Details:

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

    [code] => -3
    [message] => DB Error: constraint violation
    [mode] => 16
    [debug_info] => INSERT INTO civicrm_uf_group (is_active , title , help_pre , help_post , limit_listings_group_id , post_URL , add_to_group_id , add_captcha , is_map , is_edit_link , is_uf_link , is_update_dupe , cancel_URL , is_cms_user , notify , name , created_id , created_date , is_proximity_search ) VALUES ( 1 , 'Email Address Only' ,  NULL ,  NULL ,  2 , '/' ,  2 ,  0 ,  0 ,  0 ,  0 ,  0 , '/' ,  NULL , 'davebagler@gpo.ca' , 'Email_Address_Only' ,  1 ,  20120621165751 ,  0 )  [nativecode=1452 ** Cannot add or update a child row: a foreign key constraint fails (`630312_db_civicrm`.`civicrm_uf_group`, CONSTRAINT `FK_civicrm_uf_group_created_id` FOREIGN KEY (`created_id`) REFERENCES `civicrm_contact` (`id`) ON DELETE SET NULL)]
    [type] => DB_Error
    [user_info] => INSERT INTO civicrm_uf_group (is_active , title , help_pre , help_post , limit_listings_group_id , post_URL , add_to_group_id , add_captcha , is_map , is_edit_link , is_uf_link , is_update_dupe , cancel_URL , is_cms_user , notify , name , created_id , created_date , is_proximity_search ) VALUES ( 1 , 'Email Address Only' ,  NULL ,  NULL ,  2 , '/' ,  2 ,  0 ,  0 ,  0 ,  0 ,  0 , '/' ,  NULL , 'davebagler@gpo.ca' , 'Email_Address_Only' ,  1 ,  20120621165751 ,  0 )  [nativecode=1452 ** Cannot add or update a child row: a foreign key constraint fails (`630312_db_civicrm`.`civicrm_uf_group`, CONSTRAINT `FK_civicrm_uf_group_created_id` FOREIGN KEY (`created_id`) REFERENCES `civicrm_contact` (`id`) ON DELETE SET NULL)]
    [to_string] => [db_error: message="DB Error: constraint violation" code=-3 mode=callback callback=CRM_Core_Error::handle prefix="" info="INSERT INTO civicrm_uf_group (is_active , title , help_pre , help_post , limit_listings_group_id , post_URL , add_to_group_id , add_captcha , is_map , is_edit_link , is_uf_link , is_update_dupe , cancel_URL , is_cms_user , notify , name , created_id , created_date , is_proximity_search ) VALUES ( 1 , 'Email Address Only' ,  NULL ,  NULL ,  2 , '/' ,  2 ,  0 ,  0 ,  0 ,  0 ,  0 , '/' ,  NULL , 'davebagler@gpo.ca' , 'Email_Address_Only' ,  1 ,  20120621165751 ,  0 )  [nativecode=1452 ** Cannot add or update a child row: a foreign key constraint fails (`630312_db_civicrm`.`civicrm_uf_group`, CONSTRAINT `FK_civicrm_uf_group_created_id` FOREIGN KEY (`created_id`) REFERENCES `civicrm_contact` (`id`) ON DELETE SET NULL)]"])

Can you enable debugging and try again and post the details?

can you log out and log back in

seems like its using a stale session or something

lobo