CiviCRM Community Forums (archive)

can you reproduce this on the demo machine and if so, please file an issue. we'll fix it for a future release: 3.4 or later

note that if you want this for 3.3, u'll need to backport the patch from the repository. (click on the Fisheye link in the issue once its closed)

lobo

I changed the live paymennt processor to PP Standard, and managed to get to the PayPal main page a couple of times. Now, the registration is failing as before. However, this time when I copied the backtrace error data, it is more complete and my give additional insight to what is causing the problem (I hope):

backTrace

/home/famcafe/public_html/administrator/components/com_civicrm/civicrm/CRM/Core/Error.php, backtrace, 159
, handle,
/home/famcafe/public_html/administrator/components/com_civicrm/civicrm/packages/PEAR.php, call_user_func, 931
/home/famcafe/public_html/administrator/components/com_civicrm/civicrm/packages/DB.php, PEAR_Error, 968
/home/famcafe/public_html/administrator/components/com_civicrm/civicrm/packages/PEAR.php, DB_Error, 564
/home/famcafe/public_html/administrator/components/com_civicrm/civicrm/packages/DB/common.php, raiseError, 1903
/home/famcafe/public_html/administrator/components/com_civicrm/civicrm/packages/DB/mysql.php, raiseError, 898
/home/famcafe/public_html/administrator/components/com_civicrm/civicrm/packages/DB/mysql.php, mysqlRaiseError, 327
/home/famcafe/public_html/administrator/components/com_civicrm/civicrm/packages/DB/common.php, simpleQuery, 1216
/home/famcafe/public_html/administrator/components/com_civicrm/civicrm/packages/DB/DataObject.php, query, 2421
/home/famcafe/public_html/administrator/components/com_civicrm/civicrm/packages/DB/DataObject.php, _query, 1607
/home/famcafe/public_html/administrator/components/com_civicrm/civicrm/CRM/Core/DAO.php, query, 145
/home/famcafe/public_html/administrator/components/com_civicrm/civicrm/CRM/Core/DAO.php, query, 868
/home/famcafe/public_html/administrator/components/com_civicrm/civicrm/CRM/Core/BAO/CustomValueTable.php, executeQuery, 224
/home/famcafe/public_html/administrator/components/com_civicrm/civicrm/CRM/Core/BAO/CustomValueTable.php, create, 322
/home/famcafe/public_html/administrator/components/com_civicrm/civicrm/CRM/Contact/BAO/Contact.php, store, 376
/home/famcafe/public_html/administrator/components/com_civicrm/civicrm/CRM/Contact/BAO/Contact.php, create, 1742
/home/famcafe/public_html/administrator/components/com_civicrm/civicrm/CRM/Event/Form/Registration/Confirm.php, createProfileContact, 998
/home/famcafe/public_html/administrator/components/com_civicrm/civicrm/CRM/Event/Form/Registration/Confirm.php, updateContactFields, 487
/home/famcafe/public_html/administrator/components/com_civicrm/civicrm/CRM/Core/Form.php, postProcess, 250
/home/famcafe/public_html/administrator/components/com_civicrm/civicrm/CRM/Core/StateMachine.php, mainProcess, 167
/home/famcafe/public_html/administrator/components/com_civicrm/civicrm/CRM/Core/QuickForm/Action/Next.php, perform, 64
/home/famcafe/public_html/administrator/components/com_civicrm/civicrm/packages/HTML/QuickForm/Controller.php, perform, 203
/home/famcafe/public_html/administrator/components/com_civicrm/civicrm/packages/HTML/QuickForm/Page.php, handle, 103
/home/famcafe/public_html/administrator/components/com_civicrm/civicrm/CRM/Core/Controller.php, handle, 284
/home/famcafe/public_html/administrator/components/com_civicrm/civicrm/CRM/Core/Invoke.php, run, 219
/home/famcafe/public_html/components/com_civicrm/civicrm.php, invoke, 81
/home/famcafe/public_html/components/com_civicrm/civicrm.php, civicrm_invoke, 24
/home/famcafe/public_html/libraries/joomla/application/component/helper.php, require_once, 162
/home/famcafe/public_html/includes/application.php, renderComponent, 124
/home/famcafe/public_html/index.php, dispatch, 68

Sorry. A non-recoverable error has occurred.
DB Error: constraint violation
Error Details
Database Error Code: Cannot add or update a child row: a foreign key constraint fails (`famcafe_site/civicrm_value_conference_registration_extended_1`, CONSTRAINT `FK_civicrm_value_conference_registr_07e4b4ef6f334081` FOREIGN KEY (`entity_id`) REFERENCES `civicrm_event` (`id`) O), 1452
Additional Details:

