U4-6310 - Error when sorting by "last edited" in recycle bin listview

Created by Bjarne Fyrstenborg 22 Feb 2015, 13:35:23 Updated by Shannon Deminick 26 Jun 2017, 07:13:12

Relates to: U4-6934

When you sort nodes in the listview in the recycle bin by "last edited" you get an error:

Server error: Contact administrator, see log for full details.
Failed to retrieve children for media item -21

The server error:

)]}',
{"Message":"An error has occurred.","ExceptionMessage":"The column name is not valid. [ Node name (if any) = ,Column name = updateDate ]","ExceptionType":"System.Data.SqlServerCe.SqlCeException","StackTrace":"   at System.Data.SqlServerCe.SqlCeCommand.ProcessResults(Int32 hr)\r\n   at System.Data.SqlServerCe.SqlCeCommand.CompileQueryPlan()\r\n   at System.Data.SqlServerCe.SqlCeCommand.ExecuteCommand(CommandBehavior behavior, String method, ResultSetOptions options)\r\n   at System.Data.SqlServerCe.SqlCeCommand.ExecuteDbDataReader(CommandBehavior behavior)\r\n   at System.Data.Common.DbCommand.ExecuteReader(CommandBehavior behavior)\r\n   at StackExchange.Profiling.Data.ProfiledDbCommand.ExecuteDbDataReader(CommandBehavior behavior)\r\n   at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader()\r\n   at Umbraco.Core.Persistence.Database.<Query>d__7`1.MoveNext()\r\n   at System.Collections.Generic.List`1..ctor(IEnumerable`1 collection)\r\n   at System.Linq.Enumerable.ToList[TSource](IEnumerable`1 source)\r\n   at Umbraco.Core.Persistence.Database.Fetch[T](String sql, Object[] args)\r\n   at Umbraco.Core.Persistence.Database.Page[T](Int64 page, Int64 itemsPerPage, String sql, Object[] args)\r\n   at Umbraco.Core.Persistence.Database.Page[T](Int64 page, Int64 itemsPerPage, Sql sql)\r\n   at Umbraco.Core.Persistence.Repositories.VersionableRepositoryBase`2.GetPagedResultsByQuery[TDto,TContentBase](IQuery`1 query, Int32 pageIndex, Int32 pageSize, Int32& totalRecords, Tuple`2 nodeIdSelect, Func`2 processQuery, String orderBy, Direction orderDirection, Func`1 defaultFilter)\r\n   at Umbraco.Core.Persistence.Repositories.MediaRepository.GetPagedResultsByQuery(IQuery`1 query, Int32 pageIndex, Int32 pageSize, Int32& totalRecords, String orderBy, Direction orderDirection, String filter)\r\n   at Umbraco.Core.Services.MediaService.GetPagedChildren(Int32 id, Int32 pageIndex, Int32 pageSize, Int32& totalChildren, String orderBy, Direction orderDirection, String filter)\r\n   at Umbraco.Web.Editors.MediaController.GetChildren(Int32 id, Int32 pageNumber, Int32 pageSize, String orderBy, Direction orderDirection, String filter)\r\n   at lambda_method(Closure , Object , Object[] )\r\n   at System.Web.Http.Controllers.ReflectedHttpActionDescriptor.ActionExecutor.<>c__DisplayClass13.<GetExecutor>b__c(Object instance, Object[] methodParameters)\r\n   at System.Web.Http.Controllers.ReflectedHttpActionDescriptor.ActionExecutor.Execute(Object instance, Object[] arguments)\r\n   at System.Web.Http.Controllers.ReflectedHttpActionDescriptor.<>c__DisplayClass5.<ExecuteAsync>b__4()\r\n   at System.Threading.Tasks.TaskHelpers.RunSynchronously[TResult](Func`1 func, CancellationToken cancellationToken)"}

1 Attachments

Comments

Eric Schrepel 18 Mar 2015, 00:25:32

Also, when you have more than one page of items and click "next", same error occurs. Using version 7.2.2. (We've rolled back to not using List View for awhile.)


Shannon Deminick 26 Jun 2017, 07:13:12

Closing issue due to inactivity - see blog post for details https://umbraco.com/blog/issue-tracker-cleanup/


Priority: Normal

Type: Bug

State: Closed

Assignee:

Difficulty: Normal

Category:

Backwards Compatible: True

Fix Submitted:

Affected versions: 7.2.2

Due in version:

Sprint:

Story Points:

Cycle: