CiviCRM Community Forums (archive)

I'm getting immediate errors when running the upgrade utility on a v2.2 db.

Backtrace:

DB Error: no such field

Database Error Code: Unknown column 'civicrm_uf_match.domain_id' in 'where clause', 1054
After getting the error on a "real" set of data, I did a clean install of 2.2 on my demo server and tried upgrading it, but got the same error.

The error happens when user gets logged out just before running the upgrade utility (or after placing/installing new code), and tries to login back.

This now has been Fixed in r23181.

In other words (technically) error happens whenever a uf_match entry is sought or tried to be created (as this generally happens during login process).

Brian, just to confirm if we talking about same thing can you apply this patch (around line 183) and see if it works -
( Fisheye wasn't reflecting the change so pasting it here )

--- trunk/CRM/Core/BAO/UFMatch.php
+++ trunk/CRM/Core/BAO/UFMatch.php
 
         // make sure that a contact id exists for this user id
         $ufmatch =& new CRM_Core_DAO_UFMatch( );
-        $ufmatch->domain_id = CRM_Core_Config::domainID( );
-        $ufmatch->uf_id     = $userKey;
+        if ( CRM_Core_DAO::checkFieldExists('civicrm_uf_match', 'domain_id') ) {
+            $ufmatch->domain_id = CRM_Core_Config::domainID( );
+        }
+        $ufmatch->uf_id = $userKey;
 

After applying this patch you should be able to visit upgrade url w/o any error.