Hi there, I’m attempting to update a v 8.17 instance of Umbraco to 9.0.1.
It’s a fresh project created in Visual Studio that I’m pointing to the 8.17 database.
It looks like it mostly completes and then on the /install?redir I get the following error:
Any ideas here, I’m lost - thank you!
Full text dump is as follows:
System.Data.SqlClient.SqlException (0x80131904): Invalid column name ‘passwordConfig’. Invalid column name ‘securityStampToken’. Invalid column name ‘emailConfirmedDate’. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action
1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action1 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) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) at System.Data.SqlClient.SqlCommand.ExecuteScalar() at StackExchange.Profiling.Data.ProfiledDbCommand.ExecuteScalar() in C:\projects\dotnet\src\MiniProfiler.Shared\Data\ProfiledDbCommand.cs:line 343 at Umbraco.Cms.Infrastructure.Persistence.FaultHandling.FaultHandlingDbCommand.b__32_0() at Umbraco.Cms.Infrastructure.Persistence.FaultHandling.RetryPolicy.ExecuteAction[TResult](Func1 func) at Umbraco.Cms.Infrastructure.Persistence.FaultHandling.FaultHandlingDbCommand.ExecuteScalar() at NPoco.Database.ExecuteScalarHelper(DbCommand cmd) at NPoco.Database.ExecuteScalar[T](String sql, CommandType commandType, Object[] args) at NPoco.Database.ExecuteScalar[T](Sql Sql) at NPoco.Database.ExecuteScalar[T](String sql, Object[] args) at NPoco.Database.PageImp[T,TRet](Int64 page, Int64 itemsPerPage, String sql, Object[] args, Func3 executeQueryFunc) at NPoco.Database.Page[T](Int64 page, Int64 itemsPerPage, String sql, Object args) at NPoco.Database.Page[T](Int64 page, Int64 itemsPerPage, Sql sql) at Umbraco.Cms.Infrastructure.Persistence.Repositories.Implement.ContentRepositoryBase3.GetPage[TDto](IQuery1 query, Int64 pageIndex, Int32 pageSize, Int64& totalRecords, Func2 mapDtos, Sql1 filter, Ordering ordering) at Umbraco.Cms.Infrastructure.Persistence.Repositories.Implement.MemberRepository.GetPage(IQuery1 query, Int64 pageIndex, Int32 pageSize, Int64& totalRecords, IQuery1 filter, Ordering ordering) at Umbraco.Cms.Infrastructure.PublishedCache.Persistence.NuCacheContentRepository.RebuildMemberDbCache(IContentCacheDataSerializer serializer, Int32 groupSize, IReadOnlyCollection1 contentTypeIds) at Umbraco.Cms.Infrastructure.PublishedCache.Persistence.NuCacheContentRepository.Rebuild(IReadOnlyCollection1 contentTypeIds, IReadOnlyCollection1 mediaTypeIds, IReadOnlyCollection1 memberTypeIds) at Umbraco.Cms.Infrastructure.PublishedCache.Persistence.NuCacheContentService.Rebuild(IReadOnlyCollection1 contentTypeIds, IReadOnlyCollection1 mediaTypeIds, IReadOnlyCollection1 memberTypeIds) at Umbraco.Cms.Infrastructure.PublishedCache.Persistence.NuCacheContentService.RebuildDatabaseCacheIfSerializerChanged() at Umbraco.Cms.Infrastructure.PublishedCache.NuCacheStartupHandler.Handle(UmbracoApplicationStartingNotification notification) at Umbraco.Cms.Core.Events.EventAggregator.PublishCore(IEnumerable1 allHandlers, INotification notification) at Umbraco.Cms.Core.Events.EventAggregator.PublishAsync[TNotification](TNotification notification, CancellationToken cancellationToken) at Umbraco.Cms.Infrastructure.Runtime.CoreRuntime.StartAsync(CancellationToken cancellationToken) at Umbraco.Cms.Infrastructure.Runtime.CoreRuntime.RestartAsync() at Umbraco.Cms.Web.BackOffice.Install.InstallApiController.CompleteInstall() at lambda_method519(Closure , Object ) at Microsoft.AspNetCore.Mvc.Infrastructure.ActionMethodExecutor.TaskOfActionResultExecutor.Execute(IActionResultTypeMapper mapper, ObjectMethodExecutor executor, Object controller, Object arguments) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.g__Awaited|12_0(ControllerActionInvoker invoker, ValueTask`1 actionResultValueTask) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.g__Awaited|10_0(ControllerActionInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Rethrow(ActionExecutedContextSealed context) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.InvokeInnerFilterAsync() — End of stack trace from previous location — at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.g__Awaited|24_0(ResourceInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted) at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.Rethrow(ResourceExecutedContextSealed context) at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted) at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.InvokeFilterPipelineAsync() — End of stack trace from previous location — at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.g__Awaited|17_0(ResourceInvoker invoker, Task task, IDisposable scope) at Microsoft.AspNetCore.Routing.EndpointMiddleware.g__AwaitRequestTask|6_0(Endpoint endpoint, Task requestTask, ILogger logger) at Umbraco.Cms.Web.Common.Middleware.BasicAuthenticationMiddleware.InvokeAsync(HttpContext context, RequestDelegate next) at Microsoft.AspNetCore.Builder.UseMiddlewareExtensions.<>c__DisplayClass6_1.<b__1>d.MoveNext() — End of stack trace from previous location — at Umbraco.Cms.Web.BackOffice.Middleware.BackOfficeExternalLoginProviderErrorMiddleware.InvokeAsync(HttpContext context, RequestDelegate next) at Microsoft.AspNetCore.Builder.UseMiddlewareExtensions.<>c__DisplayClass6_1.<b__1>d.MoveNext() — End of stack trace from previous location — at Microsoft.AspNetCore.Builder.Extensions.MapMiddleware.Invoke(HttpContext context) at Microsoft.AspNetCore.Session.SessionMiddleware.Invoke(HttpContext context) at Microsoft.AspNetCore.Session.SessionMiddleware.Invoke(HttpContext context) at Microsoft.AspNetCore.Localization.RequestLocalizationMiddleware.Invoke(HttpContext context) at Microsoft.AspNetCore.Authorization.AuthorizationMiddleware.Invoke(HttpContext context) at Microsoft.AspNetCore.Authentication.AuthenticationMiddleware.Invoke(HttpContext context) at SixLabors.ImageSharp.Web.Middleware.ImageSharpMiddleware.Invoke(HttpContext context) at Microsoft.AspNetCore.Diagnostics.StatusCodePagesMiddleware.Invoke(HttpContext context) at StackExchange.Profiling.MiniProfilerMiddleware.Invoke(HttpContext context) in C:\projects\dotnet\src\MiniProfiler.AspNetCore\MiniProfilerMiddleware.cs:line 121 at Umbraco.Cms.Web.Common.Middleware.UmbracoRequestMiddleware.InvokeAsync(HttpContext context, RequestDelegate next) at Umbraco.Cms.Web.Common.Middleware.UmbracoRequestMiddleware.InvokeAsync(HttpContext context, RequestDelegate next) at Microsoft.AspNetCore.Builder.UseMiddlewareExtensions.<>c__DisplayClass6_1.<b__1>d.MoveNext() — End of stack trace from previous location — at Umbraco.Cms.Web.Common.Middleware.PreviewAuthenticationMiddleware.InvokeAsync(HttpContext context, RequestDelegate next) at Microsoft.AspNetCore.Builder.UseMiddlewareExtensions.<>c__DisplayClass6_1.<b__1>d.MoveNext() — End of stack trace from previous location — at Umbraco.Cms.Web.Common.Middleware.UmbracoRequestLoggingMiddleware.InvokeAsync(HttpContext context, RequestDelegate next) at Microsoft.AspNetCore.Builder.UseMiddlewareExtensions.<>c__DisplayClass6_1.<b__1>d.MoveNext() — End of stack trace from previous location — at Microsoft.AspNetCore.Diagnostics.DeveloperExceptionPageMiddleware.Invoke(HttpContext context) ClientConnectionId:25e82933-7cd2-47d0-a3f8-a7a25437757c Error Number:207,State:1,Class:16 HEADERS ======= Accept: application/json, text/plain, / Accept-Encoding: gzip, deflate, br Accept-Language: en-US,en;q=0.9 Connection: close Content-Length: 265 Content-Type: application/json;charset=UTF-8 Cookie: ASP.NET_SessionId=2yfrqgc3fdm1kzhqkyvcjcgv; AMCVS_3A4B7BAF56F01DA67F000101%40AdobeOrg=1; s3_sess=%20s_cc%3Dtrue%3B%20lastPixelLen%3D2022%3B; s3_pers=%20lppn%3D0personal%253Aretirement-planning%253Afinancial-jargon-buster-superannuation0000%7C1625651562675%3B%20lastPage%3D%2528not%2520set%2529%253A%2528not%2520set%2529%253Apersonal%253Aretirement-planning%253Afinancial-jargon-buster-superannuation%7C1625736163707%3B%20s3_lv%3D1625649826981%7C1720257826981%3B%20s3_lv_s%3DFirst%2520Visit%7C1625651626981%3B; AMCV_3A4B7BAF56F01DA67F000101%40AdobeOrg=1585540135%7CMCMID%7C01271079774495098017058810716526969361%7CMCAID%7CNONE%7CMCOPTOUT-1625657026s%7CNONE%7CvVersion%7C4.4.0; vendr-472878d5-d600-49f0-bce0-8c4e60477ff4=dpc=713e8a23-eb67-4d95-9930-9785c39c0bc2&dsc=713e8a23-eb67-4d95-9930-9785c39c0bc2&dtc=0b04f60b-0000-4484-90aa-404863dd8c80&dc=1a449abe-f291-46b5-b409-6d96f1eda15d; umb_installId=99f8fd45-31ba-425c-823c-f844a3fe3e09; yourAuthCookie=1AF9F1A2E84CF5956129CF75D77240FF453B880A4206A0CE16FC24AB0D421E8EE35280C0C02A519DF18EA191DD7157CDE6C849FF98754B8312F8D9B1510C5C8861C1E60D441A5448A5FC6EE198F08610E90316682B9AB9571B0B1A1C3DEE333302530604AD2EF7832A0FB814CD583813; AD_COOKIE=true; UMB_UPDCHK=1; _PS_splash=true; __RequestVerificationToken=ZuQ8q07nol4f_Y0ZSoNFcGTh7rEj9gddjVQ1hbyBiFkJwrTPBLZAYnO7Lo2hL0p8WT3Q3pr0z9zrrulBEc33oF_mtsI1; _atlas_cookies=true; UMB_UCONTEXT_C=2021-10-20T05%3A09%3A19.0112465%2B00%3A00; UMB_UCONTEXT=CfDJ8IGJQIPbp1BFs1Zjz67zzT-vkkQMusNWCGQv2D7Vt1xfZ4o0-cQ4Vqr8KxT6AxteKcvjrMWZjEt0HRby8SJNrffKZ8lGo1rsD3WhIn5OoaZu0SvB7baYGiCT7ezw_9qO698KqKavJdf7h6US-elmN1tZfbQysyFinoKKoNITU4s7PXqDEFceZGCgCJ5QhD4Izi0zt07pqLBIzN31M4-8BqI7Gj2ArAzrs0d36Rc-MfYd4kQXewXLjywddpedXb_hphD_NAM1mhH0klvyxBwGbkP78jtCCR50yu3do47N-gJN4ddzIF9nyGWQn1gDiXgqR5KAM06VOcmCH5dhaCpKIIm9CA3SQWmw4WU6_2wxRJIthOnuo4ZFqkj6tROwdDTW8UeahZHL4tGiiPKB6go-FbU9W54_fUiVOH4lWIg632D7uNYibyk96l_M5-DNNafMHdMmRBrFcN0WiqQ6cG_eKTNJgtJub8tO-ojNcaJBaVBJXYcFZDMxVPgG2TvWg8RXdH3mrxe6EyoNx0hYE3Itgq97h8x_iJYLmsmoFRIZ3CTxVDz31nFKh4zknNunOkcQgYMF2AjfNO_Kc_SwGW9onlk8x1pLlefW-eYuXhQvzkYz26h9eRjXut2beOZhoRaYytiN6d-tSIycp_ioyRm7IIFADzpCKE1eRRHj_k8ysCJZhTLwbGtpbtfdzsMSl-ICfWMd5hHd_6c9H90n2GOq9_7Bbe66Ajsl757oTg31tpcSd7_4N567FJbffZC61Os9Ifb_Hq4EPLEjhh-UUFyWj0Y0SI3pFhzdF5o4635ShWt19KSaQKLWGFgYqS6VtYfdGQjXruh9XR1MEr310roCSjxP6uu95_Pu6qZNM3bIHtdgQGOd_Lwihf_Y8kNakcDEFPKzJqua3Nl-cBghul_Pyvjd0jg-YNdjjGHD9SLqrVcwP5gGdQu46CCu9HG4cwZkVnYOnJrSkQxnRUY0sIwTfGfySwtiBG6qPQ6_gD3a52GgEeUjkYbpHnc0jaZ5rPAmtZ2dfAQt_MpUFrVWj9qBPozSeiqX9p6XwHiM2-hb5DGvagbNBOm6Zhf0Jr_qXwpI2vjyViVoXTKsjPmZ1k2aXfwV3MqJe3kNWjcpo7VXi9msRyzV_2sUE6LAlsYc7NsEFxBEj6xelxAQp8vsPdSBnvDq1G4BZE_LHCGe0UaB29ed7TKPXCsfCqrBWZUrYcxo3vJrcOmw08vdIBp9BE-vELdfe7V1x5ofE316ig0YBFesEgVVxSn_1CFQtaIr7PB5fXTIRmHh_ikAu9VsQPjvQICZpP3cYDk1bbdPo45pttpKvIIgnTcZ_4v5GuAAvTQwTNmDxEnpYYgjFt4wXQGYa3QZpJcNKHVotUQ66E-nDnb-jugkMvP3HLdhGDr-dhLs_CM6ZmGLeb2y1U_YfZjI-7hc_4C0i8KVrZlqvxaM9t_5ubhfcMphAcpfwXywj7ole8I-AB3ImDTHY9aBRG3tDp_iMhlO1opHdbzlX_q5RgESHilkZlbcNAqpFhRmoV-kke2bdSEA900IrCPXCWzRJYc-LqchLwdgmdCaY1TgBpV3DwRJra_BtXaEVgw1fdlj7FMbjK4IKwPd7JkMS1CXULpBCOqxbyLTk9IU1A5p56zweyxi1FZ5r7CQ0TAmgS62Db41iesk2OMePSTpSP_LXRtjsCPZLsRs3beAobwNKjiU7UpW4NT6dIrSNxW8cfA0Spti56KpIftxJgz22plrxTIHw7n2r1CqLjsu82EvzDzhdrmluyv1Cf0QztfySUgwvmPCYOXW7D9IapjWrs5Ic43C8XiUGEEYoTkrSeHbScUCObu7gZJr1kJaU5GbM18n8dIk5L_uynW14HKXCTSgY-mtfAc2m1-_dSiE9Qy-bvn0qKR8-NIkWJvBmyqHQzrFwcVuDogu_i4bseyQ-gGI6IqRv-E8DBUN66KSBTr8alEn_45IBwC-HzYo2P_7biJj3kyaKlwlryjnFx_3nuGeY74JrHP1CYMMb8-FZJFRaEP747YDsJrouMjXnwP2pqYDdwrQY8tGMmJcjWbGCy9BD3Hj6h8DMEeZyDpNNKhmENkw54AN8YB-TTvo_FCZxH5Jkx4XfxgpBON_dWxAfhOLGRs5kJMySqe81gsSCq1xwB0p7lsLzsOAyPfiMpS1n9H-7ugMpeKDHWfJZ9k26NXq2n7gsTfS7SJuZY_nTcPNgjYddv7bqx0Jvc0dUGtiPXqPhg8KHklImQXN8jywtly4e_3wZexGpg05U_4Dc8-6mFOHk_A2LEj66d_5jD5YdEP9kAhzz9C7j0tQuqi3i1wluo0J15rxjceAU6qRLz9bGMTePYamNSYdaPVtDaJOr54WugkvynkQEE0u-G_PYRcwLAO_f6mzrV84mK5YwUJFS9Yp9sFQOoDJTGcReq_9aqvIN_HsRCJHfFillWtJffq7DwHLS6EIqDen3xrBOS_o3lgjcIGI6hZx3ttorBCIQnidGgnsgHW6M2cf_xAUGXBaJ6JK999XRwIiXgxJodE2–ibnRDWWG7W751Tx37ut3TZOlOGfojX7aspW4o9uyRMm1-iq1HOJTuO9LgYgpGnfYD9F_3SWnw5837ipN82pMIjT1XPsZGsIup-oat8Be6DvcrqrVxG6rogNCZRcBaJnuXWUUgI94QNwrTO3QITwAumuF6MBAN5WiNhJMFuUas5NjCA2DshVbqj-lUJG5IugtWaT7V1mMhgehyw3FjpMeqqErW5Fjdy1JhLpTBONjjYrueAI-Qbt_NR_Gg-J7YFE_pxAZIx3nhiYdJ6ra5Z4McZj4nsiGpYTi5gNEjM60Vp9ubUjZxFo22dBkQTQskEfWypHlZ_b6V1rz8tQysMmko_y8DR8X9s30c0g_9RuOTvDVR2LIToU9gZrRZs8mUZkymeOKE_Jr4N2EKo58ZK7LUA8CJAfUnmjvS5UCt4vIU1CUAtZ0spY6AGvejSHA79mN04 Host: localhost:44355 Referer: https://localhost:44355/install?redir User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/94.0.4606.81 Safari/537.36 sec-ch-ua: “Chromium”;v=“94”, “Google Chrome”;v=“94”, “;Not A Brand”;v=“99” sec-ch-ua-mobile: ?0 sec-ch-ua-platform: “Windows” origin: https://localhost:44355 sec-fetch-site: same-origin sec-fetch-mode: cors sec-fetch-dest: empty
This is a companion discussion topic for the original entry at https://our.umbraco.com/forum/107379-upgrade-from-817-to-901-causing-error