Migrating Custom SharePoint Column nightmare

Well I had to migrate custom columns from one SharePoint 2010 environment to another, thanks to the following post, I was able to script it and migrate.

http://get-spscripts.com/2011/01/export-and-importcreate-site-columns-in.html?showComment=1297294835163#c1161922080422697705

Easy right, not so fast, went to check my columns out and got this great error when accessing site columns under site settings

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

Turns out I made a typo and left a column type blank. after scouring the internet, i came across somebody brave enough to delete from the content database.

So I looked in the contenttypes table in the Content DB, found the offending record, deleted it and SharePoint started to work again.

I hope this helps.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s