CiviCRM Community Forums (archive)

I was just playing with price sets and I got the following error when trying to delete one:


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 CiviCRM menu.

Error Details:

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

    [code] => -3
    [message] => DB Error: constraint violation
    [mode] => 16
    [debug_info] => DELETE FROM civicrm_price_set  WHERE (  civicrm_price_set.id = 1 )  [nativecode=1217 ** Cannot delete or update a parent row: a foreign key constraint fails]
    [type] => db_error
    [user_info] => DELETE FROM civicrm_price_set  WHERE (  civicrm_price_set.id = 1 )  [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_price_set  WHERE (  civicrm_price_set.id = 1 )  [nativecode=1217 ** Cannot delete or update a parent row: a foreign key constraint fails]"]
)
I successfully deleted other price sets just before that one. 

By the way, using 1.8 alpha.[/code]