Sign in Register
Go to solution
Copied to clipboard

Flag this post as spam?

This post will be reported to the moderators as potential spam to be looked at


  • David McDonnell 53 posts 251 karma points
    Jun 28, 2018 @ 15:33
    David McDonnell
    0

    Upgrade 7.5.14 to 7.6.0

    Using Umbraco And Getting Started
    Umbraco 7

    Hi all I am upgrading from version 7.5.14 to 7.6.0 and receiving the following error at the end of the update and when trying to load the site afterwards

    [SystemException: Read MediaType failed System.SystemException: Read MediaType failed System.Exception: Exception while creating a value. ---> System.InvalidOperationException: There is already an open DataReader associated with this Command which must be closed first. at System.Data.SqlClient.SqlInternalConnectionTds.ValidateConnectionForExecute(SqlCommand command) at System.Data.SqlClient.SqlCommand.ValidateCommand(String method, Boolean async) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource1 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 StackExchange.Profiling.Data.ProfiledDbCommand.ExecuteDbDataReader(CommandBehavior behavior) in c:\Code\github\SamSaffron\MiniProfiler\StackExchange.Profiling\Data\ProfiledDbCommand.cs:line 248 at Umbraco.Core.Persistence.PetaPocoCommandExtensions.<>c__DisplayClass4.<ExecuteReaderWithRetry>b__3() at Umbraco.Core.Persistence.FaultHandling.RetryPolicy.ExecuteAction[TResult](Func1 func) at Umbraco.Core.Persistence.Database.

    [HttpException (0x80004005): Read MediaType failed System.SystemException: Read MediaType failed System.Exception: Exception while creating a value. ---> System.InvalidOperationException: There is already an open DataReader associated with this Command which must be closed first. at System.Data.SqlClient.SqlInternalConnectionTds.ValidateConnectionForExecute(SqlCommand command) at System.Data.SqlClient.SqlCommand.ValidateCommand(String method, Boolean async) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource1 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 StackExchange.Profiling.Data.ProfiledDbCommand.ExecuteDbDataReader(CommandBehavior behavior) in c:\Code\github\SamSaffron\MiniProfiler\StackExchange.Profiling\Data\ProfiledDbCommand.cs:line 248 at Umbraco.Core.Persistence.PetaPocoCommandExtensions.<>c__DisplayClass4.<ExecuteReaderWithRetry>b__3() at Umbraco.Core.Persistence.FaultHandling.RetryPolicy.ExecuteAction[TResult](Func1 func) at Umbraco.Core.Persistence.Database.

    [HttpException (0x80004005): Read MediaType failed System.SystemException: Read MediaType failed System.Exception: Exception while creating a value. ---> System.InvalidOperationException: There is already an open DataReader associated with this Command which must be closed first. at System.Data.SqlClient.SqlInternalConnectionTds.ValidateConnectionForExecute(SqlCommand command) at System.Data.SqlClient.SqlCommand.ValidateCommand(String method, Boolean async) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource1 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 StackExchange.Profiling.Data.ProfiledDbCommand.ExecuteDbDataReader(CommandBehavior behavior) in c:\Code\github\SamSaffron\MiniProfiler\StackExchange.Profiling\Data\ProfiledDbCommand.cs:line 248 at Umbraco.Core.Persistence.PetaPocoCommandExtensions.<>c__DisplayClass4.<ExecuteReaderWithRetry>b__3() at Umbraco.Core.Persistence.FaultHandling.RetryPolicy.ExecuteAction[TResult](Func1 func) at Umbraco.Core.Persistence.Database.

    Copy Link
  • David McDonnell 53 posts 251 karma points
    Jun 28, 2018 @ 16:20
    David McDonnell
    0

    this particular error seems to be related to usync, have updated it to latest version but am receiving an new error now. the headerBackground property is a Media Picker property on a doc type

    [InvalidOperationException: Value "{ "focalPoint": { "left": 0.5, "top": 0.5 }, "src": "/media/3907/femal-header.jpg", "crops": [ { "alias": "thumbnail", "width": 400, "height": 300 }, { "alias": "mobile", "width": 200, "height": 150 }, { "alias": "desktopjumbotron", "width": 1920, "height": 470 }, { "alias": "halfarticle", "width": 750, "height": 240 }, { "alias": "quaterarticle", "width": 360, "height": 230 }, { "alias": "thirdarticle", "width": 500, "height": 300 }, { "alias": "fullwidth", "width": 1200, "height": 450 }, { "alias": "fullarticle", "width": 1200, "height": 400 } ] }" of type "System.String" could not be converted to type "System.Int32" which is expected by property type "headerBackground".] Umbraco.Core.Models.Property.ThrowTypeException(Object value, Type expected, String alias) +177 Umbraco.Core.Models.Property.set_Value(Object value) +701 Umbraco.Core.Persistence.Factories.PropertyFactory.BuildEntity(IReadOnlyCollection1 dtos, PropertyType[] compositionTypeProperties, DateTime createDate, DateTime updateDate) +442 Umbraco.Core.Persistence.Repositories.VersionableRepositoryBase2.GetPropertyCollection(PagingSqlQuery pagingSqlQuery, IReadOnlyCollection1 documentDefs) +2363 Umbraco.Core.Persistence.Repositories.ContentRepository.ProcessQuery(Sql sqlFull, PagingSqlQuery pagingSqlQuery, Boolean withCache, Boolean includeAllVersions) +2072 Umbraco.Core.Persistence.Repositories.ContentRepository.<GetPagedResultsByQuery>b__54(Sql sqlFull, PagingSqlQuery1 pagingSqlQuery) +17 Umbraco.Core.Persistence.Repositories.VersionableRepositoryBase2.GetPagedResultsByQuery(IQuery1 query, Int64 pageIndex, Int32 pageSize, Int64& totalRecords, Tuple2 nodeIdSelect, Func3 processQuery, String orderBy, Direction orderDirection, Boolean orderBySystemField, Func1 defaultFilter) +1796 Umbraco.Core.Persistence.Repositories.ContentRepository.GetPagedResultsByQuery(IQuery1 query, Int64 pageIndex, Int32 pageSize, Int64& totalRecords, String orderBy, Direction orderDirection, Boolean orderBySystemField, IQuery1 filter) +762 Umbraco.Core.Services.ContentService.GetPagedDescendants(Int32 id, Int64 pageIndex, Int32 pageSize, Int64& totalChildren, String orderBy, Direction orderDirection, Boolean orderBySystemField, String filter) +1518 Umbraco.Core.Services.ContentService.GetPagedDescendants(Int32 id, Int64 pageIndex, Int32 pageSize, Int64& totalChildren, String orderBy, Direction orderDirection, String filter) +57 UmbracoExamine.UmbracoContentIndexer.PerformIndexAll(String type) +1169 UmbracoExamine.BaseUmbracoIndexer.IndexAll(String type) +76 UmbracoExamine.BaseUmbracoIndexer.PerformIndexRebuild() +111 UmbracoExamine.BaseUmbracoIndexer.RebuildIndex() +69 Umbraco.Web.WebBootManager.<InitializeResolvers>b__f() +156 Umbraco.Core.Sync.DatabaseServerMessenger.Initialize() +768 Umbraco.Web.BatchedDatabaseServerMessengerStartup.ApplicationStarted(UmbracoApplicationBase umbracoApplication, ApplicationContext applicationContext) +87 Umbraco.Core.ApplicationEventHandler.OnApplicationStarted(UmbracoApplicationBase umbracoApplication, ApplicationContext applicationContext) +50 Umbraco.Core.CoreBootManager.<Complete>b__a(IApplicationEventHandler x) +381 Umbraco.Core.EnumerableExtensions.ForEach(IEnumerable1 items, Action1 action) +166 Umbraco.Core.CoreBootManager.Complete(Action1 afterComplete) +419 Umbraco.Web.WebBootManager.Complete(Action`1 afterComplete) +137 Umbraco.Core.UmbracoApplicationBase.StartApplication(Object sender, EventArgs e) +364

    [HttpException (0x80004005): Value "{ "focalPoint": { "left": 0.5, "top": 0.5 }, "src": "/media/3907/femal-header.jpg", "crops": [ { "alias": "thumbnail", "width": 400, "height": 300 }, { "alias": "mobile", "width": 200, "height": 150 }, { "alias": "desktopjumbotron", "width": 1920, "height": 470 }, { "alias": "halfarticle", "width": 750, "height": 240 }, { "alias": "quaterarticle", "width": 360, "height": 230 }, { "alias": "thirdarticle", "width": 500, "height": 300 }, { "alias": "fullwidth", "width": 1200, "height": 450 }, { "alias": "fullarticle", "width": 1200, "height": 400 } ] }" of type "System.String" could not be converted to type "System.Int32" which is expected by property type "headerBackground".] System.Web.HttpApplicationFactory.EnsureAppStartCalledForIntegratedMode(HttpContext context, HttpApplication app) +535 System.Web.HttpApplication.RegisterEventSubscriptionsWithIIS(IntPtr appContext, HttpContext context, MethodInfo[] handlers) +166 System.Web.HttpApplication.InitSpecial(HttpApplicationState state, MethodInfo[] handlers, IntPtr appContext, HttpContext context) +169 System.Web.HttpApplicationFactory.GetSpecialApplicationInstance(IntPtr appContext, HttpContext context) +372 System.Web.Hosting.PipelineRuntime.InitializeApplication(IntPtr appContext) +329

    [HttpException (0x80004005): Value "{ "focalPoint": { "left": 0.5, "top": 0.5 }, "src": "/media/3907/femal-header.jpg", "crops": [ { "alias": "thumbnail", "width": 400, "height": 300 }, { "alias": "mobile", "width": 200, "height": 150 }, { "alias": "desktopjumbotron", "width": 1920, "height": 470 }, { "alias": "halfarticle", "width": 750, "height": 240 }, { "alias": "quaterarticle", "width": 360, "height": 230 }, { "alias": "thirdarticle", "width": 500, "height": 300 }, { "alias": "fullwidth", "width": 1200, "height": 450 }, { "alias": "fullarticle", "width": 1200, "height": 400 } ] }" of type "System.String" could not be converted to type "System.Int32" which is expected by property type "headerBackground".] System.Web.HttpRuntime.FirstRequestInit(HttpContext context) +525 System.Web.HttpRuntime.EnsureFirstRequestInit(HttpContext context) +118 System.Web.HttpRuntime.ProcessRequestNotificationPrivate(IIS7WorkerRequest wr, HttpContext context) +708

    Copy Link
  • David McDonnell 53 posts 251 karma points
    Jul 09, 2018 @ 13:55
    David McDonnell
    100

    Thanks to Paul Seal for this post, resolved my issues with upgrading.

    https://codeshare.co.uk/blog/how-to-upgrade-umbraco-safely/

    Cheers David

    Copy Link
Please Sign in or register to post replies

Write your reply to:

Draft