You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
{{ message }}
This repository has been archived by the owner on Feb 24, 2020. It is now read-only.
But in the api explorer I get the following message:
{
"error_code": 0,
"error_message": "DB Error: no such field"
}
And the CiviCRM error log shows this:
FROM civicrm_participant a
LEFT JOIN `civicrm_contact` `participant_contact` ON a.participant_contact_id = participant_contact.id
WHERE (`a`.`status_id` = "1") AND (`a`.`event_id` = "148") AND (`participant_contact`.`gender_id` = "2")
[nativecode=1054 ** Unknown column 'a.participant_contact_id' in 'on clause']
I believe a wrong field is used in the join query (participant_contact_id instead of contact_id).
In the table civicrm_participant the field contact_id should be used I guess.
Am I the first to encounter this and is this really a bug?
The text was updated successfully, but these errors were encountered:
Sign up for freeto subscribe to this conversation on GitHub.
Already have an account?
Sign in.
I was trying to retrieve all male participant of an event using api4 but this results in an error.
But in the api explorer I get the following message:
And the CiviCRM error log shows this:
I believe a wrong field is used in the join query (participant_contact_id instead of contact_id).
In the table civicrm_participant the field contact_id should be used I guess.
Am I the first to encounter this and is this really a bug?
The text was updated successfully, but these errors were encountered: