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.

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.