Monday, January 14, 2008

"One or more field types are not installed properly. Go to the list settings page to delete these field" error from SPQuery

When using SPQuery often one might often encounter this error. This errror is caused because the field that you are refrencing in your CAML query is repersented differently internally. This can be because either you renamed a column or another site column with the same name exists.

Though the Display name of the column may be the say the internal column name can be different in SharePoint. SPQuery Fieldref requires the internal column name in order to perform the query. Remedies for this error are,

1. Use the U2UCamlQueryBuilder to re-construct the query and determine the actual internal field name or
2. Delete the field and recreate it.

Happy coding :-)

Monday, January 14, 2008

"One or more field types are not installed properly. Go to the list settings page to delete these field" error from SPQuery

When using SPQuery often one might often encounter this error. This errror is caused because the field that you are refrencing in your CAML query is repersented differently internally. This can be because either you renamed a column or another site column with the same name exists.

Though the Display name of the column may be the say the internal column name can be different in SharePoint. SPQuery Fieldref requires the internal column name in order to perform the query. Remedies for this error are,

1. Use the U2UCamlQueryBuilder to re-construct the query and determine the actual internal field name or
2. Delete the field and recreate it.

Happy coding :-)