CiviCRM Community Forums (archive)

*

News:

Have a question about CiviCRM?
Get it answered quickly at the new
CiviCRM Stack Exchange Q+A site
This forum was archived on 25 November 2017. Learn more.
How to get involved.
What to do if you think you've found a bug.



  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using Joomla Extensions (Moderator: lcdweb) »
  • Help registration for event not working
Pages: [1]

Author Topic: Help registration for event not working  (Read 1809 times)

mcollins

  • I’m new here
  • *
  • Posts: 8
  • Karma: 0
Help registration for event not working
July 29, 2010, 10:40:59 am
I am using joomla.  I am new to CivicCRm.  I have installed and set up my contacts with no problems.  I am setting up an event.  I have created new custom data fields.   When I set up a new profile I was only give the choices of profile and search.  And the new profile was not listed in the drop down box on the online registration page. So I  have added these fields plus other standard fields to the participant status profile.

 One other minor issue is that the help field I created in the custom data fields are not appearing on my profile. 

I have managed to get my profile created and run the test.  I get the confirmation page just fine how ever once I hit the confirm I get the following error.  I have tried deleting and recreating all of my work and I am still getting the error.  Please help.  I am currently using a pay later option but will have the payment processors configured when i go live with this.  Please  help.  Am willing to give access to backend to get the help.

I know this is propably an error becuase I overlooked something when I was reading all of the documentation.

Thanks



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 (`texasaut_joomla`.`civicrm_value_truck_rodeo_2`, CONSTRAINT `FK_civicrm_value_truck_rodeo_2_entity_id` FOREIGN KEY (`entity_id`) REFERENCES `civicrm_event` (`id`) ON DELETE CASCADE), 1452

Return to home page.

Error Details:


