Upgrade from 4.3.8 to 4.4.6 failing because missing civicrm_uf_group.description

[ehendricks]

This is for Drupal 7 and I am using http://<your_drupal_home>/civicrm/upgrade?reset=1 to perform the database updates.  I have found issues that address this, but from what I can tell they have been fixed well before 4.3.8.  Any help would be appreciated.

   

Code: [Select]

=> -19
    [message] => DB Error: no such field
    [mode] => 16
    [debug_info] => SELECT civicrm_uf_group.id, civicrm_uf_group.title, civicrm_uf_group.created_id, civicrm_uf_group.is_active, civicrm_uf_group.is_reserved, civicrm_uf_group.group_type, civicrm_uf_group.description
                        FROM civicrm_uf_group
                        LEFT JOIN civicrm_uf_join ON (civicrm_uf_group.id = uf_group_id) AND civicrm_uf_group.is_active = 1
                              WHERE civicrm_uf_join.module = 'User Account' ORDER BY civicrm_uf_join.weight, civicrm_uf_group.title [nativecode=1054 ** Unknown column 'civicrm_uf_group.description' in 'field list']
    [type] => DB_Error
    [user_info] => SELECT civicrm_uf_group.id, civicrm_uf_group.title, civicrm_uf_group.created_id, civicrm_uf_group.is_active, civicrm_uf_group.is_reserved, civicrm_uf_group.group_type, civicrm_uf_group.description
                        FROM civicrm_uf_group
                        LEFT JOIN civicrm_uf_join ON (civicrm_uf_group.id = uf_group_id) AND civicrm_uf_group.is_active = 1
                              WHERE civicrm_uf_join.module = 'User Account' ORDER BY civicrm_uf_join.weight, civicrm_uf_group.title [nativecode=1054 ** Unknown column 'civicrm_uf_group.description' 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_uf_group.id, civicrm_uf_group.title, civicrm_uf_group.created_id, civicrm_uf_group.is_active, civicrm_uf_group.is_reserved, civicrm_uf_group.group_type, civicrm_uf_group.description
                        FROM civicrm_uf_group
                        LEFT JOIN civicrm_uf_join ON (civicrm_uf_group.id = uf_group_id) AND civicrm_uf_group.is_active = 1
                              WHERE civicrm_uf_join.module = 'User Account' ORDER BY civicrm_uf_join.weight, civicrm_uf_group.title [nativecode=1054 ** Unknown column 'civicrm_uf_group.description' in 'field list']"]


[adamtk]

Yes, I've had this problem using Aegir to run the upgrades (which uses Drush).

It seems to fail at 4.4.0 in my testing. I've investigated some of the other fixes and manually tried to patch the DB but it doesn't work as yet. Was going to do a database rebuild on a clean DB and compare the schema to see what should be there..

[adamtk]

I ran the upgrade manually (without drush/aegir) and it seemed to worked.
I simply dropped the new civicrm files in the drupal modules directory and run the upgrade process (URL/civicrm/upgrade?reset=1)

[ehendricks]

Actually, I was doing the same adamtk, dropping the 4.4.6 files in and running the update script.  I have seen a blog post saying updating via Drush was fixed but via the UI hadn't been yet.  Maybe I will try updating via Drush.  Thanks for the reply!