DB Error: constraint violation

[emmy]

Hi

I added custom field to civievent for users registering to have an option of choosing between two offers.

Am currently running Drupal 7 and civicrm 4.2.0

I added custom field to civievent for users registering to have an option of choosing between two offers.

I did this through the use of profiles as I was advised from a forum post and everything worked brilliant.

The problem or error came about when a user tries to register for an the event and selects the between the two field option.

A blank page is returned with an error:

Sorry but we are not able to provide this at the moment.
DB Error: constraint violation
Return to home page.

Error details:
=> -3
     [message] => DB Error: constraint violation
     [mode] => 16
     [debug_info] => INSERT INTO civicrm_value_volunteer_type_11  ( select_volunteer_type_13,entity_id ) VALUES ( '12',104 ) ON DUPLICATE KEY UPDATE select_volunteer_type_13 = '12' [nativecode=1452 ** Cannot add or update a child row: a foreign key constraint fails (`db1114980_drupal7_tgh_civicrm`.`civicrm_value_volunteer_type_11`, CONSTRAINT `FK_civicrm_value_volunteer_type_11_entity_id` FOREIGN KEY (`entity_id`) REFERENCES `civicrm_participant` (`id`) O)]
     [type] => DB_Error
     [user_info] => INSERT INTO civicrm_value_volunteer_type_11  ( select_volunteer_type_13,entity_id ) VALUES ( '12',104 ) ON DUPLICATE KEY UPDATE select_volunteer_type_13 = '12' [nativecode=1452 ** Cannot add or update a child row: a foreign key constraint fails (`db1114980_drupal7_tgh_civicrm`.`civicrm_value_volunteer_type_11`, CONSTRAINT `FK_civicrm_value_volunteer_type_11_entity_id` FOREIGN KEY (`entity_id`) REFERENCES `civicrm_participant` (`id`) O)]
     [to_string] => [db_error: message="DB Error: constraint violation" code=-3 mode=callback callback=CRM_Core_Error::handle prefix="" info="INSERT INTO civicrm_value_volunteer_type_11  ( select_volunteer_type_13,entity_id ) VALUES ( '12',104 ) ON DUPLICATE KEY UPDATE select_volunteer_type_13 = '12' [nativecode=1452 ** Cannot add or update a child row: a foreign key constraint fails (`db1114980_test_tgh_civicrm`.`civicrm_value_volunteer_type_11`, CONSTRAINT `FK_civicrm_value_volunteer_type_11_entity_id` FOREIGN KEY (`entity_id`) REFERENCES `civicrm_participant` (`id`) O)]"]
)

[emmy]

Hi everyone

I found this link and it could be helpful to someone else out there.

I found it very useful: http://forum.civicrm.org/index.php?topic=26300.0

Cheers