Author Topic: After upgrading to 4.1.0 - Unknown column 'label' in 'field list', 1054 (Read 1274 times)

yshah · February 21, 2012, 12:29:24 am

After upgrading to 4.1.0, I went to test the registration link for an event. When I go to the registration link it gives me the following error:

Code: [Select]

Database Error Code: Unknown column 'label' in 'field list', 1054
Additional Details:

Array
(
    [callback] => Array
        (
            [0] => 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 = 93 )  
 
 
 
 [nativecode=1054 ** Unknown column 'label' in 'field list']
    [type] => DB_Error
    [user_info] => SELECT  id, label  
 FROM civicrm_option_group 
 
 WHERE (  civicrm_option_group.id = 93 )  
 
 
 
 [nativecode=1054 ** Unknown column 'label' in 'field list']
    [to_string] => [db_error: message="DB Error: no such field" code=-19 mode=callback callback=CRM_Core_Error::handle prefix="" info="SELECT  id, label  
 FROM civicrm_option_group 
 
 WHERE (  civicrm_option_group.id = 93 )  
 
 
 
 [nativecode=1054 ** Unknown column 'label' in 'field list']"]
)

Any idea how to correct this?

Donald Lobo · February 21, 2012, 07:23:07 am

This is fixed in 4.1.1 which will be released in the next week or so. You can get the patch from here:

https://fisheye2.atlassian.com/browse/CiviCRM/branches/v4.1/CRM/Event/Form/Registration.php?r2=38834&r1=38817

lobo

yshah · February 21, 2012, 07:51:19 am

Awesome. THanks Lobo, that did the trick.

garkalulu · March 15, 2012, 07:22:36 pm

Hi Lobo,

The same error will show up when you create event.

I have gone through the code and found that CRM/Event/Form/ManageEvent/EventInfo.php
file has error in it.

Line 342-345

After I changed 'label' in line 345 to 'title', it works..

Code: [Select]

             foreach ( $optionGroupIds as $id ) {
                   $discountSuffix = '.discount.'. CRM_Core_DAO::getFieldValue( 'CRM_Core_DAO_OptionGroup',
                                                                                $id,
                                                                                'label' );

Kurund Jalmi · March 15, 2012, 10:56:49 pm

Thanks for the patch, this is fixed and will be part of next release - 4.1.2

Kurund

CiviCRM Community Forums (archive)

News:

Author Topic: After upgrading to 4.1.0 - Unknown column 'label' in 'field list', 1054 (Read 1274 times)

yshah

After upgrading to 4.1.0 - Unknown column 'label' in 'field list', 1054

Donald Lobo

Re: After upgrading to 4.1.0 - Unknown column 'label' in 'field list', 1054

yshah

Re: After upgrading to 4.1.0 - Unknown column 'label' in 'field list', 1054

garkalulu

Re: After upgrading to 4.1.0 - Unknown column 'label' in 'field list', 1054

Kurund Jalmi

Re: After upgrading to 4.1.0 - Unknown column 'label' in 'field list', 1054