CiviCRM Community Forums (archive)

I get a DB error when I'm trying to upgrade.  I recently restored a MySQL database, so I'm thinking it is related to that.  I've seen this error before in the forums and it does seem to be related to changes made to a DB that are external to civicrm, and I don't think it's a 3.0 issue.
I'm using Civicrm 2.2.7, Drupal 6, PHP 5.2.9

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

    DB Error: no such field

    Return to home page.

Error Details:

Array
(
    [callback] => Array
        (
           

• => CRM_Core_Error
[1] => handle
        )

   

=> -19
    [message] => DB Error: no such field
    [mode] => 16
    [debug_info] => SELECT *
 FROM civicrm_preferences
 
 WHERE (  civicrm_preferences.domain_id = 1 )  AND (  civicrm_preferences.is_domain = 1 )
 
 
 
 [nativecode=1054 ** Unknown column 'civicrm_preferences.domain_id' in 'where clause']
    [type] => DB_Error
    [user_info] => SELECT *
 FROM civicrm_preferences
 
 WHERE (  civicrm_preferences.domain_id = 1 )  AND (  civicrm_preferences.is_domain = 1 )
 
 
 
 [nativecode=1054 ** Unknown column 'civicrm_preferences.domain_id' in 'where clause']
    [to_string] => [db_error: message="DB Error: no such field" code=-19 mode=callback callback=CRM_Core_Error::handle prefix="" info="SELECT *
 FROM civicrm_preferences
 
 WHERE (  civicrm_preferences.domain_id = 1 )  AND (  civicrm_preferences.is_domain = 1 )
 
 
 
 [nativecode=1054 ** Unknown column 'civicrm_preferences.domain_id' in 'where clause']"]