CiviCRM Community Forums (archive)

Using Drupal 5.1 and the lastest version of civiCRM

I tried to delete 4 of the sample data members, and got a 500 error.  I refreshed and 3 were gone, but the one that was left won;t go away...

I get this message:

Sorry. A non-recoverable error has occurred.

Database Error Code: Cannot delete or update a parent row: a foreign key constraint fails (`db207651746/civicrm_membership`, CONSTRAINT `FK_civicrm_membership_owner_membership_id` FOREIGN KEY (`owner_membership_id`) REFE, 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_membership  WHERE (  civicrm_membership.id = 23 )  [nativecode=1451 ** Cannot delete or update a parent row: a foreign key constraint fails (`db207651746/civicrm_membership`, CONSTRAINT `FK_civicrm_membership_owner_membership_id` FOREIGN KEY (`owner_membership_id`) REFE]
    [type] => db_error
    [user_info] => DELETE FROM civicrm_membership  WHERE (  civicrm_membership.id = 23 )  [nativecode=1451 ** Cannot delete or update a parent row: a foreign key constraint fails (`db207651746/civicrm_membership`, CONSTRAINT `FK_civicrm_membership_owner_membership_id` FOREIGN KEY (`owner_membership_id`) REFE]
    [to_string] => [db_error: message="DB Error: unknown error" code=-1 mode=callback callback=CRM_Core_Error::handle prefix="" info="DELETE FROM civicrm_membership  WHERE (  civicrm_membership.id = 23 )  [nativecode=1451 ** Cannot delete or update a parent row: a foreign key constraint fails (`db207651746/civicrm_membership`, CONSTRAINT `FK_civicrm_membership_owner_membership_id` FOREIGN KEY (`owner_membership_id`) REFE]"]
)


Any ideas?

I tried that already.. it is enabled.