CiviCRM Community Forums (archive)

I'm dealing with a problem where out of 50k contacts in civicrm, there are 413 that have locations, but none of these locations are marked as primary.  These can be listed with the following query:

SELECT *
FROM (
  SELECT DISTINCT entity_id
  FROM civicrm_location
  WHERE is_primary = 0) AS np
LEFT JOIN (
  SELECT DISTINCT entity_id
  FROM civicrm_location
  WHERE is_primary = 1) AS p
on np.entity_id = p.entity_id
WHERE p.entity_id IS NULL;

This causes problems when you attempt to edit the drupal record for the contact.  civicrm will attempt to update the primary email for the primary address for the contact, if there's no primary address it fails with the following 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 Details:

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

    [code_] => -3
    [message] => DB Error: constraint violation
    [mode] => 16
    [debug_info] => INSERT INTO civicrm_email (email , is_primary ) VALUES
('multimedia@bioneers.org' ,  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
('multimedia@bioneers.org' ,  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 ('multimedia@bioneers.org' ,
1 )  [nativecode=1216 ** Cannot add or update a child row: a foreign key
constraint fails]"]
)

Has anyone else experienced this?