CiviCRM Community Forums (archive)

Trying to upgrade from 3.1.3 - followed the steps by the letter, but I am receiving this error with both 3.2 and 3.2.1

Any ideas would be appreciated!

Sorry. A non-recoverable error has occurred.
DB Error: no such field
Error Details
Database Error Code: Unknown column 'is_deleted' in 'field list', 1054
Additional Details:

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

    [code] => -19
    [message] => DB Error: no such field
    [mode] => 16
    [debug_info] => SELECT  id, is_deleted  
 FROM civicrm_contact
 
 WHERE (  civicrm_contact.id = 1 )  
 
 
 
 [nativecode=1054 ** Unknown column 'is_deleted' in 'field list']
    [type] => DB_Error
    [user_info] => SELECT  id, is_deleted  
 FROM civicrm_contact
 
 WHERE (  civicrm_contact.id = 1 )  
 
 
 
 [nativecode=1054 ** Unknown column 'is_deleted' 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  id, is_deleted  
 FROM civicrm_contact
 
 WHERE (  civicrm_contact.id = 1 )  
 
 
 
 [nativecode=1054 ** Unknown column 'is_deleted' in 'field list']"]
)

I compared the civicrm_contact table structure - it seems the 3.2 and 3.2.1 both have a 'is_deleted' field, while my current db does not.[/code]

Hi - did you actually get the upgrade screen ? This looks like the message I would expect to see if you were trying to use the DB without having run civicrm/upgrade first.

Note that 3.2.2 should be coming out this week and it contains a fix to the upgrade process so you may be better to do your upgrade on that

Thanks for the prompt response. I am getting that error by going to http://example.com/civicrm/upgrade?reset=1 which is step #8 of the upgrade document

example.com is obviously changed for my site.

And you definitely have clean urls enabled?

Yes - I even tried the http://<drupal core>/?q=civicrm/upgrade&reset=1 and it gets changed to a clean URL.

What is the version value in the civicrm_domain table?

3.1.3

Hmmm - I'm sure the upgrade isn't running. If you are sure the URL is correct & the logged in user has the correct permissions I would try looking in the civicrm_menu table for the civicrm/upgrade path & find out what code it runs & stuck a debug in there to make sure it is running

I am logged in as an administrator, I have all permissions checked in the Drupal roles. When I go to the upgrade page under 3.1.3, it indicates I am already at 3.1.3 with bright green background, so it runs OK under the old version.

Select civicrm_menu data:
path
civicrm/upgrade

path arguments
null

title
Upgrade CiviCRM

access_callback
a:2:{i:0;s:19:"CRM_Core_Permission";i:1;s:9:"checkMenu";}

access_arguments
a:2:{i:0;a:2:{i:0;s:18:"administer CiviCRM";i:1;s:14:"access CiviCRM";}i:1;s:3:"and";}

page_callback
s:24:"CRM_Upgrade_Page_Upgrade";

page_arguments
null

breadcrumb
a:1:{i:0;a:2:{s:5:"title";s:7:"CiviCRM";s:3:"url";s:16:"/civicrm?reset=1";}}
From the original error, it indicates civicrm_contact not finding is_deleted field - is that a difference between the 3.1.3 and 3.2 versions in what fields exist in that table?

Yes, the is_deleted field is new to 3.2.x and I would expect that error going to any page other than the upgrade page. But the upgrade page shouldn't the database to have been upgraded already

Yes, I saw the error on other pages as well. Could you gain any insight from the civicrm_menu data?

NB - I can't see how it could make a difference but you could try the URL with just civicrm/upgrade & drop the &reset=1

Phew - perhaps you could add a note to the troubleshooting part of the upgrade instructions to help someone else if they hit the same problem