CiviCRM Community Forums (archive)

Might want to read the user guide at http://book.civicrm.org/

You can add more fields via profiles.

If you dont like where they are placed, you can create a custom template and move things around

lobo

Hi Donald and Erik, Thank you so much for the advice. I have done what the book suggested and I got those fields to the registration form.
As you guys said, I created a set of custom fields and added them to CiviCRM profile.  But now I ran into another issue.
Now when I try to register for an event (by selecting the custom data) I get a database error

Database Error Code: Cannot add or update a child row: a foreign key constraint fails (`cdrcp_joomla`.`civicrm_value_additional_event_registration_13`, CONSTRAINT `FK_civicrm_value_additional_event_r_4d1eecb391c27197` FOREIGN KEY (`entity_id`) REFERENCES `civicrm_event` (`id`), 1452
Array
(
    [callback] => Array
        (
            [0] => CRM_Core_Error
            [1] => handle
        )

    [ 'code] => -3
    [message] => DB Error: constraint violation
    [mode] => 16
    [debug_info] => INSERT INTO civicrm_value_additional_event_registration_13  ( are_you_a_35,if_other_then_please_specify_36,are_you_with_a_37,if_other_then_please_specify_you_38,is_your_organization_39,other_40,entity_id ) VALUES ( '
Parent
','','
Licensed Child Care Centre
','','Non-Profit','',44251 ) ON DUPLICATE KEY UPDATE are_you_a_35 = '
Parent
',if_other_then_please_specify_36 = '',are_you_with_a_37 = '
Licensed Child Care Centre
',if_other_then_please_specify_you_38 = '',is_your_organization_39 = 'Non-Profit',other_40 = '' [nativecode=1452 ** Cannot add or update a child row: a foreign key constraint fails (`cdrcp392_joomla`.`civicrm_value_additional_event_registration_13`, CONSTRAINT `FK_civicrm_value_additional_event_r_4d1eecb391c27197` FOREIGN KEY (`entity_id`) REFERENCES `civicrm_event` (`id`)]
    [type] => DB_Error
    [user_info] => INSERT INTO civicrm_value_additional_event_registration_13  ( are_you_a_35,if_other_then_please_specify_36,are_you_with_a_37,if_other_then_please_specify_you_38,is_your_organization_39,other_40,entity_id ) VALUES ( '
Parent
','','
Licensed Child Care Centre
','','Non-Profit','',44251 ) ON DUPLICATE KEY UPDATE are_you_a_35 = '
Parent
',if_other_then_please_specify_36 = '',are_you_with_a_37 = '
Licensed Child Care Centre
',if_other_then_please_specify_you_38 = '',is_your_organization_39 = 'Non-Profit',other_40 = '' [nativecode=1452 ** Cannot add or update a child row: a foreign key constraint fails (`cdrcp392_joomla`.`civicrm_value_additional_event_registration_13`, CONSTRAINT `FK_civicrm_value_additional_event_r_4d1eecb391c27197` FOREIGN KEY (`entity_id`) REFERENCES `civicrm_event` (`id`)]
    [to_string] => [db_error: message="DB Error: constraint violation" code=-3 mode=callback callback=CRM_Core_Error::handle prefix="" info="INSERT INTO civicrm_value_additional_event_registration_13  ( are_you_a_35,if_other_then_please_specify_36,are_you_with_a_37,if_other_then_please_specify_you_38,is_your_organization_39,other_40,entity_id ) VALUES ( '
Parent
','','
Licensed Child Care Centre
','','Non-Profit','',44251 ) ON DUPLICATE KEY UPDATE are_you_a_35 = '
Parent
',if_other_then_please_specify_36 = '',are_you_with_a_37 = '
Licensed Child Care Centre
',if_other_then_please_specify_you_38 = '',is_your_organization_39 = 'Non-Profit',other_40 = '' [nativecode=1452 ** Cannot add or update a child row: a foreign key constraint fails (`cdrcp392_joomla`.`civicrm_value_additional_event_registration_13`, CONSTRAINT `FK_civicrm_value_additional_event_r_4d1eecb391c27197` FOREIGN KEY (`entity_id`) REFERENCES `civicrm_event` (`id`)]"]
)


did u modify your event custom group to participant custom group? how did u do it, via the UI or directly in the DB?

also can u repeat the same experiment and create a new particpant group.

lobo

Hi Donald,
Did you mean when I create the custom set of fields, did I update that set from event to participant? if so, yes I did that and I did that using the UI.

What do you mean by creating a new participant group? Sorry I didn't get that