U4-10364 - SQL error occurs when we attempt to sort media items by "Created by" column

Created by kensley lewis 28 Aug 2017, 21:27:00 Updated by kensley lewis 28 Sep 2017, 19:34:06

Tags: Unscheduled Regression

Subtask of: U4-9609

Your report will have a greater chance of being addressed if you can give us clear steps to reproduce the issue, please answer the following questions in as much detail as possible:

What did you do?

  • Downloaded and installed Umbraco 7.6.5 via Nuget. Logged in as an administrator. Went to the Media section. Uploaded multiple images to a new folder. Attempted to sort my media items by "Created by"

What did you expect to happen?

  • When I click on the column "Created By" I expect it sort by creator

What actually happened?

  • Instead the failed and went to a error page. The Umbraco error logs printed this out....
 2017-08-28 17:21:58,562 [P18888/D2/T112] ERROR Umbraco.Core.Persistence.UmbracoDatabase - Exception (ce5ce870).
System.Data.SqlClient.SqlException (0x80131904): The multi-part identifier "cmsDocument.published" could not be bound.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
   at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
   at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData()
   at System.Data.SqlClient.SqlDataReader.get_MetaData()
   at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption)
   at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
   at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
   at Umbraco.Core.Persistence.PetaPocoCommandExtensions.<>c__DisplayClass4.<ExecuteReaderWithRetry>b__3()
   at Umbraco.Core.Persistence.FaultHandling.RetryPolicy.ExecuteAction[TResult](Func`1 func)
   at Umbraco.Core.Persistence.Database.<Query>d__7`1.MoveNext()
Error Number:4104,State:1,Class:16


kensley lewis 28 Aug 2017, 21:29:58

I'm on Windows 10, running IIS7 and using .NET 4.6. Framework. This issue appears to happen with all installations I have tried within the Umbraco 7 series.

Shannon Deminick 27 Sep 2017, 13:01:23

Regression issue was due to a merge problem at some stage

PR: https://github.com/umbraco/Umbraco-CMS/pull/2222

kensley lewis 28 Sep 2017, 19:34:06

Understood and thanks for tracking down the issue!

Priority: Normal

Type: Bug

State: Fixed


Difficulty: Normal

Category: UI

Backwards Compatible: True

Fix Submitted: None

Affected versions: 7.6.5

Due in version: 7.7.2, 7.6.9

Sprint: Sprint 68

Story Points: 0.5