SharePoint 2010: One or More Field Types are not Installed Properly. Go to the List Settings Page to Delete These Fields in Executing CAML Queries

SharePoint 2010: One or More Field Types are not Installed Properly. Go to the List Settings Page to Delete These Fields in Executing CAML Queries

Hi,

An issue was reported to me where a developer was trying to use a  CAML query and was getting this error:
"One or more field types are not installed properly. Go to the list settings page to delete these fields". I checked the fields and they were fine. I executed a few other queries and found that they were working fine. This was a clear indication that there was something wrong in the query rather than in the list settings. I found that the query had a column "Approval Status". To verify whether it is causing the issue or not I executed a small piece of code to get the internal name and I found that the internal name of this field is "_ModerationStatus". I changed the value in the query and it worked fine.

 I am attaching a small piece of code for reference:

SPQuery query = new SPQuery();
                String camlQuery = "<Where><Eq><FieldRef Name='_ModerationStatus'/><Value Type='Text'>Pending</Value></Eq></Where>";
                query.Query = camlQuery;
                SPListItemCollection items = list.GetItems(query);

I hope this will help you out.

Thanks,
Rahul Rashu
Leave a Comment
  • Please add 6 and 5 and type the answer here:
  • Post
Wiki - Revision Comment List(Revision Comment)
Sort by: Published Date | Most Recent | Most Useful
Comments
  • Richard Mueller edited Revision 5. Comment: Change tag "SPS 2010" to "SharePoint 2010"

  • Richard Mueller edited Revision 4. Comment: Fixed grammar, changed tag "SharePoint 2007 (en-US)" to "SharePoint 2007"

  • Richard Mueller edited Revision 3. Comment: Replaced RGB values with color names in HTML to restore colors

  • Richard Mueller edited Revision 2. Comment: Modified title casing, removed (en-US) from title, added tag

  • Gokhan Ozcifci edited Revision 1. Comment: Great article, juste changed the title and add tags

  • Craig Lussier edited Original. Comment: added tags

Page 1 of 1 (6 items)
Wikis - Comment List
Sort by: Published Date | Most Recent | Most Useful
Posting comments is temporarily disabled until 10:00am PST on Saturday, December 14th. Thank you for your patience.
Comments
  • Craig Lussier edited Original. Comment: added tags

  • Gokhan Ozcifci edited Revision 1. Comment: Great article, juste changed the title and add tags

  • This helped me a lot :)

  • Richard Mueller edited Revision 2. Comment: Modified title casing, removed (en-US) from title, added tag

  • Richard Mueller edited Revision 3. Comment: Replaced RGB values with color names in HTML to restore colors

  • Richard Mueller edited Revision 4. Comment: Fixed grammar, changed tag "SharePoint 2007 (en-US)" to "SharePoint 2007"

  • Richard Mueller edited Revision 5. Comment: Change tag "SPS 2010" to "SharePoint 2010"

Page 1 of 1 (7 items)