Array
(
    [callback] => Array
        (
           

• => CRM_Core_Error
[1] => handle
        )

   

=> -3
    [message] => DB Error: constraint violation
    [mode] => 16
    [debug_info] => INSERT INTO civicrm_value_conference_registration_extended_1  ( florida_county_31,demographic_information_1,if_you_answered_other_please_ent_2,language_21,primary_language__0ther__14,military_service2_22,military_component_27,do_you_have_a_family_member_enro_5,comm_25,other_communication_needs_7,i_or_a_member_of_my_family_am_ar_8,services2_23,volunteer_28,i_can_help_interpret_in_the_foll_29,financial_assistance_guidelines_12,entity_id ) VALUES ( 'Dade','
White
','','
English
','','','',null,'
ASL
','',null,'
Children’s Mental Health
','
Registration
Room Monitor
Conference Bag Stuffing
','','
no aid requested
',15 ) ON DUPLICATE KEY UPDATE florida_county_31 = 'Dade',demographic_information_1 = '
White
',if_you_answered_other_please_ent_2 = '',language_21 = '
English
',primary_language__0ther__14 = '',military_service2_22 = '',military_component_27 = '',do_you_have_a_family_member_enro_5 = null,comm_25 = '
ASL
',other_communication_needs_7 = '',i_or_a_member_of_my_family_am_ar_8 = null,services2_23 = '
Children’s Mental Health
',volunteer_28 = '
Registration
Room Monitor
Conference Bag Stuffing
',i_can_help_interpret_in_the_foll_29 = '',financial_assistance_guidelines_12 = '
no aid requested
' [nativecode=1452 ** Cannot add or update a child row: a foreign key constraint fails (`famcafe_site/civicrm_value_conference_registration_extended_1`, CONSTRAINT `FK_civicrm_value_conference_registr_07e4b4ef6f334081` FOREIGN KEY (`entity_id`) REFERENCES `civicrm_event` (`id`) O)]
    [type] => DB_Error
    [user_info] => INSERT INTO civicrm_value_conference_registration_extended_1  ( florida_county_31,demographic_information_1,if_you_answered_other_please_ent_2,language_21,primary_language__0ther__14,military_service2_22,military_component_27,do_you_have_a_family_member_enro_5,comm_25,other_communication_needs_7,i_or_a_member_of_my_family_am_ar_8,services2_23,volunteer_28,i_can_help_interpret_in_the_foll_29,financial_assistance_guidelines_12,entity_id ) VALUES ( 'Dade','
White
','','
English
','','','',null,'
ASL
','',null,'
Children’s Mental Health
','
Registration
Room Monitor
Conference Bag Stuffing
','','
no aid requested
',15 ) ON DUPLICATE KEY UPDATE florida_county_31 = 'Dade',demographic_information_1 = '
White
',if_you_answered_other_please_ent_2 = '',language_21 = '
English
',primary_language__0ther__14 = '',military_service2_22 = '',military_component_27 = '',do_you_have_a_family_member_enro_5 = null,comm_25 = '
ASL
',other_communication_needs_7 = '',i_or_a_member_of_my_family_am_ar_8 = null,services2_23 = '
Children’s Mental Health
',volunteer_28 = '
Registration
Room Monitor
Conference Bag Stuffing
',i_can_help_interpret_in_the_foll_29 = '',financial_assistance_guidelines_12 = '
no aid requested
' [nativecode=1452 ** Cannot add or update a child row: a foreign key constraint fails (`famcafe_site/civicrm_value_conference_registration_extended_1`, CONSTRAINT `FK_civicrm_value_conference_registr_07e4b4ef6f334081` FOREIGN KEY (`entity_id`) REFERENCES `civicrm_event` (`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_conference_registration_extended_1  ( florida_county_31,demographic_information_1,if_you_answered_other_please_ent_2,language_21,primary_language__0ther__14,military_service2_22,military_component_27,do_you_have_a_family_member_enro_5,comm_25,other_communication_needs_7,i_or_a_member_of_my_family_am_ar_8,services2_23,volunteer_28,i_can_help_interpret_in_the_foll_29,financial_assistance_guidelines_12,entity_id ) VALUES ( 'Dade','
White
','','
English
','','','',null,'
ASL
','',null,'
Children’s Mental Health
','
Registration
Room Monitor
Conference Bag Stuffing
','','
no aid requested
',15 ) ON DUPLICATE KEY UPDATE florida_county_31 = 'Dade',demographic_information_1 = '
White
',if_you_answered_other_please_ent_2 = '',language_21 = '
English
',primary_language__0ther__14 = '',military_service2_22 = '',military_component_27 = '',do_you_have_a_family_member_enro_5 = null,comm_25 = '
ASL
',other_communication_needs_7 = '',i_or_a_member_of_my_family_am_ar_8 = null,services2_23 = '
Children’s Mental Health
',volunteer_28 = '
Registration
Room Monitor
Conference Bag Stuffing
',i_can_help_interpret_in_the_foll_29 = '',financial_assistance_guidelines_12 = '
no aid requested
' [nativecode=1452 ** Cannot add or update a child row: a foreign key constraint fails (`famcafe_site/civicrm_value_conference_registration_extended_1`, CONSTRAINT `FK_civicrm_value_conference_registr_07e4b4ef6f334081` FOREIGN KEY (`entity_id`) REFERENCES `civicrm_event` (`id`) O)]"]
)

Return to home page.


Thanks Lobo - I think this all may be related to the bug I logged yesterday about changing the type of the custom data group.

After spending most of the afternoon reading through posts reporting errors similar to mine, I gained a better understanding of how to gather participant data for an event. I recreated my custom data group and the type was Participant (Event). I added my fields (thank goodness for the ability to reuse option groups previously completed). I added the new profile to my Registration config and so far I have been able to process both a $0 value and a paid registration without any errors.

My understanding of CiviEvent and Profiles has grown exponentially over the last few days.  I will try and write up what I did (originally) that caused this headache and post it.