CiviCRM Community Forums (archive)

NOTE: This issue seems to be fixed for version 4.1.1  My patch/explanation might help you out for a few days....

If I define a discount for an event, attempting to display the registration screen crashes the process and dumps the following:

Database Error Code: Unknown column 'label' in 'field list', 1054
Additional Details:
Array
(
    [callback] => Array
        (
           

• => CRM_Core_Error
[1] => handle
        )

    code => -19
   

[message] => DB Error: no such field
    [mode] => 16
    [debug_info] => SELECT  id, label 
 FROM civicrm_option_group
 
 WHERE (  civicrm_option_group.id = 94 ) 

The problem here is that the query is trying to select the "label" column from the option_group table.... and there is no such column! Changing the code to query for 'title' is the fix.

This is my patch for the file civicrm/CRM/Event/Form/Registration.php ... which seems to work beautifully.
749 - $optionGroupId, 'label');;
749 + $optionGroupId, 'title');;