CiviCRM Community Forums (archive)

Hi there,

I have just tried to delete an organic group in Drupal with the following error... any ideas?

Thanks

Are you sure you want to delete Marketing Team for Social Ecology?

unrecoverable error
    Sorry. A non-recoverable error has occurred.

    Database Error Code: Cannot delete or update a parent row: a foreign key constraint fails, 1217

    Return to home page.

Error Details:

Array
(
    [callback] => Array
        (
           

• => CRM_Core_Error
[1] => handle
        )

   

=> -3
    [message] => DB Error: constraint violation
    [mode] => 16
    [debug_info] => DELETE FROM civicrm_acl  WHERE (  civicrm_acl.domain_id = 1 )  AND (  civicrm_acl.object_table  = 'civicrm_saved_search' ) AND (  civicrm_acl.object_id = 7 ) [nativecode=1217 ** Cannot delete or update a parent row: a foreign key constraint fails]
    [type] => DB_Error
    [user_info] => DELETE FROM civicrm_acl  WHERE (  civicrm_acl.domain_id = 1 )  AND (  civicrm_acl.object_table  = 'civicrm_saved_search' ) AND (  civicrm_acl.object_id = 7 ) [nativecode=1217 ** Cannot delete or update a parent row: a foreign key constraint fails]
    [to_string] => [db_error: message="DB Error: constraint violation" code=-3 mode=callback callback=CRM_Core_Error::handle prefix="" info="DELETE FROM civicrm_acl  WHERE (  civicrm_acl.domain_id = 1 )  AND (  civicrm_acl.object_table  = 'civicrm_saved_search' ) AND (  civicrm_acl.object_id = 7 ) [nativecode=1217 ** Cannot delete or update a parent row: a foreign key constraint fails]"]
)