Hello,
I have been having issues with my search. A lot of the pages seem to be missing from the search results. I have tried re-indexing, clearing cache etc. through the Host page. That doesn't seem to have helped.
In fact when I click on Re-index, it doesn't seem to do much. The "get more information" link under the search index path field - doesn't seem to update. The field: "
On going into the event logs, I find these interesting entries :
Error ISearchable - get content for dnn search indexer:The
ntext data type cannot be selected as DISTINCT because it is not
comparable. .Net SqlClient Data Provider at
System.Data.SqlClient.SqlConnection.OnError(SqlException exception,
Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning()
at ....
I think it is related. Anyone have any ideas here ?