Sign in
 
HomeOnline20132010Other VersionsRelated ProductsLibraryForumsGallery
TechCenter >
> 
> 
All site lookup columns disappeared...

Answered All site lookup columns disappeared...

  • Monday, May 07, 2012 5:42 PM
     
     
    Sign In to Vote
    0

    I have a SP 2010 server with a site collection where we create all of our project sites. There is one project site in that site collection that I use as a master and save as a template to create new sites. Last week all custom site columns disappeared from the gallery in that master site. The reason for me is unknown. As a result all site lookup columns in other sites I created from that master are also gone (some inheritance through the template?). The columns exist in individual lists and libraries and no data was lost. They are no longer associated with a site column. It is a huge problem for me as all of the columns are lookup columns and to change something I would have to go to all lists and libraries instead of just single location...

    I found this thread that might suggests that this is more than a single issue:
    http://community.office365.com/en-us/f/153/t/10375.aspx

    Anyone having similar problems? What could possibly cause this? Any ideas how to fix it?


     

All Replies

  • Wednesday, May 09, 2012 7:50 AM
    Moderator
     
     Answered Has Code
    Sign In to Vote
    0

    HI MyLIghtscapes.com,

    Please try to check whether the site columns are set to read only, if the value of read only is true, the columns may be disappeared, you can check this using PowerShell script:

    $site = new object Microsoft.SharePoint.SPSite(“http://siteurl”)
$web = site.RootWeb
$missingField = $web.Fields[“FieldName”]
Write-Host $missingField.ReadOnlyField
$missingField.ReadOnlyField = false
$missingField.Update()

    If it isn’t the issue, do you have any custom solutions or modifications on the site that may effects the columns to be shown?

    Thanks,
    Qiao

    Qiao Wei

    TechNet Community Support