CiviCRM Community Forums (archive)

I just completed the upgarde to CiviCRM 3.1.3 and Drupal 6.16 with no errors. I had the issue documented below before I upgraded but waited for the upgrade to complete to see if things would fix themselves with the updates, sadly I am still getting this error.

The Price Set in question, was created for a test event to see how the functionality works. Once we completed the test, the event was deleted and when attempting to delete the Price set I get the following errors:

First I get this error:

Sorry. A non-recoverable error has occurred.

DB Error: constraint violation

Database Error Code: Cannot delete or update a parent row: a foreign key constraint fails (`wwbpay_civicrm/civicrm_price_set_entity`, CONSTRAINT `FK_civicrm_price_set_entity_price_set_id` FOREIGN KEY (`price_set_id`) REFERENCES `civicrm_price_set` (`id`)), 1451

Followed by:

Error Details:

Array
(
    [callback] => Array
        (
           

• => CRM_Core_Error
[1] => handle
        )

   

=> -3
    [message] => DB Error: constraint violation
    [mode] => 16
    [debug_info] => DELETE FROM civicrm_price_set  WHERE (  civicrm_price_set.id = 1 )  [nativecode=1451 ** Cannot delete or update a parent row: a foreign key constraint fails (`wwbpay_civicrm/civicrm_price_set_entity`, CONSTRAINT `FK_civicrm_price_set_entity_price_set_id` FOREIGN KEY (`price_set_id`) REFERENCES `civicrm_price_set` (`id`))]
    [type] => DB_Error
    [user_info] => DELETE FROM civicrm_price_set  WHERE (  civicrm_price_set.id = 1 )  [nativecode=1451 ** Cannot delete or update a parent row: a foreign key constraint fails (`wwbpay_civicrm/civicrm_price_set_entity`, CONSTRAINT `FK_civicrm_price_set_entity_price_set_id` FOREIGN KEY (`price_set_id`) REFERENCES `civicrm_price_set` (`id`))]
    [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=1451 ** Cannot delete or update a parent row: a foreign key constraint fails (`wwbpay_civicrm/civicrm_price_set_entity`, CONSTRAINT `FK_civicrm_price_set_entity_price_set_id` FOREIGN KEY (`price_set_id`) REFERENCES `civicrm_price_set` (`id`))]"]
)