CiviCRM Community Forums (archive)

I have the latest civicrm installed on drupal and it is mostly working great.  However I get errors while trying to delete the sample data records.  Sometimes it works, but most of the time when I try to delete a contact this error occurs.

     Sorry. A non-recoverable error has occurred.

    Database Error Code: Cannot delete or update a parent row: a foreign key constraint fails (`yfcdb/civicrm_membership`, CONSTRAINT `FK_civicrm_membership_contact_id` FOREIGN KEY (`contact_id`) REFERENCES `civicrm_contact` (`id`)), 1451

    Return to CiviCRM menu.

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 = 26 )  [nativecode=1451 ** Cannot delete or update a parent row: a foreign key constraint fails (`yfcdb/civicrm_membership`, CONSTRAINT `FK_civicrm_membership_contact_id` FOREIGN KEY (`contact_id`) REFERENCES `civicrm_contact` (`id`))]
    [type] => DB_Error
    [user_info] => DELETE FROM civicrm_contact  WHERE (  civicrm_contact.id = 26 )  [nativecode=1451 ** Cannot delete or update a parent row: a foreign key constraint fails (`yfcdb/civicrm_membership`, CONSTRAINT `FK_civicrm_membership_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 = 26 )  [nativecode=1451 ** Cannot delete or update a parent row: a foreign key constraint fails (`yfcdb/civicrm_membership`, CONSTRAINT `FK_civicrm_membership_contact_id` FOREIGN KEY (`contact_id`) REFERENCES `civicrm_contact` (`id`))]"]
)


This is running on a new ubuntu server, if that matters, with software as follows -

PHP 5.1.6 (cli) (built: Apr 25 2007 14:27:06)
Copyright (c) 1997-2006 The PHP Group
Zend Engine v2.1.0, Copyright (c) 1998-2006 Zend Technologies

mysql  Ver 14.12 Distrib 5.0.24a, for pc-linux-gnu (i486) using readline 5.1

drupal version 5.1

civicrm-1.7.beta.9327-drupal-php5.tar.gz

Everything else looks great.  Thanks.



That did it.  Thank you.