CiviCRM Community Forums (archive)

I created a new event and all of the profile/price set information and it looks great. When I try to register I get a FK constraint violation:

CONSTRAINT `FK_civicrm_value_annual_conference__c82d0f5e10d827c0` FOREIGN KEY (`entity_id`) REFERENCES `civicrm_event` (`id`) ON DELE)
The problem is that the entity_id in the query is 9 but the civicrm_event id field should be 1.

How is the entity ID getting the value and how could it be wrong?

I am still learning the internals of CiviCRM so any help with this is greatly appreciated.

Thanks,
Q

Hi Lobo,

The custom data type is set to Participant(Event Name) so the fields would only be available to participants of this specific event. I haven't done any hacking/customization beyond a small js snippet. This site was just recently set up and is only handling registrations for this one event.

What else could I have done wrong in my setup to cause this problem?

BTW, this may be related to the issue presented in another recent thread - http://forum.civicrm.org/index.php/topic,12227.0.html

Thanks for your help,
Q

yes, the entity_id is an FK to the table that the custom group is extending

what version are you on? did you change the custom group settings and what it extends. there was a bug with this in 3.0.x version i think

lobo

OK - I found something even stranger

When I first set up the custom data for the event I selected the wrong custom data type - Event. When I realized my mistake, I removed that custom data type and created a new custom data type with the same name for Participant

I went in and tried to edit one of the existing registrants to see what would happen after I hacked the db as described above. I noticed that there were 2 sections with custom data that had the same name. The first one looked like the original custom data with the wrong type and the second one looked like my corrected version. Looking at the html source one section had the name of the first, incorrect, custom data type I created - Annual_Conference_2010_1 and the other section had the name of the correct custom data type - Annual_Conference_2010_2.

Somewhere there is a reference to that first custom data type, but I can't find it. I full text searched the db, emptied the civicrm_cache table and deleted all of the cache files for civicrm.

Any clues?

Thanks,
Q