CiviCRM Community Forums (archive)

I wanted to upgrade from 2.1. to 2.2. an get the following error message after callimg the url http://<your_drupal_home>/?q=civicrm/upgrade&reset=1

backTrace

/var/www/ldellere/kub2_2/sites/all/modules/civicrm/CRM/Core/Error.php, backtrace, 148
, handle,
/var/www/ldellere/kub2_2/sites/all/modules/civicrm/packages/PEAR.php, call_user_func, 912
/var/www/ldellere/kub2_2/sites/all/modules/civicrm/packages/DB.php, PEAR_Error, 966
/var/www/ldellere/kub2_2/sites/all/modules/civicrm/packages/PEAR.php, DB_Error, 574
/var/www/ldellere/kub2_2/sites/all/modules/civicrm/packages/DB/common.php, raiseError, 1903
/var/www/ldellere/kub2_2/sites/all/modules/civicrm/packages/DB/mysql.php, raiseError, 898
/var/www/ldellere/kub2_2/sites/all/modules/civicrm/packages/DB/mysql.php, mysqlRaiseError, 327
/var/www/ldellere/kub2_2/sites/all/modules/civicrm/packages/DB/common.php, simpleQuery, 1216
/var/www/ldellere/kub2_2/sites/all/modules/civicrm/packages/DB/DataObject.php, query, 2394
/var/www/ldellere/kub2_2/sites/all/modules/civicrm/packages/DB/DataObject.php, _query, 1587
/var/www/ldellere/kub2_2/sites/all/modules/civicrm/CRM/Core/DAO.php, query, 144
/var/www/ldellere/kub2_2/sites/all/modules/civicrm/CRM/Core/DAO.php, query, 861
/var/www/ldellere/kub2_2/sites/all/modules/civicrm/CRM/Upgrade/TwoOne/Form/TwoOneTwo.php, executeQuery, 142
/var/www/ldellere/kub2_2/sites/all/modules/civicrm/CRM/Upgrade/Page/Upgrade.php, upgrade, 176
/var/www/ldellere/kub2_2/sites/all/modules/civicrm/CRM/Upgrade/Page/Upgrade.php(106) : eval()'d code, upgrade_2_1_2, 1
/var/www/ldellere/kub2_2/sites/all/modules/civicrm/CRM/Upgrade/Page/Upgrade.php, eval, 106
/var/www/ldellere/kub2_2/sites/all/modules/civicrm/CRM/Core/Invoke.php, run, 205
/var/www/ldellere/kub2_2/sites/all/modules/civicrm/drupal/civicrm.module, invoke, 339
, civicrm_invoke,
/var/www/ldellere/kub2_2/includes/menu.inc, call_user_func_array, 348
/var/www/ldellere/kub2_2/index.php, menu_execute_active_handler, 18

Upgrade CiviCRM to Version 2.2.0

unrecoverable error
    Sorry. A non-recoverable error has occurred.

    DB Error: no such field

    Return to home page.

Error Details:

Array
(
    [callback] => Array
        (
            [0] => CRM_Core_Error
            [1] => handle
        )

    [code] => -19
    [message] => DB Error: no such field
    [mode] => 16
    [debug_info] =>
UPDATE civicrm_participant,civicrm_option_group, civicrm_option_value, civicrm_event_page, civicrm_event
SET civicrm_participant.fee_amount = civicrm_option_value.value
WHERE civicrm_option_value.option_group_id = civicrm_option_group.id
AND civicrm_event_page.id = substring( civicrm_option_group.name FROM 27 )
AND civicrm_option_group.name LIKE "civicrm_event_page.amount.%"
AND civicrm_participant.event_id = civicrm_event.id
AND civicrm_event.id = civicrm_event_page.event_id
AND civicrm_option_value.label = civicrm_participant.fee_level
 [nativecode=1054 ** Unknown column 'civicrm_option_value.label' in 'where clause']
    [type] => DB_Error
    [user_info] =>
UPDATE civicrm_participant,civicrm_option_group, civicrm_option_value, civicrm_event_page, civicrm_event
SET civicrm_participant.fee_amount = civicrm_option_value.value
WHERE civicrm_option_value.option_group_id = civicrm_option_group.id
AND civicrm_event_page.id = substring( civicrm_option_group.name FROM 27 )
AND civicrm_option_group.name LIKE "civicrm_event_page.amount.%"
AND civicrm_participant.event_id = civicrm_event.id
AND civicrm_event.id = civicrm_event_page.event_id
AND civicrm_option_value.label = civicrm_participant.fee_level
 [nativecode=1054 ** Unknown column 'civicrm_option_value.label' in 'where clause']
    [to_string] => [db_error: message="DB Error: no such field" code=-19 mode=callback callback=CRM_Core_Error::handle prefix="" info="
UPDATE civicrm_participant,civicrm_option_group, civicrm_option_value, civicrm_event_page, civicrm_event
SET civicrm_participant.fee_amount = civicrm_option_value.value
WHERE civicrm_option_value.option_group_id = civicrm_option_group.id
AND civicrm_event_page.id = substring( civicrm_option_group.name FROM 27 )
AND civicrm_option_group.name LIKE "civicrm_event_page.amount.%"
AND civicrm_participant.event_id = civicrm_event.id
AND civicrm_event.id = civicrm_event_page.event_id
AND civicrm_option_value.label = civicrm_participant.fee_level
 [nativecode=1054 ** Unknown column 'civicrm_option_value.label' in 'where clause']"]
)

I got the error message "no such DB_field" before, sometimes when not logged in with the admin user.

Thanks!
[/code]