Dear all,

Umbraco version: 7.2.4 and 7.2.6

I recieve the following error when I try to open the "Users" or "User permissions" node in the Users section.

Error:

I have no idea since when I started to receive the error and I also only receive it on my local environment, not on my test environment.

First I upgraded umbraco to umbraco 7.2.6 but this didn't solve my problem.

I traced my SQL server while opening the users node on the test environment to see which query is being executed. I then tried to execute the same qeury on my local machine and it return my results as expected. Query:

DECLARE @0 bigint,
@1 bigint

SET @0 = 0
SET @1 = 2147483647

    SELECT * 
    FROM (
            SELECT ROW_NUMBER() OVER (ORDER BY ([umbracoUser].[userLogin])) peta_rn, *
            FROM [umbracoUser]
        ) peta_paged 
    WHERE peta_rn > @0
    AND peta_rn <= @1

I have also looked into the code:

protected override IEnumerable<IUser> PerformGetAll(params int[] ids)
        {
            if (ids.Any())
            {
                return PerformGetAllOnIds(ids);
            }

            var sql = GetBaseQuery(false);

            return ConvertFromDtos(Database.Fetch<UserDto, User2AppDto, UserDto>(new UserSectionRelator().Map, sql));
        }

And I think the error is thrown in the "ConvertFromDtos" function.

Does anyone has ever seen this error before?

Is there an alternative solution to my problem, maybe copying some dll's from the test environment to my local environment...

Kind regards,

Jochen