CiviCRM Community Forums (archive)

Anyone seen this?


When I try to edit an user (to change their role/email whatever) and hit submit..I get this error :


    Sorry. A non-recoverable error has occurred.

   Database Error Code: Cannot add or update a child row: a foreign
key constraint fails, 1216

   Return to CiviCRM menu.

error

Array
(
   [callback] => Array
       (
           

• => CRM_Core_Error
[1] => handle
       )

   

=> -3
   [message] => DB Error: constraint violation
   [mode] => 16
   [debug_info] => INSERT INTO civicrm_email (email , is_primary )
VALUES ('barnyveep@yahoo.co.in' ,  1 )  [nativecode=1216 ** Cannot add
or update a child row: a foreign key constraint fails]
   [type] => DB_Error
   [user_info] => INSERT INTO civicrm_email (email , is_primary )
VALUES ('barnyveep@yahoo.co.in' ,  1 )  [nativecode=1216 ** Cannot add
or update a child row: a foreign key constraint fails]
   [to_string] => [db_error: message="DB Error: constraint violation"
code=-3 mode=callback callback=CRM_Core_Error::handle prefix=""
info="INSERT INTO civicrm_email (email , is_primary ) VALUES
('barnyveep@yahoo.co.in' ,  1 )  [nativecode=1216 ** Cannot add or
update a child row: a foreign key constraint fails]"]
)

Do you mean 'default location type' ? If so, it doesnt have any space (its just 'Work')

However, I noticed that I am unable to syncrhronize users to contacts either

 [message] => DB Error: already exists
    [mode] => 16
    [debug_info] => INSERT INTO civicrm_uf_match (uf_id , contact_id , domain_id , email ) VALUES ( 14 ,  104 ,  1 , 'barnyveep@yahoo.co.in' )  [nativecode=1062 ** Duplicate entry '104' for key 2)

Related errors maybe?

-v

p.s the system has been live for 5 months..so..these errors are new