CiviCRM Community Forums (archive)

Hi,

I am attempting to upgrade from Civi 2.2.7 to 3.0.2 on Drupal 6.1.4. I am following the instructions here: http://wiki.civicrm.org/confluence/display/CRMDOC/Upgrade+Drupal+Sites+to+3.0

When I get to step #7 I go to http://<your_drupal_home>/civicrm/upgrade?reset=1 and it just says "Upgrade CiviCRM to 3.0.2" but doesn't include the Upgrade Now button (or anything else). See the attached screenshot.

When I go to any Civi page I get this error:
Array
(
    [callback] => Array
        (
            [0] => CRM_Core_Error
            [1] => handle
        )

    [code] => -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']"]
)

I confirmed that the CiviCRM module is enabled, so this thread doesn't apply to me:
http://forum.civicrm.org/index.php/topic,9809.msg42370.html#msg42370

The funny thing is, I ran the exact same upgrade process on a test copy of the site without any trouble.

Any thoughts on what is going on here?

Thanks.[/code]

OK, I tried again and it worked. This time I copied the modules/civicrm directory from the test site I successfully upgraded before. I also had to clean out the templates_c directory and chmod 777 the files/upload directory.

Thanks for the quick reply.