Hi,

I'm using mojoportal 2.2.7.6 on windows with MSSQL backend.

When opening MemberList.aspx I get SqlException because a user with name longer than 50 characters exist. When creating temporary table #PageIndexForUsers in the [mp_Users_SelectPage] body UserName field is only 50 characters long. An exec sql statement fails

exec mp_Users_SelectPage @pageNumber=1, @pageSize=20, @usernameBeginsWith='', @siteId=1

Msg 8152, Level 16, State 13, Procedure mp_Users_SelectPage, Line 39
String or binary data would be truncated.
The statement has been terminated.

(0 row(s) affected)

So the table #PageIndexForUsers should be defined like this

CREATE TABLE #PageIndexForUsers
(
IndexID int IDENTITY (1, 1) NOT NULL,
UserName nvarchar(100) COLLATE DATABASE_DEFAULT,
LoginName nvarchar(50) COLLATE DATABASE_DEFAULT
)

to stay in sync with mp_Users table.

Thanks,

Misha