[CRM-5220] Online event registration with Additional Participants: fatal error if participant statuses are localized - CiviCRM Issue Tracker

Details

Type: Bug
Status: Done/Fixed
Priority: Major
Resolution: Fixed/Completed
Affects Version/s: 3.0.1
Fix Version/s: 3.0.2
Component/s: CiviEvent
Labels:
None

Description

If the "label" for the "Cancelled" participant status has been localized, then users will get a fatal error when confirming online event registration with Additional Participants:

DB Error: syntax error
[mode] => 16
[debug_info] =>
SELECT participant.id
FROM civicrm_participant participant
WHERE participant.registered_by_id=109 AND participant.status_id != [nativecode=1064 ** You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 3]

This bug was caused by modification to CRM_Event_Pseudoconstant::participantStatus to return 'label' instead of 'name' column. Fix will need to extend that function to return 'name' or 'label' depending on caller (since status_id dropdown in CRM_Event_Form_Participant needs labels).