Welcome to the DNN Community Forums, your preferred source of online community support for all things related to DNN.
In order to participate you must be a registered DNNizen

HomeHomeUsing DNN Platf...Using DNN Platf...Administration ...Administration ...dnn search "no results found" after updatingdnn search "no results found" after updating
Previous
 
Next
New Post
2/6/2014 3:41 PM
 

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)
 
New Post
2/6/2014 4:36 PM
 
AssemblyVersion:7.2.1

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.com/SearchResults/tabid/81...

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

DefaultDataProvider:DotNetNuke.Data.SqlDataProvider, DotNetNuke



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:
 
New Post
2/6/2014 4:37 PM
 

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:

 
New Post
2/7/2014 5:19 AM
 
it looks like there is a mismatch of data in your database, maybe caused by an upgrade script that failed. The procedure that fails is GetGroupedDetailViews, but maybe re-indexing search in Admin > Search Administration already solves the issue.

Cheers from Germany,
Sebastian Leupold (Microsoft MVP)

dnnWerk - The DotNetNuke Experts   German Spoken DotNetNuke User Group

Speed up your DNN Websites with TurboDNN
 
New Post
3/31/2014 2:11 PM
 
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.
 
Previous
 
Next
HomeHomeUsing DNN Platf...Using DNN Platf...Administration ...Administration ...dnn search "no results found" after updatingdnn search "no results found" after updating


These Forums are dedicated to discussion of DNN Platform and Evoq Solutions.

For the benefit of the community and to protect the integrity of the ecosystem, please observe the following posting guidelines:

  1. No Advertising. This includes promotion of commercial and non-commercial products or services which are not directly related to DNN.
  2. No vendor trolling / poaching. If someone posts about a vendor issue, allow the vendor or other customers to respond. Any post that looks like trolling / poaching will be removed.
  3. Discussion or promotion of DNN Platform product releases under a different brand name are strictly prohibited.
  4. No Flaming or Trolling.
  5. No Profanity, Racism, or Prejudice.
  6. Site Moderators have the final word on approving / removing a thread or post or comment.
  7. English language posting only, please.

Content Layout

Subscribe to DNN Digest

DNN Digest is our monthly email newsletter. It highlights news and content from around the DNN ecosystem, such as new modules and themes, messages from leadership, blog posts and notable tweets. Keep your finger on the pulse of the ecosystem by subscribing.  


Copyright 2017 by DNN Corp Terms of Use Privacy
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out