CiviCRM Community Forums (archive)

I posted previously about errors appearing in civimail here: http://forum.civicrm.org/index.php/topic,5940.0.html and thought that the problem was solved.  The problem with civimail was solved but now I have a new error when deleting a contact.

    Sorry. A non-recoverable error has occurred.

    DB Error: constraint violation

    Return to home page.

Error Details:

Array
(
    [callback] => Array
        (
           

• => CRM_Core_Error
[1] => handle
        )

   

Code: [Select]

=> -3
    [message] => DB Error: constraint violation
    [mode] => 16
    [debug_info] => DELETE FROM civicrm_contact  WHERE (  civicrm_contact.id = 1660 )  [nativecode=1451 ** Cannot delete or update a parent row: a foreign key constraint fails (`mydb/civicrm_individual`, CONSTRAINT `FK_civicrm_individual_contact_id` FOREIGN KEY (`contact_id`) REFERENCES `civicrm_contact` (`id`))]
    [type] => DB_Error
    [user_info] => DELETE FROM civicrm_contact  WHERE (  civicrm_contact.id = 1660 )  [nativecode=1451 ** Cannot delete or update a parent row: a foreign key constraint fails (`mydb/civicrm_individual`, CONSTRAINT `FK_civicrm_individual_contact_id` FOREIGN KEY (`contact_id`) REFERENCES `civicrm_contact` (`id`))]
    [to_string] => [db_error: message="DB Error: constraint violation" code=-3 mode=callback callback=CRM_Core_Error::handle prefix="" info="DELETE FROM civicrm_contact  WHERE (  civicrm_contact.id = 1660 )  [nativecode=1451 ** Cannot delete or update a parent row: a foreign key constraint fails (`mydb/civicrm_individual`, CONSTRAINT `FK_civicrm_individual_contact_id` FOREIGN KEY (`contact_id`) REFERENCES `civicrm_contact` (`id`))]"]
)


To find the specific errors I entered this query:
SELECT civicrm_individual.first_name, civicrm_individual.last_name, civicrm_individual.id
FROM civicrm_individual
LEFT JOIN civicrm_contact ON ( civicrm_individual.contact_id = civicrm_contact.id )
WHERE civicrm_individual.id IS NOT NULL
AND civicrm_contact.id IS NULL;
... and found 114 rows in the civicrm_individual table with no corresponding row in the civicrm_contact table.  My questions are,
1.  How does that happen?
2.  Can I just recreate the missing 114 civicm_contact rows to match the civicrm_individual table or will I hit other constraints and/or inconsistencies?
3.  Is there some better method to fix it?

Thanks for any assistance.

Edit: oh, and 6 households and 74 organizations, too!

The civicrm_individual table should not exist in db's >= v2.0

not sure how it exists in your db/schema. We dropped the table in the upgrade for 2.0 (in case u upgraded)

there will be a difference betwen the two table (contact and individual) since the latter is not updated

lobo

Is there a handy list of tables that got dropped between 1.x and 2.x in your documentation somewhere?

You might want to check "Schema redesign" section on http://wiki.civicrm.org/confluence/display/CRM/CiviCRM+v2.0

Kurund