Array
(
    [callback] => Array
        (
           
  • => CRM_Core_Error
    • [1] => handle
            )

       
Code: [Select]
=> -3
    [message] => DB Error: constraint violation
    [mode] => 16
    [debug_info] => INSERT INTO civicrm_value_truck_rodeo_2  ( badge_name_13,thursday_night_hotel_22,friday_night_hotel_23,saturday_night_hotel_8,thurday_dinner_21,friday_meals1_18,saturday_meals_20,ride_bus_15,activity_16,entity_id ) VALUES ( 'Mary K Collins','Yes','Yes','Yes','Thursday Dinner','Friday BreakfastFriday Dinner','Saturday BreakfastSaturday Dinner','Yes','Driver',6 ) ON DUPLICATE KEY UPDATE badge_name_13 = 'Mary K Collins',thursday_night_hotel_22 = 'Yes',friday_night_hotel_23 = 'Yes',saturday_night_hotel_8 = 'Yes',thurday_dinner_21 = 'Thursday Dinner',friday_meals1_18 = 'Friday BreakfastFriday Dinner',saturday_meals_20 = 'Saturday BreakfastSaturday Dinner',ride_bus_15 = 'Yes',activity_16 = 'Driver' [nativecode=1452 ** Cannot add or update a child row: a foreign key constraint fails (`texasaut_joomla`.`civicrm_value_truck_rodeo_2`, CONSTRAINT `FK_civicrm_value_truck_rodeo_2_entity_id` FOREIGN KEY (`entity_id`) REFERENCES `civicrm_event` (`id`) ON DELETE CASCADE)]
    [type] => DB_Error
    [user_info] => INSERT INTO civicrm_value_truck_rodeo_2  ( badge_name_13,thursday_night_hotel_22,friday_night_hotel_23,saturday_night_hotel_8,thurday_dinner_21,friday_meals1_18,saturday_meals_20,ride_bus_15,activity_16,entity_id ) VALUES ( 'Mary K Collins','Yes','Yes','Yes','Thursday Dinner','Friday BreakfastFriday Dinner','Saturday BreakfastSaturday Dinner','Yes','Driver',6 ) ON DUPLICATE KEY UPDATE badge_name_13 = 'Mary K Collins',thursday_night_hotel_22 = 'Yes',friday_night_hotel_23 = 'Yes',saturday_night_hotel_8 = 'Yes',thurday_dinner_21 = 'Thursday Dinner',friday_meals1_18 = 'Friday BreakfastFriday Dinner',saturday_meals_20 = 'Saturday BreakfastSaturday Dinner',ride_bus_15 = 'Yes',activity_16 = 'Driver' [nativecode=1452 ** Cannot add or update a child row: a foreign key constraint fails (`texasaut_joomla`.`civicrm_value_truck_rodeo_2`, CONSTRAINT `FK_civicrm_value_truck_rodeo_2_entity_id` FOREIGN KEY (`entity_id`) REFERENCES `civicrm_event` (`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_truck_rodeo_2  ( badge_name_13,thursday_night_hotel_22,friday_night_hotel_23,saturday_night_hotel_8,thurday_dinner_21,friday_meals1_18,saturday_meals_20,ride_bus_15,activity_16,entity_id ) VALUES ( 'Mary K Collins','Yes','Yes','Yes','Thursday Dinner','Friday BreakfastFriday Dinner','Saturday BreakfastSaturday Dinner','Yes','Driver',6 ) ON DUPLICATE KEY UPDATE badge_name_13 = 'Mary K Collins',thursday_night_hotel_22 = 'Yes',friday_night_hotel_23 = 'Yes',saturday_night_hotel_8 = 'Yes',thurday_dinner_21 = 'Thursday Dinner',friday_meals1_18 = 'Friday BreakfastFriday Dinner',saturday_meals_20 = 'Saturday BreakfastSaturday Dinner',ride_bus_15 = 'Yes',activity_16 = 'Driver' [nativecode=1452 ** Cannot add or update a child row: a foreign key constraint fails (`texasaut_joomla`.`civicrm_value_truck_rodeo_2`, CONSTRAINT `FK_civicrm_value_truck_rodeo_2_entity_id` FOREIGN KEY (`entity_id`) REFERENCES `civicrm_event` (`id`) ON DELETE CASCADE)]"]
)


Dave Greenberg

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 5760
  • Karma: 226
    • My CiviCRM Blog
Re: Help registration for event not working
July 29, 2010, 03:15:21 pm
Not sure how you've got things setup, but I guess something is not quite right. If you're trying to collect extra info from participants - then your Custom Data Set should be configured as 'Used For' -> Participants. I suspect you have it as 'Used For' -> Events.

Try reading up on Custom Data, Profiles and Configuring Events in the online book and see if that helps / clarifies things.

http://en.flossmanuals.net/CiviCRM/CiviConfigExtendingCoreData
http://en.flossmanuals.net/CiviCRM/CapturingExposing
http://en.flossmanuals.net/CiviCRM/CiviEventsWhatis
Protect your investment in CiviCRM by  becoming a Member!

mcollins

  • I’m new here
  • *
  • Posts: 8
  • Karma: 0
Re: Help registration for event not working
July 29, 2010, 03:36:01 pm
The only options the profile give me was profile or search.  I did not have a choise of participant.

Dave Greenberg

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 5760
  • Karma: 226
    • My CiviCRM Blog
Re: Help registration for event not working
July 29, 2010, 03:42:05 pm
You'll need to read thru the doc above - you choose Participant when creating your custom field set. If things are still not clear, you might want to get help from someone in the Professional Services listing (above).
Protect your investment in CiviCRM by  becoming a Member!

mcollins

  • I’m new here
  • *
  • Posts: 8
  • Karma: 0
Re: Help registration for event not working
July 31, 2010, 06:23:06 pm
Than you guy for you help.  I realized I was using an older verson on Civi and I have upgraded and things are working a lot better.  I am still having a minor issue.  The Help test that I have added to the date custom fields is not showing up on my profiles any suggestions?  Thanks

Dave Greenberg

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 5760
  • Karma: 226
    • My CiviCRM Blog
Re: Help registration for event not working
August 02, 2010, 08:20:48 am
Quote from: mcollins on July 31, 2010, 06:23:06 pm
The Help test that I have added to the date custom fields is not showing up on my profiles any suggestions?  Thanks

If you mean "help TEXT" - the "Field Post Help" from your custom field should come forward to your profile field when you create it and select that custom field. You can modify it on the Profile Field edit form. If this isn't working for you, please try and replicate the issue on our public demo (link above) - and if it replicates post back here with the exact steps you are taking and some screenshots.
Protect your investment in CiviCRM by  becoming a Member!
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using Joomla Extensions (Moderator: lcdweb) »
  • Help registration for event not working

This forum was archived on 2017-11-26.