After updating my dnn CE installation a few times on one of the last updates the search became broken. 

Anyone seen this error can tell me a remedy?  Thanks in advance!

InnerException:The type initializer for 'DotNetNuke.Services.Search.UserIndexer' threw an exception.

FileName:

FileLineNumber:0

FileColumnNumber:0

Method:System.Linq.Enumerable.Single

StackTrace:

Message:

System.TypeInitializationException: The type initializer for 'DotNetNuke.Services.Search.UserIndexer' threw an exception. ---> System.InvalidOperationException: Sequence contains more than one matching element
   at System.Linq.Enumerable.Single[TSource](IEnumerable`1 source, Func`2 predicate)
   at DotNetNuke.Services.Search.UserIndexer..cctor()
   --- End of inner exception stack trace ---
   at DotNetNuke.Services.Search.UserIndexer.GetSearchDocuments(Int32 portalId, DateTime startDate)

AssemblyVersion:7.2.1

PortalID:

PortalName:

UserID:

UserName:

ActiveTabID:

ActiveTabName:Search Results

RawURL:/DesktopModules/internalservices/API/searchService/search?search=news&pageIndex=1&pageSize=15&sortOption=0&culture=en-US

AbsoluteURL:/DesktopModules/internalservices/API/searchService/search

AbsoluteURLReferrer:http://www.domain.com/SearchResults/tabid/81/Default.aspx?Search=news

UserAgent:Mozilla/5.0 (Windows NT 6.1; WOW64; Trident/7.0; EIE10;ENUSWOL; rv:11.0) like Gecko

DefaultDataProvider:DotNetNuke.Data.SqlDataProvider, DotNetNuke

ExceptionGUID:

InnerException:Sequence contains more than one matching element

FileName:

FileLineNumber:0

FileColumnNumber:0

Method:System.Linq.Enumerable.Single

StackTrace:

Message:

System.InvalidOperationException: Sequence contains more than one matching element
   at System.Linq.Enumerable.Single[TSource](IEnumerable`1 source, Func`2 predicate)
   at DotNetNuke.Web.InternalServices.SearchServiceController.GetGroupedDetailViews(SearchQuery searchQuery, Int32& totalHits, Boolean& more)
   at DotNetNuke.Web.InternalServices.SearchServiceController.Search(String search, String culture, Int32 pageIndex, Int32 pageSize, Int32 sortOption)

 

Source:

Server Name:

Hello Sebastian,

I am still having this issue, things show up as indexed when I re-index as in it shows modules and content being indexed, just the search is not showing results


DefaultDataProvider:DotNetNuke.Data.SqlDataProvider, DotNetNuke

InnerException:The type initializer for 'DotNetNuke.Services.Search.UserIndexer' threw an exception.

FileName:

FileLineNumber:0

FileColumnNumber:0

Method:System.Linq.Enumerable.Single

StackTrace:

Message:

System.TypeInitializationException: The type initializer for 'DotNetNuke.Services.Search.UserIndexer' threw an exception. ---> System.InvalidOperationException: Sequence contains more than one matching element
at System.Linq.Enumerable.Single[TSource](IEnumerable`1 source, Func`2 predicate)
at DotNetNuke.Services.Search.UserIndexer..cctor()
--- End of inner exception stack trace ---
at DotNetNuke.Services.Search.UserIndexer.GetSearchDocuments(Int32 portalId, DateTime startDate)

I did an update at one time I believe to that beta version which is when it caused this problem. I am wondering if I just copy stored procedures from a good working installation into the database to overwrite existing functions potentially I just want to be sure this would work and which functions would be the ones to overwrite if needed so it shows results in the search function again.