CiviCRM Community Forums (archive)

I've set up an event where it is possible to register multiple participants. I tested the registration by entering 2 participants and saying I'll pay later. I enter both participants' info. When I continue beyond the summary page I receive the following error message. Any ideas on what the problem is?

Sorry. A non-recoverable error has occurred.

DB Error: constraint violation

Database Error Code: Cannot add or update a child row: a foreign key constraint fails (`civicrm/civicrm_value_bingham_cup_2010_12`, CONSTRAINT `FK_civicrm_value_bingham_cup_2010_12_entity_id` FOREIGN KEY (`entity_id`) REFERENCES `civicrm_contact` (`id`) ON DELETE CASCADE), 1452

Return to home page.

Error Details:


Array
(
    [callback] => Array
        (
           

• => CRM_Core_Error
[1] => handle
        )

   

=> -3
    [message] => DB Error: constraint violation
    [mode] => 16
    [debug_info] => INSERT INTO civicrm_value_bingham_cup_2010_12  ( i_am_a_playing_in_the_2010_bingh_50,i_will_have_appropriate_insuranc_52,exact_legal_name_displayed_on_go_51,room_sharing_54,entity_id ) VALUES ( 0,0,'','',310 ) ON DUPLICATE KEY UPDATE i_am_a_playing_in_the_2010_bingh_50 = 0,i_will_have_appropriate_insuranc_52 = 0,exact_legal_name_displayed_on_go_51 = '',room_sharing_54 = '' [nativecode=1452 ** Cannot add or update a child row: a foreign key constraint fails (`civicrm/civicrm_value_bingham_cup_2010_12`, CONSTRAINT `FK_civicrm_value_bingham_cup_2010_12_entity_id` FOREIGN KEY (`entity_id`) REFERENCES `civicrm_contact` (`id`) ON DELETE CASCADE)]
    [type] => DB_Error
    [user_info] => INSERT INTO civicrm_value_bingham_cup_2010_12  ( i_am_a_playing_in_the_2010_bingh_50,i_will_have_appropriate_insuranc_52,exact_legal_name_displayed_on_go_51,room_sharing_54,entity_id ) VALUES ( 0,0,'','',310 ) ON DUPLICATE KEY UPDATE i_am_a_playing_in_the_2010_bingh_50 = 0,i_will_have_appropriate_insuranc_52 = 0,exact_legal_name_displayed_on_go_51 = '',room_sharing_54 = '' [nativecode=1452 ** Cannot add or update a child row: a foreign key constraint fails (`civicrm/civicrm_value_bingham_cup_2010_12`, CONSTRAINT `FK_civicrm_value_bingham_cup_2010_12_entity_id` FOREIGN KEY (`entity_id`) REFERENCES `civicrm_contact` (`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_value_bingham_cup_2010_12  ( i_am_a_playing_in_the_2010_bingh_50,i_will_have_appropriate_insuranc_52,exact_legal_name_displayed_on_go_51,room_sharing_54,entity_id ) VALUES ( 0,0,'','',310 ) ON DUPLICATE KEY UPDATE i_am_a_playing_in_the_2010_bingh_50 = 0,i_will_have_appropriate_insuranc_52 = 0,exact_legal_name_displayed_on_go_51 = '',room_sharing_54 = '' [nativecode=1452 ** Cannot add or update a child row: a foreign key constraint fails (`civicrm/civicrm_value_bingham_cup_2010_12`, CONSTRAINT `FK_civicrm_value_bingham_cup_2010_12_entity_id` FOREIGN KEY (`entity_id`) REFERENCES `civicrm_contact` (`id`) ON DELETE CASCADE)]"]



We are on the most recent version of CiviCRM. There is no custom group.

The custom profiles we are using in the registration consist of individual, participant and contact fields. Does this help? Do you need more information?

I have a profile that consists of 6 fields. 4 are participant fields; 2 are individual fields. Is there a problem with using this profile in the event definition.

Thank you. I managed to overcome the problem by

1. creating a custom data group, where Used for is "Event name" and the value of event name is the name of the event that the group was created for
2. creating a corresponding profile, x
2. in the event definition, I added this profile x as Include profile (top of page) and the profile containing individual attributes (first name, last name etc) as Include profile (top of page)

I tested this and it worked. Problem is, when I then look at settings on custom data x, I get the following warning. Any idea what I've done wrong?

warning: array_intersect() [function.array-intersect]: Argument #2 is not an array in /var/www/drupal/sites/all/modules/civicrm/CRM/Custom/Form/Group.php on line 309.

In addition, can you point me to examples of creating custom data groups where Used for is Participants, Participants (Event Name), Participants (Event Type), Participants (Role)? I'd like to know when to use one vs the other.

...not sure if this is related or not, but in CiviEvent we've had random errors being thrown because of 'non-standard' characters being used in event description fields. Now we know to clean up the copy when an error occurs...and the errors go away. Perhaps yet another issue with CKEditor?

Hi,

We've had another case, on another 3.1.3 site, of a table for a custom group having a foreign key constraint to the wrong table for entity_id.

mysql> select id, table_name, extends from civicrm_custom_group where id = 5;
+----+----------------------------+--------------+
| id | table_name                 | extends      |
+----+----------------------------+--------------+
|  5 | civicrm_value_eoi_review_5 | Organization |
+----+----------------------------+--------------+

Constraint was:
CONSTRAINT `FK_civicrm_value_eoi_review_5_entity_id` FOREIGN KEY (`entity_id`) REFERENCES `civicrm_activity` (`id`) ON DELETE CASCADE

Should be:
CONSTRAINT `FK_civicrm_value_eoi_review_5_entity_id` FOREIGN KEY (`entity_id`) REFERENCES `civicrm_contact` (`id`) ON DELETE CASCADE

There's a bug there somewhere. Unlike the case in my previous post above, there's no funny business going on with the FK name here.

Dave J