'Price Set Details for Event Participants' gives DB error if the price fields are disabled.
Steps to replicate:
- Create a price set and associate with an event.
- Register a participant with the event.
- Disable the price fields.
- Go to Custom Searches > Price Set Details for Event Participants, search with the said event. It throws DB error
DB Error: syntax error Error Details Database Error Code: 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 'WHERE participant_id = 52' at line 3, 1064 Additional Details: Array ( [callback] => Array ( [0] => CRM_Core_Error [1] => handle )
[code] => -2 [message] => DB Error: syntax error [mode] => 16 [debug_info] =>
UPDATE civicrm_temp_custom_c87e02e10a4041be20a9ae7529218687 SET WHERE participant_id = 52; [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 'WHERE participant_id = 52' at line 3] [type] => DB_Error [user_info] => UPDATE civicrm_temp_custom_c87e02e10a4041be20a9ae7529218687 SET WHERE participant_id = 52; [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 'WHERE participant_id = 52' at line 3] [to_string] => [db_error: message="DB Error: syntax error" code=-2 mode=callback callback=CRM_Core_Error::handle prefix="" info=" UPDATE civicrm_temp_custom_c87e02e10a4041be20a9ae7529218687 SET WHERE participant_id = 52; [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 'WHERE participant_id = 52' at line 3]"] )