CiviCRM Community Forums (archive)

I have implemented the hook "mymodule_civicrm_buildForm" . It only does anything on one particular profile. ( A profile I call "Attendance", which only includes first and last name. )

For this specific profile, I call the API   "civicrm_participant_update($params);"

( The affect is that by the time the user sees the profile, they  have been marked as "attended".  )  They can click the "save" or "cancel" button, which has the affect of simply saving their first and last name. ( I have not implemented the hook "civicrm_postprocess()"  )

Everything was working before I upgraded the site to 3.2.3. The "mymodule_civicrm_buildForm" hook still works ( ie they are marked as attended. )

However, if the user clicks the "save" button on the profile,  they get this following error:

-------------------------------------------------------------------------------------

Database Error Code: Cannot add or update a child row: a foreign key constraint fails (`newsholo_drp1`.`civicrm_participant`, CONSTRAINT `FK_civicrm_participant_contact_id` FOREIGN KEY (`contact_id`) REFERENCES `civicrm_contact` (`id`) ON DELETE CASCADE), 1452
Additional Details:
Array
(
    [callback] => Array
        (
           

• => CRM_Core_Error
[1] => handle
        )

   

=> -3
    [message] => DB Error: constraint violation
    [mode] => 16
    [debug_info] => INSERT INTO civicrm_participant (event_id , status_id ) VALUES ( 0 ,  2 )  [nativecode=1452 ** Cannot add or update a child row: a foreign key constraint fails (`newsholo_drp1`.`civicrm_participant`, CONSTRAINT `FK_civicrm_participant_contact_id` FOREIGN KEY (`contact_id`) REFERENCES `civicrm_contact` (`id`) ON DELETE CASCADE)]
    [type] => DB_Error
    [user_info] => INSERT INTO civicrm_participant (event_id , status_id ) VALUES ( 0 ,  2 )  [nativecode=1452 ** Cannot add or update a child row: a foreign key constraint fails (`newsholo_drp1`.`civicrm_participant`, CONSTRAINT `FK_civicrm_participant_contact_id` FOREIGN KEY (`contact_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_participant (event_id , status_id ) VALUES ( 0 ,  2 )  [nativecode=1452 ** Cannot add or update a child row: a foreign key constraint fails (`newsholo_drp1`.`civicrm_participant`, CONSTRAINT `FK_civicrm_participant_contact_id` FOREIGN KEY (`contact_id`) REFERENCES `civicrm_contact` (`id`) ON DELETE CASCADE)]"]
)

---------------------------------------------
 If I eliminate the call to the civicrm_participant_update API, then I don't get the error. ( But, obviously they are not marked as attended, which is what I really want. )

Any ideas?

I evaluated the event id in the hook "civicrm_buildForm", and it has the correct event id.

I am confused why CiviCRM is trying to update the table "civicrm_participant" on the profile form submission, since I do not implement the hook "civicrm_postProcess"