CiviCRM Community Forums (archive)

I did this twice, resetting my DB in between, and got the same results.  When running the "Upgrade" script:
unrecoverable error
    Sorry. A non-recoverable error has occurred.
    CiviCRM upgrade was successful.
    DB Error: no such field
    Database Error Code: Unknown column 'civicrm_custom_group.extends_entity_column_id' in 'field list', 1054
    Return to home page.

So, was there an error, or was it successful?  I don't think successful as nothing seemed to work afterwards, including the user information panels.

Here is the rest of the error code:
Error Details:

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

    [code] => -19
    [message] => DB Error: no such field
    [mode] => 16
    [debug_info] => SELECT civicrm_custom_field.id as civicrm_custom_field_id, civicrm_custom_field.label as civicrm_custom_field_label, civicrm_custom_field.column_name as civicrm_custom_field_column_name, civicrm_custom_field.data_type as civicrm_custom_field_data_type, civicrm_custom_field.html_type as civicrm_custom_field_html_type, civicrm_custom_field.default_value as civicrm_custom_field_default_value, civicrm_custom_field.attributes as civicrm_custom_field_attributes, civicrm_custom_field.is_required as civicrm_custom_field_is_required, civicrm_custom_field.is_view as civicrm_custom_field_is_view, civicrm_custom_field.help_post as civicrm_custom_field_help_post, civicrm_custom_field.options_per_line as civicrm_custom_field_options_per_line, civicrm_custom_field.start_date_years as civicrm_custom_field_start_date_years, civicrm_custom_field.end_date_years as civicrm_custom_field_end_date_years, civicrm_custom_field.date_parts as civicrm_custom_field_date_parts, civicrm_custom_field.option_group_id as civicrm_custom_field_option_group_id, civicrm_custom_group.id as civicrm_custom_group_id, civicrm_custom_group.name as civicrm_custom_group_name, civicrm_custom_group.table_name as civicrm_custom_group_table_name, civicrm_custom_group.title as civicrm_custom_group_title, civicrm_custom_group.help_pre as civicrm_custom_group_help_pre, civicrm_custom_group.help_post as civicrm_custom_group_help_post, civicrm_custom_group.collapse_display as civicrm_custom_group_collapse_display, civicrm_custom_group.is_multiple as civicrm_custom_group_is_multiple, civicrm_custom_group.extends as civicrm_custom_group_extends, civicrm_custom_group.extends_entity_column_id as civicrm_custom_group_extends_entity_column_id, civicrm_custom_group.extends_entity_column_value as civicrm_custom_group_extends_entity_column_value, civicrm_custom_group.max_multiple as civicrm_custom_group_max_multiple
FROM     civicrm_custom_group
LEFT JOIN civicrm_custom_field ON (civicrm_custom_field.custom_group_id = civicrm_custom_group.id)
 
WHERE civicrm_custom_group.is_active = 1
  AND civicrm_custom_field.is_active = 1
  AND civicrm_custom_group.extends IN ('Individual', 'Contact')
  AND civicrm_custom_group.extends_entity_column_value IS NULL
 AND civicrm_custom_group.style = 'Inline' AND civicrm_custom_group.id IN ( 1,2 ) 
ORDER BY civicrm_custom_group.weight,
         civicrm_custom_group.title,
         civicrm_custom_field.weight,
         civicrm_custom_field.label
 [nativecode=1054 ** Unknown column 'civicrm_custom_group.extends_entity_column_id' in 'field list']
    [type] => DB_Error
    [user_info] => SELECT civicrm_custom_field.id as civicrm_custom_field_id, civicrm_custom_field.label as civicrm_custom_field_label, civicrm_custom_field.column_name as civicrm_custom_field_column_name, civicrm_custom_field.data_type as civicrm_custom_field_data_type, civicrm_custom_field.html_type as civicrm_custom_field_html_type, civicrm_custom_field.default_value as civicrm_custom_field_default_value, civicrm_custom_field.attributes as civicrm_custom_field_attributes, civicrm_custom_field.is_required as civicrm_custom_field_is_required, civicrm_custom_field.is_view as civicrm_custom_field_is_view, civicrm_custom_field.help_post as civicrm_custom_field_help_post, civicrm_custom_field.options_per_line as civicrm_custom_field_options_per_line, civicrm_custom_field.start_date_years as civicrm_custom_field_start_date_years, civicrm_custom_field.end_date_years as civicrm_custom_field_end_date_years, civicrm_custom_field.date_parts as civicrm_custom_field_date_parts, civicrm_custom_field.option_group_id as civicrm_custom_field_option_group_id, civicrm_custom_group.id as civicrm_custom_group_id, civicrm_custom_group.name as civicrm_custom_group_name, civicrm_custom_group.table_name as civicrm_custom_group_table_name, civicrm_custom_group.title as civicrm_custom_group_title, civicrm_custom_group.help_pre as civicrm_custom_group_help_pre, civicrm_custom_group.help_post as civicrm_custom_group_help_post, civicrm_custom_group.collapse_display as civicrm_custom_group_collapse_display, civicrm_custom_group.is_multiple as civicrm_custom_group_is_multiple, civicrm_custom_group.extends as civicrm_custom_group_extends, civicrm_custom_group.extends_entity_column_id as civicrm_custom_group_extends_entity_column_id, civicrm_custom_group.extends_entity_column_value as civicrm_custom_group_extends_entity_column_value, civicrm_custom_group.max_multiple as civicrm_custom_group_max_multiple
FROM     civicrm_custom_group
LEFT JOIN civicrm_custom_field ON (civicrm_custom_field.custom_group_id = civicrm_custom_group.id)
 
