CiviCRM Community Forums (archive)

I am using Drupal 5 and CiviCRM 1.9 PHP5.

I just installed civicrm, and accidentally had it install all of the Sample data that comes with it.

No big deal I thought.  I'll just delete the sample data.  So, I Listed All contacts (that are not CMS users) and selected the "Delete Contacts" action and hit "Go". Here's what I got.

> Deleted Contacts: 100

> Total Selected Contacts: 101

I have tried many times to delete the "Inner City Arts" sample contact with NO success, and No error message.

I really need help troubleshooting and deleting this contact.

Thanks   

-Stephen

Hello, I had this same problem and deleted the membership types as advised.  After doing so, I tried to delete Inner City Arts once again and now got an error:

     Sorry. A non-recoverable error has occurred.

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

    Return to home page.

Error Details:

Code: [Select]

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

    [code] => -1
    [message] => DB Error: unknown error
    [mode] => 16
    [debug_info] => DELETE FROM civicrm_contact  WHERE (  civicrm_contact.id = 1 )  [nativecode=1451 ** Cannot delete or update a parent row: a foreign key constraint fails (`nation17_civicrm/civicrm_note`, CONSTRAINT `FK_civicrm_note_contact_id` FOREIGN KEY (`contact_id`) REFERENCES `civicrm_contact` (`id`))]
    [type] => DB_Error
    [user_info] => DELETE FROM civicrm_contact  WHERE (  civicrm_contact.id = 1 )  [nativecode=1451 ** Cannot delete or update a parent row: a foreign key constraint fails (`nation17_civicrm/civicrm_note`, CONSTRAINT `FK_civicrm_note_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 = 1 )  [nativecode=1451 ** Cannot delete or update a parent row: a foreign key constraint fails (`nation17_civicrm/civicrm_note`, CONSTRAINT `FK_civicrm_note_contact_id` FOREIGN KEY (`contact_id`) REFERENCES `civicrm_contact` (`id`))]"]
)

[/code]