U4-4474 - YSOD when expanding Members tree

Created by Sebastiaan Janssen 19 Mar 2014, 11:07:00 Updated by Shannon Deminick 03 Aug 2016, 15:30:53

In 7.1.0 latest commit I get this YSOD in the right panel when I try to expand an alphabet folder in the members section, SQL CE:

Failed to retreive data for child nodes undefined OFFSET clause is invalid unless ORDER BY clause is specified.

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.SqlServerCe.SqlCeException: OFFSET clause is invalid unless ORDER BY clause is specified.

Stack Trace:

at System.Data.SqlServerCe.SqlCeCommand.ProcessResults(Int32 hr) at System.Data.SqlServerCe.SqlCeCommand.CompileQueryPlan() at System.Data.SqlServerCe.SqlCeCommand.ExecuteCommand(CommandBehavior behavior, String method, ResultSetOptions options) at System.Data.SqlServerCe.SqlCeCommand.ExecuteReader(CommandBehavior behavior) at System.Data.SqlServerCe.SqlCeCommand.ExecuteDbDataReader(CommandBehavior behavior) at System.Data.Common.DbCommand.ExecuteReader(CommandBehavior behavior) at StackExchange.Profiling.Data.ProfiledDbCommand.ExecuteDbDataReader(CommandBehavior behavior) in c:\Code\github\SamSaffron\MiniProfiler\StackExchange.Profiling\Data\ProfiledDbCommand.cs:line 235 at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader() at Umbraco.Core.Persistence.Database.d__71.MoveNext() in d:\Dev\Umbraco7\src\Umbraco.Core\Persistence\PetaPoco.cs:line 773 at System.Collections.Generic.List1..ctor(IEnumerable1 collection) at System.Linq.Enumerable.ToList[TSource](IEnumerable1 source) at Umbraco.Core.Persistence.Database.Fetch[T](String sql, Object[] args) in d:\Dev\Umbraco7\src\Umbraco.Core\Persistence\PetaPoco.cs:line 611 at Umbraco.Core.Persistence.Database.Page[T](Int64 page, Int64 itemsPerPage, String sql, Object[] args) in d:\Dev\Umbraco7\src\Umbraco.Core\Persistence\PetaPoco.cs:line 718 at Umbraco.Core.Persistence.Database.Page[T](Int64 page, Int64 itemsPerPage, Sql sql) in d:\Dev\Umbraco7\src\Umbraco.Core\Persistence\PetaPoco.cs:line 726 at Umbraco.Core.Persistence.Repositories.MemberRepository.GetPagedResultsByQuery[TDto](Sql sql, Int32 pageIndex, Int32 pageSize, Int32& totalRecords, Func2 resolveIds) in d:\Dev\Umbraco7\src\Umbraco.Core\Persistence\Repositories\MemberRepository.cs:line 594 at Umbraco.Core.Services.MemberService.FindMembersByDisplayName(String displayNameToMatch, Int32 pageIndex, Int32 pageSize, Int32& totalRecords, StringPropertyMatchType matchType) in d:\Dev\Umbraco7\src\Umbraco.Core\Services\MemberService.cs:line 293 at Umbraco.Web.Trees.MemberTreeController.GetTreeNodes(String id, FormDataCollection queryStrings) in d:\Dev\Umbraco7\src\Umbraco.Web\Trees\MemberTreeController.cs:line 70 at Umbraco.Web.Trees.TreeControllerBase.GetNodes(String id, FormDataCollection queryStrings) in d:\Dev\Umbraco7\src\Umbraco.Web\Trees\TreeControllerBase.cs:line 101 at lambda_method(Closure , Object , Object[] ) at System.Web.Http.Controllers.ReflectedHttpActionDescriptor.ActionExecutor.<>c__DisplayClass13.<GetExecutor>b__c(Object instance, Object[] methodParameters) at System.Web.Http.Controllers.ReflectedHttpActionDescriptor.ActionExecutor.Execute(Object instance, Object[] arguments) at System.Web.Http.Controllers.ReflectedHttpActionDescriptor.<>c__DisplayClass5.<ExecuteAsync>b__4() at System.Threading.Tasks.TaskHelpers.RunSynchronously[TResult](Func1 func, CancellationToken cancellationToken)

Comments

Priority: Major

Type: Bug

State: Fixed

Assignee:

Difficulty: Normal

Category:

Backwards Compatible: True

Fix Submitted:

Affected versions: 7.1.0, 6.2.0

Due in version: 7.1.0, 6.2.0

Sprint:

Story Points:

Cycle: