Error Message - Field type Int is not installed properly. Go to the list settings page to delete this field

Question

I saw similar post on SO but it didn't worked out for me. I've created a List Definition project in VS. On one of the fields I set type to Int instead of Integer, and tried to deploy List Definition.

<Field ID="{FD283A24-9FD2-430C-938E-5B180473A141}" Name="NewServiceOfferingsActual" DisplayName="New Service offerings" Type="Int" />

After that I got this exception message. Now the problem is, I can't go to list settings page and delete this field, because I don't have list instance at all.

I can't find ContentType in Site Content Types either

<ContentType
    ID="0x0100B15B5CBA84DA48B2B2E0DC0011BEEE88"
    Name="ServiceOfferings"
    Description="Service Offerings"
    Group="Custom Content Types">

There is no Content Type with the name ServiceOfferings.

I tried to find this field using approach suggested in similar post, but in generated XML file I can't seem to find the Field by it's name nor by ID.

I've checked all my Content Types, neither have this field.

I've even generated CSV file, that contains detailed information about fields of content types in my site collection, but again I can't seem to find the field.

set-variable -option constant -name url -value "http://myserver"
set-variable -option constant -name out -value "c:\ListOfAllCTs.csv"  
# End of settings

$site = new-object Microsoft.SharePoint.SPSite($url)
$cts = $site.rootweb.ContentTypes
echo "Processing..."

'"CT Name"' + `
',"CT ID"' + `
',"CT Description"' + `
',"CT Group"' +
',"Field Title"' + `
',"Field Internal Name"' + `
',"Field ID"' + `
',"Field Group"' + `
',"Field Max Length"' + `
',"Field Description"' | Out-File c:ListOfAllCTs.csv 

ForEach ($id in $cts)
{
      ForEach ($field in $id.Fields)
      {

            '"' + $id.Name + `
            '","' + $id.Id + `
            '","' + $id.Description + `
            '","' + $id.Group + `
            '","' + $field.Title + `
            '","' + $field.InternalName + `
            '","' + $field.Id + `
            '","' + $field.Group + `
            '","' + $field.MaxLength + `
            '","' + $field.Description + `
            '"' | Out-File c:ListOfAllCTs.csv -append

      }

}

$site.Dispose()

echo "Finished!"

I know I can restore the backup of Site Collection, but it's the last thing I'd like to do. I'm using SharePoint Foundation 2010.

So, how this field can be removed ? I'm getting exceptions whenever I try to navigate to Site Columns Gallery, and I can't add new columns to content types.

Answer 1

I had same issue before and this approach worked for me(To delete the column from Content DB, look for these lines in the article below:

SELECT * FROM [ContentDBName of Site collection ].[dbo].[ContentTypes] WHERE Definition Like ‘%GuiId of your site column%’

Delete FROM [ContentDBName of Site collection ].[dbo].[ContentTypes] WHERE Definition Like ‘%GuiId of your site column%’.

http://abdulazizfarooqi.wordpress.com/2012/07/13/remove-sitecolumn-through-guid-2010remove-corrupted-site-columnfield-type-xxxxx-is-not-installed-properly-go-to-the-list-settings-page-to-delete-this-field-sharepoint2010/