Products

Solutions

Resources

Partners

Community

About

New Community Website

Ordinarily, you'd be at the right spot, but we've recently launched a brand new community website... For the community, by the community.

Yay... Take Me to the Community!

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 ...HELP! USER SEARCH NOT WORKING DNN 9.2.2HELP! USER SEARCH NOT WORKING DNN 9.2.2
Previous
 
Next
New Post
12/24/2018 11:52 AM
 

Hi and Happy Hollidays,

I have some time off and time to work on my non-profit association website.

I just upgraded the site from 9.1 to 9.2.2. At the begining , ia was able to search users from the peronabar search, but now, when the search field is empty, it displayed all the users. As soon as I type one character, the list become empty.

I followed the suggestion to clear the app_data\Search folder and reindex the site with no success.

I went to the SQL server and executed the following code:

USE [apsqadmin]

GO

DECLARE @return_value int

EXEC @return_value = [dbo].[DNN_Personabar_GetUsersBySearchTerm]

@PortalId = 0,

@SortColumn = N'Joined',

@SortAscending = 0,

@PageIndex = 0,

@PageSize = 10,

@SearchTerm = N'St',

@authorized = Null,

@isDeleted = Null,

@Superusers = Null

SELECT 'Return Value' = @return_value

GO

Return 0 row.

If I rexecute the code with @SearchTerm = '', it return all the users.

Could someone help me to find what is going wrong? What log file to look for.

Thank you.

 
New Post
12/26/2018 8:09 AM
 
I did some debug this morning with SQL Profiler and a 9.2.0 test installation and found a bug in 9.2.2.

When I type a SearchTerm in V9.2.0, the @SearchTerm = N'St%' and in V9.2.2, the % is missing. If I add manually the % at the end of my research in the personabar, I am able to search for users as a work around.

To see if there is a corruption in my DNN installation, I have upgraded a clean installation and I am getting the same bahavior. The wildcard % is missing in @SearchTerm passed to the SQL data stored procedure.
 
New Post
12/27/2018 2:49 AM
 
Stephan,

thanks for pointing this out. Would you please log the bug here: https://github.com/dnnsoftware/Dnn.Pl...

You could also start a pull request.

Happy DNNing!
Michael

Michael Tobisch
DNN★MVP

dnn-Connect.org - The most vibrant community around the DNN-platform
 
New Post
12/27/2018 5:56 AM
 
First note that in DNN 9.2.x, indexing is no longer necessary, as user search is performed directly in the database (like in DNN 8a nd before).
The stored procedure has been modified on purpose to allow both, left and exact match, i.e. while you are typing the module should add '%' for the search until you hit enter, when search is finished - this allows to search e.g. for Tom without returning Tomic, Tomas, Tomtom etc.
AFAIR search in the database begins after the 3rd letter typed - maybe this border should be dynamic, depending on the number of users registered on the site (there would be a difference, if you are having a few dozen users versus a million)

Cheers from Germany,
Sebastian Leupold

dnnWerk - The DotNetNuke Experts   German Spoken DotNetNuke User Group

Speed up your DNN Websites with TurboDNN
 
New Post
12/27/2018 9:27 AM
 

Obviousely, the % is not added at the end will typing the first 3 characters in 9.2.2. I fixed my site by replacing Dnn.PersonaBar.Users.dll by the one from version 9.2.0.

My sites has more than 2K users, but the one freshly installed has only 3 users including the host account.

I will report the bug.

 
Previous
 
Next
HomeHomeUsing DNN Platf...Using DNN Platf...Administration ...Administration ...HELP! USER SEARCH NOT WORKING DNN 9.2.2HELP! USER SEARCH NOT WORKING DNN 9.2.2


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.
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out