CiviCRM Community Forums (archive)

hello,

when I try to delete a single contact, I get this error message:


unrecovable error:


    database-errorcode: Cannot delete or update a parent row: a foreign key constraint fails (`civicrm2/civicrm_individual`, CONSTRAINT `FK_civicrm_individual_contact_id` FOREIGN KEY (`contact_id`) REFERENCES `civicrm_contact` (`id`)), 1451

    Return to home page.

Error Details:

Array
(
    [callback] => Array
        (
           

• => CRM_Core_Error
[1] => handle
        )

   

=> -1
    [message] => DB Error: unknown error
    [mode] => 16
    [debug_info] => DELETE FROM civicrm_contact  WHERE (  civicrm_contact.id = 43967 )  [nativecode=1451 ** Cannot delete or update a parent row: a foreign key constraint fails (`civicrm2/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 = 43967 )  [nativecode=1451 ** Cannot delete or update a parent row: a foreign key constraint fails (`civicrm2/civicrm_individual`, CONSTRAINT `FK_civicrm_individual_contact_id` FOREIGN KEY (`contact_id`) REFERENCES `civicrm_contact` (`id`))]
    [to_string] => [db_error: message="DB Error: unknown error" code=-1 mode=callback callback=CRM_Core_Error::handle prefix="" info="DELETE FROM civicrm_contact  WHERE (  civicrm_contact.id = 43967 )  [nativecode=1451 ** Cannot delete or update a parent row: a foreign key constraint fails (`civicrm2/civicrm_individual`, CONSTRAINT `FK_civicrm_individual_contact_id` FOREIGN KEY (`contact_id`) REFERENCES `civicrm_contact` (`id`))]"]
)

backTrace

/var/www/civicrm2/sites/all/modules/civicrm/CRM/Core/Error.php, backtrace, 148
, handle,
/var/www/civicrm2/sites/all/modules/civicrm/packages/PEAR.php, call_user_func, 901
/var/www/civicrm2/sites/all/modules/civicrm/packages/DB.php, PEAR_Error, 888
/var/www/civicrm2/sites/all/modules/civicrm/packages/PEAR.php, DB_Error, 563
/var/www/civicrm2/sites/all/modules/civicrm/packages/DB/common.php, raiseError, 1849
/var/www/civicrm2/sites/all/modules/civicrm/packages/DB/mysql.php, raiseError, 894
/var/www/civicrm2/sites/all/modules/civicrm/packages/DB/mysql.php, mysqlRaiseError, 324
/var/www/civicrm2/sites/all/modules/civicrm/packages/DB/common.php, simpleQuery, 1162
/var/www/civicrm2/sites/all/modules/civicrm/packages/DB/DataObject.php, query, 2343
/var/www/civicrm2/sites/all/modules/civicrm/packages/DB/DataObject.php, _query, 1394
/var/www/civicrm2/sites/all/modules/civicrm/CRM/Contact/BAO/Contact.php, delete, 999
/var/www/civicrm2/sites/all/modules/civicrm/CRM/Contact/Form/Task/Delete.php, deleteContact, 114
/var/www/civicrm2/sites/all/modules/civicrm/CRM/Core/QuickForm/Action/Done.php, postProcess, 79
/var/www/civicrm2/sites/all/modules/civicrm/packages/HTML/QuickForm/Controller.php, perform, 195
/var/www/civicrm2/sites/all/modules/civicrm/packages/HTML/QuickForm/Page.php, handle, 95
/var/www/civicrm2/sites/all/modules/civicrm/CRM/Core/Controller.php, handle, 223
/var/www/civicrm2/sites/all/modules/civicrm/CRM/Core/Invoke.php, run, 540
/var/www/civicrm2/sites/all/modules/civicrm/CRM/Core/Invoke.php, search, 435
/var/www/civicrm2/sites/all/modules/civicrm/CRM/Core/Invoke.php, contact, 98
/var/www/civicrm2/sites/all/modules/civicrm/drupal/civicrm.module, invoke, 329
, civicrm_invoke,
/var/www/civicrm2/includes/menu.inc, call_user_func_array, 418
/var/www/civicrm2/index.php, menu_execute_active_handler, 15

Thank you for any hint.

Also, if using ACLs, try emptying your _acl_cache table. This solved this problem for me after one upgrade.

Did you successfully run the section of the upgrade instructions which covers "Ensuring Schema Integrity" ...
http://wiki.civicrm.org/confluence/display/CRMDOC/Upgrade+Drupal+Sites+to+2.0#UpgradeDrupalSitesto2.0-4.Rebuildyour1.9DatabasetoEnsureSchemaIntegrity

If not, your best bet is to run through those steps using a copy of your 1.9 database. Then download 2.0.4 (which has some upgrade-related fixes) and run the upgrade script again.