WHERE civicrm_custom_group.is_active = 1
  AND civicrm_custom_field.is_active = 1
  AND civicrm_custom_group.extends IN ('Individual', 'Contact')
  AND civicrm_custom_group.extends_entity_column_value IS NULL
 AND civicrm_custom_group.style = 'Inline' AND civicrm_custom_group.id IN ( 1,2 ) 
ORDER BY civicrm_custom_group.weight,
         civicrm_custom_group.title,
         civicrm_custom_field.weight,
         civicrm_custom_field.label
 [nativecode=1054 ** Unknown column 'civicrm_custom_group.extends_entity_column_id' 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 civicrm_custom_field.id as civicrm_custom_field_id, civicrm_custom_field.label as civicrm_custom_field_label, civicrm_custom_field.column_name as civicrm_custom_field_column_name, civicrm_custom_field.data_type as civicrm_custom_field_data_type, civicrm_custom_field.html_type as civicrm_custom_field_html_type, civicrm_custom_field.default_value as civicrm_custom_field_default_value, civicrm_custom_field.attributes as civicrm_custom_field_attributes, civicrm_custom_field.is_required as civicrm_custom_field_is_required, civicrm_custom_field.is_view as civicrm_custom_field_is_view, civicrm_custom_field.help_post as civicrm_custom_field_help_post, civicrm_custom_field.options_per_line as civicrm_custom_field_options_per_line, civicrm_custom_field.start_date_years as civicrm_custom_field_start_date_years, civicrm_custom_field.end_date_years as civicrm_custom_field_end_date_years, civicrm_custom_field.date_parts as civicrm_custom_field_date_parts, civicrm_custom_field.option_group_id as civicrm_custom_field_option_group_id, civicrm_custom_group.id as civicrm_custom_group_id, civicrm_custom_group.name as civicrm_custom_group_name, civicrm_custom_group.table_name as civicrm_custom_group_table_name, civicrm_custom_group.title as civicrm_custom_group_title, civicrm_custom_group.help_pre as civicrm_custom_group_help_pre, civicrm_custom_group.help_post as civicrm_custom_group_help_post, civicrm_custom_group.collapse_display as civicrm_custom_group_collapse_display, civicrm_custom_group.is_multiple as civicrm_custom_group_is_multiple, civicrm_custom_group.extends as civicrm_custom_group_extends, civicrm_custom_group.extends_entity_column_id as civicrm_custom_group_extends_entity_column_id, civicrm_custom_group.extends_entity_column_value as civicrm_custom_group_extends_entity_column_value, civicrm_custom_group.max_multiple as civicrm_custom_group_max_multiple
FROM     civicrm_custom_group
LEFT JOIN civicrm_custom_field ON (civicrm_custom_field.custom_group_id = civicrm_custom_group.id)
 
WHERE civicrm_custom_group.is_active = 1
  AND civicrm_custom_field.is_active = 1
  AND civicrm_custom_group.extends IN ('Individual', 'Contact')
  AND civicrm_custom_group.extends_entity_column_value IS NULL
 AND civicrm_custom_group.style = 'Inline' AND civicrm_custom_group.id IN ( 1,2 ) 
ORDER BY civicrm_custom_group.weight,
         civicrm_custom_group.title,
         civicrm_custom_field.weight,
         civicrm_custom_field.label
 [nativecode=1054 ** Unknown column 'civicrm_custom_group.extends_entity_column_id' in 'field list']"]
)

I was following the instructions at http://wiki.civicrm.org/confluence/display/CRMDOC/Upgrade+Drupal+Sites+to+2.2

Thanks for any assistance and/or ideas.

jgaryt[/code]

Few things to confirm if the db has really upgraded to beta4 -
- civicrm_event table should have the newly added column "allow_same_participant_emails".
- "name" column of civicrm_loc_block table should not exist.
- version column of civicrm_domain is set to "2.2.beta4".

If all above points comply with your db, try adding the "extends_entity_column_id" using the following query and see if that solves the problem.
ALTER TABLE `civicrm_custom_group` 
ADD COLUMN `extends_entity_column_id` int( 10 ) unsigned default NULL COMMENT 'reference to option value'

You could also try out latest v2.2.0 out there. And if the problem still persist forward your 2.1db dump to deepak (at webaccess dot co dot in),  and we would investigate/fix the problem and report back.

Few things to confirm if the db has really upgraded to beta4 -
- civicrm_event table should have the newly added column "allow_same_participant_emails".
- "name" column of civicrm_loc_block table should not exist.
- version column of civicrm_domain is set to "2.2.beta4".

If all above points comply with your db, try adding the "extends_entity_column_id" using the following query and see if that solves the problem.

Code: [Select]

ALTER TABLE `civicrm_custom_group` 
ADD COLUMN `extends_entity_column_id` int( 10 ) unsigned default NULL COMMENT 'reference to option value'

You could also try out latest v2.2.0 out there. And if the problem still persist forward your 2.1db dump to deepak (at webaccess dot co dot in),  and we would investigate/fix the problem and report back.

I do not know enough about databases to do this. My post was a little off topic. I was upgrading from 2.1.2 to 2.2 when I encountered this error.

I have restored my backup and gone back to 2.1.2. I will follow progress in http://forum.civicrm.org/index.php?topic=7075.0

I re-read the instructions at http://wiki.civicrm.org/confluence/display/CRMDOC/Upgrade+Drupal+Sites+to+2.2. My <drupal home>/sites/default directory was set to 555 when i did the upgrade. Could this be the problem?