CiviCRM Community Forums (archive)

I am using CiviCRM 4.2.0 (Stable) on Wordpress 3.4.1.  When I try to process a contribution, I am getting a DB Error:  constraint violation message with the following details:

Database Error Code: Cannot add or update a child row: a foreign key constraint fails (`mydbname_civicrm`.`civicrm_line_item`, CONSTRAINT `FK_civicrm_line_item_price_field_id` FOREIGN KEY (`price_field_id`) REFERENCES `civicrm_price_field` (`id`) ON DELETE CASCADE), 1452
Additional Details:
Array
(
    [callback] => Array
        (
           

• => CRM_Core_Error
[1] => handle
        )

   

Code: [Select]

=> -3
    [message] => DB Error: constraint violation
    [mode] => 16
    [debug_info] => INSERT INTO civicrm_line_item (entity_table , entity_id , unit_price , line_total ) VALUES ('civicrm_contribution' ,  105 ,  5.00 ,  5.00 )  [nativecode=1452 ** Cannot add or update a child row: a foreign key constraint fails (`mydbname_civicrm`.`civicrm_line_item`, CONSTRAINT `FK_civicrm_line_item_price_field_id` FOREIGN KEY (`price_field_id`) REFERENCES `civicrm_price_field` (`id`) ON DELETE CASCADE)]
    [type] => DB_Error
    [user_info] => INSERT INTO civicrm_line_item (entity_table , entity_id , unit_price , line_total ) VALUES ('civicrm_contribution' ,  105 ,  5.00 ,  5.00 )  [nativecode=1452 ** Cannot add or update a child row: a foreign key constraint fails (`mydbname_civicrm`.`civicrm_line_item`, CONSTRAINT `FK_civicrm_line_item_price_field_id` FOREIGN KEY (`price_field_id`) REFERENCES `civicrm_price_field` (`id`) ON DELETE CASCADE)]
    [to_string] => [db_error: message="DB Error: constraint violation" code=-3 mode=callback callback=CRM_Core_Error::handle prefix="" info="INSERT INTO civicrm_line_item (entity_table , entity_id , unit_price , line_total ) VALUES ('civicrm_contribution' ,  105 ,  5.00 ,  5.00 )  [nativecode=1452 ** Cannot add or update a child row: a foreign key constraint fails (`mydbname_civicrm`.`civicrm_line_item`, CONSTRAINT `FK_civicrm_line_item_price_field_id` FOREIGN KEY (`price_field_id`) REFERENCES `civicrm_price_field` (`id`) ON DELETE CASCADE)]"]
)
[/quote]

I need help ASAP.  THis is a live site.

Actually, no, I do not believe I did.  At least not intentionally!

Site has gone through several upgrades.  I am not sure which upgrade broke the site, but I would say all was well up until at least 4.2 Beta 1.  Can you suggest a patch to fix this.  I am not quite sure how to recreate this in the demo, since the Price Sets were already defined when the upgrades were done.  So creating new Price Sets in the demo would not be a true recreation of my situation.

Ok.  So when I submit a donation using one of the Price Set options, the page processes fine.  However, if I choose to enter my own different amount, then I get the error.
Is there a way for me to save just my data, and do a complete new install, and then re-install the data to a new installation of Civi?