[Webinar] Streamline your web hosting managementRegister Today

x
?
Solved

One or more fields are not installed properly

Posted on 2011-03-25
3
Medium Priority
?
498 Views
Last Modified: 2012-06-27
I tried this query with CAML editor, and it shows me that error, I know the column exist, and that its written correctly

<Query><Where><And><Eq><FieldRef Name="Item_x0020_Language" /><Value Type="Choice">Nederlands</Value></Eq></And></Where><OrderBy><FieldRef Name="Created" Ascending="False" /></OrderBy></Query>
0
Comment
Question by:Simbios
3 Comments
 
LVL 32

Expert Comment

by:Jamie McAllister MVP
ID: 35216614
You usually get that error when the CAML query is malformed, or the parser doesn't like something else about it.

If you're using this with SPQuery I'd lose the <Query> tags.

Also I'm seeing <And> elements but only a single equals clause inside (AND would expect two), so that's probably the culprit.
0
 
LVL 3

Accepted Solution

by:
Nomoho earned 2000 total points
ID: 35216621
Hello,

Try to remove one field from the query to see if it is:
Created or Item_x0020_Language which is wrong.

When you found which one (or two) of these field is wrong, find its real name and correct it.
Sometimes you must add "ows_ " at the beginning of the field names to use them in CAML query.

0
 
LVL 5

Expert Comment

by:navdeepmadan
ID: 35217088
please provide the exact error message and ULS logs.
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

For SharePoint sites, particularly public-facing ones, there are times when adding JavaScript, Meta Tags, CSS Styles or other content to the page <head> section is more practical than modifying master pages.  For instance, you could add the jQuery l…
I thought I'd write this up for anyone who has a request to create an anonymous whistle-blower-type submission form created using SharePoint 2010 (this would probably work the same for 2013). It's not 100% fool-proof but it's as close as you can get…
The Relationships Diagram is a good way to get an overall view of what a database is keeping track of. It is also where relationships are defined. A relationship specifies how two tables connect to each other. As you build tables in Microsoft Ac…
The video will let you know the exact process to import OST/PST files to the cloud based Office 365 mailboxes. Using Kernel Import PST to Office 365 tool, one can quickly import numerous OST/PST files to Office 365. Besides this, the tool also comes…
Suggested Courses

607 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question