One or more field types are not installed properly. Go to the list settings page to delete these fields in executing CAML queries

Question

Hi,

An issues 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"

---

Nour

Answer 1

Usually this is when a field specified in the CAML doesn't exist in the site.  Please check the field names are correct.

---

My SharePoint Blog - http://www.davehunter.co.uk/blog Twitter - @davehunter

Answer 2

can you please provide the caml query and your list fields..

---

Hiren Patel | Please click "Propose As Answer" if this post solves your problem or "Vote As Helpful" if this post has been useful to you.

Answer 3

yes field names are correct 

---

Nour

Answer 4

"<Where><And><Eq><FieldRef Name='الموظف'/><Value Type='User'>" + user[1] +
                                  "</Value></Eq><Geq><FieldRef Name='التاريخ'/><Value Type='DateTime'>" + date +
                                  "</Value></Geq></And></Where>";

field1 : الموظف type : user

field2 :التاريخ type : datetime

---

Nour

Answer 5

Hello Nour,

Can you please check the internal name of the column of your list as shown below,

is it same as you specified in the caml query?

check the internal name as shown bwlo by go to list settings->select column section and mouse hover on the column that will show the internal name of the field on the status bar and used this internal name in the caml query

---

Hiren Patel | Please click "Propose As Answer" if this post solves your problem or "Vote As Helpful" if this post has been useful to you.

Answer 6

Hi Nour,

As mentioned by Hiren, this issue is due to the internal name of the field that was not matched with the FieldRef Name used in the Caml query. You can also get the internal name of the field using the below code.

string str = list.Fields["Display Name"].InternalName;

Use this internal name of the field in the caml query for all the fields used in the query. This will resolve this issue.

Thanks,
Dhileep

 

Answer 7

This cause of this error are following:

1. CAML Query is not well formed

2. The Fields present in the query is not present in the List on which the query is fired.

Please check the internal name of the Fields for which you are firing the query. Hope this will help.

---

Sharepoint Sutra
Sharepoint Consultant

Answer 8

Same case happeninig to me, I ve done same in custom list joins .... its working bt in calendar list when i do join and if i try to access one of the projected fields then it gives me problem