search

zengenuity / civicrm_groupprice

CiviCRM extension that allows you to limit the display of individual prices in price sets to specific groups. This can be used to implement members-only pricing for events, as well as other use cases.
Other
3 stars 9 forks source link

Constraint Violation Errors #10

Open sleewok opened 5 years ago

sleewok commented 5 years ago

We are unable to delete any of the price options, custom fields, or price set with a group price set. Any ideas? We get the following error:

civicrm: $Fatal 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_field_value WHERE ( civicrm_price_field_value.id = 156 ) [nativecode=1451 Cannot delete or update a parent row: a foreign key constraint fails (vinenamelessnetw.civicrm_groupprice, CONSTRAINT civicrm_groupprice_ibfk_1 FOREIGN KEY (oid) REFERENCES civicrm_price_field_value (id))] [type] => DB_Error [user_info] => DELETE FROM civicrm_price_field_value WHERE ( civicrm_price_field_value.id = 156 ) [nativecode=1451 Cannot delete or update a parent row: a foreign key constraint fails (vinenamelessnetw.civicrm_groupprice, CONSTRAINT civicrm_groupprice_ibfk_1 FOREIGN KEY (oid) REFERENCES civicrm_price_field_value (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_field_value WHERE ( civicrm_price_field_value.id = 156 ) [nativecode=1451 ** Cannot delete or update a parent row: a foreign key constraint fails (vinenamelessnetw.civicrm_groupprice, CONSTRAINT civicrm_groupprice_ibfk_1 FOREIGN KEY (oid) REFERENCES civicrm_price_field_value (id))]"] )