After upgrading to V9.1.1 the user search was not working at all. I have read many posts that the email search was not working for users but for me a search for anything would always return no results.

After many attempts to get this working and much reading I realised the user search uses the global site indexing. After following a guide on optimising your site for performance many years ago I had turned off the site indexing. So I turned this back on and now I get the following error appearing in the log. The user search does not work still but I do see the search index files being created.

Is the user search still not working due to this error or is it something else.

01/13/2018 10:02:03
General Exception


AbsoluteURL DefaultDataProvider DotNetNuke.Data.SqlDataProvider DotNetNuke
AbsoluteURL:

DefaultDataProvider:DotNetNuke.Data.SqlDataProvider, DotNetNuke

ExceptionGUID:84c55bfb-acc7-4553-a38c-8fba78db9caa

AssemblyVersion:

PortalId:-1

UserId:-1

TabId:-1

RawUrl:

Referrer:

UserAgent:

ExceptionHash:yKZ4uGkJm0wtkKybdaaPkNikGA8=

Message:Object reference not set to an instance of an object.

StackTrace:

at DotNetNuke.Services.Search.ModuleIndexer.ConvertSearchItemInfoToSearchDocument(SearchItemInfo searchItem) at System.Linq.Enumerable.WhereSelectEnumerableIterator`2.MoveNext() at System.Collections.Generic.List`1..ctor(IEnumerable`1 collection) at System.Linq.Enumerable.ToList[TSource](IEnumerable`1 source) at DotNetNuke.Services.Search.SearchDataStore.StoreSearchItems(SearchItemInfoCollection searchItems) at DotNetNuke.Services.Search.SearchEngine.IndexContent() at DotNetNuke.Services.Search.SearchEngineScheduler.DoWork()
InnerMessage:

InnerStackTrace:

Source:DotNetNuke

FileName:

FileLineNumber:0

FileColumnNumber:0

Method:

Server Name: dedi7

This is still an issue for me, if anyone has any suggestions of how I might try and investigate this, any help at all would be appreciated. As it stands I have to query the database directly, get the user ID and reverse that back, this really is not ideal.

Change the stored procedure ([Personabar_GetUsersBySearchTerm])

From this:

IF @SearchTerm = N'' SET @SearchTerm = Null; -- Normalize parameter


To This:

IF @SearchTerm = N''

SET @SearchTerm = Null; -- Normalize parameter

ELSE

SET @SearchTerm = @SearchTerm + '%'