We currently have a handful of websites on 7.1.4, 7.4.3 and 7.5.2.
I am putting a plan together to get all these sites on the same version and with a roadmap of upgrades etc. However, i have just attempted to upgrade one of our 7.1.4 sites to 7.12.0 and have come across the error below. I followed the steps that our provides.
Stack Trace:
Attempt by security transparent method 'Microsoft.Web.Helpers.PreApplicationStartCode.Start()' to access security critical method 'System.Web.WebPages.Razor.WebPageRazorHost.AddGlobalImport(System.String)' failed.
[
MethodAccessException: Attempt by security transparent method 'Microsoft.Web.Helpers.PreApplicationStartCode.Start()' to access security critical method 'System.Web.WebPages.Razor.WebPageRazorHost.AddGlobalImport(System.String)' failed.]
Microsoft.Web.Helpers.PreApplicationStartCode.Start() +50
[InvalidOperationException: The pre-application start initialization method Start on type Microsoft.Web.Helpers.PreApplicationStartCode threw an exception with the following error message: Attempt by security transparent method 'Microsoft.Web.Helpers.PreApplicationStartCode.Start()' to access security critical method 'System.Web.WebPages.Razor.WebPageRazorHost.AddGlobalImport(System.String)' failed..]
System.Web.Compilation.BuildManager.InvokePreStartInitMethodsCore(ICollection`1 methods, Func`1 setHostingEnvironmentCultures) +850
System.Web.Compilation.BuildManager.InvokePreStartInitMethods(ICollection`1 methods) +162
System.Web.Compilation.BuildManager.CallPreStartInitMethods(String preStartInitListPath, Boolean& isRefAssemblyLoaded) +128
System.Web.Compilation.BuildManager.ExecutePreAppStart() +170
System.Web.Hosting.HostingEnvironment.Initialize(ApplicationManager appManager, IApplicationHost appHost, IConfigMapPathFactory configMapPathFactory, HostingEnvironmentParameters hostingParameters, PolicyLevel policyLevel, Exception appDomainCreationException) +695
[HttpException (0x80004005): The pre-application start initialization method Start on type Microsoft.Web.Helpers.PreApplicationStartCode threw an exception with the following error message: Attempt by security transparent method 'Microsoft.Web.Helpers.PreApplicationStartCode.Start()' to access security critical method 'System.Web.WebPages.Razor.WebPageRazorHost.AddGlobalImport(System.String)' failed..]
System.Web.HttpRuntime.FirstRequestInit(HttpContext context) +523
System.Web.HttpRuntime.EnsureFirstRequestInit(HttpContext context) +118
System.Web.HttpRuntime.ProcessRequestNotificationPrivate(IIS7WorkerRequest wr, HttpContext context) +704
Can anyone shed any light on why this would be happening? I checked permissions for the site in IIS and all seems fine.
Have you cleaned your bin folder, during the upgrade?
I have a feeling that Microsoft.Web.Helpers.dll is not used in the latest versions of Umbraco, but was present in the earlier version you are upgrading from.
If you've applied the Umbraco upgrade dlls over the top of the existing bin folder, it will update the Umbraco dlls, but not necessarily remove Microsoft.Web.Helpers.dll
So try deleting this dll, and recycle, see if you receive the same issue.
Thank you for the tip. That seems to have fixed it. However, it is now saying failed login for my user (which i know is definitely right). I have ensured the useLegacyEncoding hasn't changed but after checking the logs, it seems it cannot find some SQL tables?
Invalid object name 'umbracoUser2UserGroup'.
It maybe that the upgrade is halted at this? Any ideas?
I have removed the current backup and created a fresh copy with a fresh backup of the database.
Having done all the steps above and gone straight to the login page to authorize the upgrade, when i login it says login failed. Then i check the logs and it still references the "UmbracoUser2UserGroup" table.
I have useLegacyEncoding set to true as that is how it was before upgrading and specifies to NOT change this in 7.6.0 version specific. I feel that i may have to do incremental upgrades but i was just hoping there was a way round this.
wonder if it's worth going to 7.7.13 first as Markus suggests, it's basically the migration that adds the database tables for the new User Group functionality you are trying to get triggered!
I have tried another fresh copy install to 7.7.13 from 7.1.4, still having issues relating to the missing tables. I have also tried to perform all the specific version upgrade steps but still no look. Below is the full error log from where the database errors begin, maybe this will shed some light?
2018-09-19 13:05:45,800 [P17720/D8/T89] ERROR Umbraco.Core.Persistence.UmbracoDatabase - Exception (cae4837a).
System.Data.SqlClient.SqlException (0x80131904): Invalid object name 'umbracoUser2UserGroup'.
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, Boolean shouldCacheForAlwaysEncrypted)
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__DisplayClass5_0.<ExecuteReaderWithRetry>b__0()
at Umbraco.Core.Persistence.FaultHandling.RetryPolicy.ExecuteAction[TResult](Func`1 func)
at Umbraco.Core.Persistence.Database.<Query>d__115`1.MoveNext()
ClientConnectionId:9c4f7c9e-37ca-4d5c-b85c-958da3703254
Error Number:208,State:1,Class:16
2018-09-19 13:05:45,987 [P17720/D8/T89] ERROR Umbraco.Core.Persistence.UmbracoDatabase - Exception (eb24ca27).
System.Data.SqlClient.SqlException (0x80131904): Invalid object name 'umbracoUser2UserGroup'.
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, Boolean shouldCacheForAlwaysEncrypted)
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__DisplayClass5_0.<ExecuteReaderWithRetry>b__0()
at Umbraco.Core.Persistence.FaultHandling.RetryPolicy.ExecuteAction[TResult](Func`1 func)
at Umbraco.Core.Persistence.Database.<Query>d__115`1.MoveNext()
ClientConnectionId:9c4f7c9e-37ca-4d5c-b85c-958da3703254
Error Number:208,State:1,Class:16
2018-09-19 13:05:46,003 [P17720/D8/T89] ERROR Umbraco.Core.Persistence.UmbracoDatabase - Exception (2fcdddee).
System.Data.SqlClient.SqlException (0x80131904): Invalid object name 'umbracoUser2UserGroup'.
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, Boolean shouldCacheForAlwaysEncrypted)
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__DisplayClass5_0.<ExecuteReaderWithRetry>b__0()
at Umbraco.Core.Persistence.FaultHandling.RetryPolicy.ExecuteAction[TResult](Func`1 func)
at Umbraco.Core.Persistence.Database.<Query>d__115`1.MoveNext()
ClientConnectionId:9c4f7c9e-37ca-4d5c-b85c-958da3703254
Error Number:208,State:1,Class:16
2018-09-19 13:05:46,050 [P17720/D8/T89] ERROR Umbraco.Core.Persistence.UmbracoDatabase - Exception (ebf51274).
System.Data.SqlClient.SqlException (0x80131904): Invalid column name 'securityStampToken'.
Invalid column name 'failedLoginAttempts'.
Invalid column name 'createDate'.
Invalid column name 'updateDate'.
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.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted)
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.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at Umbraco.Core.Persistence.PetaPocoCommandExtensions.<>c__DisplayClass2_0.<ExecuteNonQueryWithRetry>b__0()
at Umbraco.Core.Persistence.FaultHandling.RetryPolicy.ExecuteAction[TResult](Func`1 func)
at Umbraco.Core.Persistence.Database.Update(String tableName, String primaryKeyName, Object poco, Object primaryKeyValue, IEnumerable`1 columns)
ClientConnectionId:9c4f7c9e-37ca-4d5c-b85c-958da3703254
Error Number:207,State:1,Class:16
2018-09-19 13:05:46,050 [P17720/D8/T89] WARN Umbraco.Core.Services.UserService - An error occurred attempting to save a user instance during upgrade, normally this warning can be ignored. Exception: System.Data.SqlClient.SqlException (0x80131904): Invalid column name 'securityStampToken'.
Invalid column name 'failedLoginAttempts'.
Invalid column name 'createDate'.
Invalid column name 'updateDate'.
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.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted)
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.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at Umbraco.Core.Persistence.PetaPocoCommandExtensions.<>c__DisplayClass2_0.<ExecuteNonQueryWithRetry>b__0()
at Umbraco.Core.Persistence.FaultHandling.RetryPolicy.ExecuteAction[TResult](Func`1 func)
at Umbraco.Core.Persistence.Database.Update(String tableName, String primaryKeyName, Object poco, Object primaryKeyValue, IEnumerable`1 columns)
at Umbraco.Core.Persistence.Database.Update(Object poco, Object primaryKeyValue, IEnumerable`1 columns)
at Umbraco.Core.Persistence.Repositories.UserRepository.PersistUpdatedItem(IUser entity)
at Umbraco.Core.Cache.DefaultRepositoryCachePolicy`2.Update(TEntity entity, Action`1 persistUpdated)
at Umbraco.Core.Persistence.UnitOfWork.ScopeUnitOfWork.Commit(Action`1 transactionCompleting)
at Umbraco.Core.Services.UserService.Save(IUser entity, Boolean raiseEvents)
ClientConnectionId:9c4f7c9e-37ca-4d5c-b85c-958da3703254
Error Number:207,State:1,Class:16
2018-09-19 13:05:46,050 [P17720/D8/T89] ERROR Umbraco.Core.Persistence.UmbracoDatabase - Exception (43419d36).
System.Data.SqlClient.SqlException (0x80131904): Invalid object name 'umbracoUser2UserGroup'.
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, Boolean shouldCacheForAlwaysEncrypted)
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__DisplayClass5_0.<ExecuteReaderWithRetry>b__0()
at Umbraco.Core.Persistence.FaultHandling.RetryPolicy.ExecuteAction[TResult](Func`1 func)
at Umbraco.Core.Persistence.Database.<Query>d__115`1.MoveNext()
ClientConnectionId:9c4f7c9e-37ca-4d5c-b85c-958da3703254
Error Number:208,State:1,Class:16
2018-09-19 13:05:46,081 [P17720/D8/T89] ERROR Umbraco.Core.Persistence.UmbracoDatabase - Exception (dd0f35c0).
System.Data.SqlClient.SqlException (0x80131904): Invalid object name 'umbracoUser2UserGroup'.
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, Boolean shouldCacheForAlwaysEncrypted)
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__DisplayClass5_0.<ExecuteReaderWithRetry>b__0()
at Umbraco.Core.Persistence.FaultHandling.RetryPolicy.ExecuteAction[TResult](Func`1 func)
at Umbraco.Core.Persistence.Database.<Query>d__115`1.MoveNext()
ClientConnectionId:9c4f7c9e-37ca-4d5c-b85c-958da3703254
Error Number:208,State:1,Class:16
2018-09-19 13:05:46,096 [P17720/D8/T89] INFO Umbraco.Core.Security.BackOfficeSignInManager - Event Id: 0, state: Login attempt failed for username gary henshall from IP address ::1
EDIT: Just done incremental upgrades to see the issue. I managed to go from 7.1.4 -> 7.4.3 -> 7.5.14 -> 7.6.1 -> 7.6.13 -> 7.7.0. All worked apart from upgrading to 7.7.0 gave me the issue again (luckily i kept a backup of the 7.6.13 step). It doesn't like something..
I have found the problem. When merging the configuration files, even making sure that the legacy encoding was correct, it seems to remove some configurations for the user Membership Provider.
So now i have managed to upgrade the site to 7.12.0. Thank you very much for the help. I am not sure if this is an umbraco issue or if i have missed a certain step somewhere..
Manual Upgrade of Websites
We currently have a handful of websites on 7.1.4, 7.4.3 and 7.5.2.
I am putting a plan together to get all these sites on the same version and with a roadmap of upgrades etc. However, i have just attempted to upgrade one of our 7.1.4 sites to 7.12.0 and have come across the error below. I followed the steps that our provides.
Stack Trace:
Can anyone shed any light on why this would be happening? I checked permissions for the site in IIS and all seems fine.
Thank you.
Hi Gary
Have you cleaned your bin folder, during the upgrade?
I have a feeling that Microsoft.Web.Helpers.dll is not used in the latest versions of Umbraco, but was present in the earlier version you are upgrading from.
If you've applied the Umbraco upgrade dlls over the top of the existing bin folder, it will update the Umbraco dlls, but not necessarily remove Microsoft.Web.Helpers.dll
So try deleting this dll, and recycle, see if you receive the same issue.
regards
marc
Hi Marc,
Thank you for the tip. That seems to have fixed it. However, it is now saying failed login for my user (which i know is definitely right). I have ensured the useLegacyEncoding hasn't changed but after checking the logs, it seems it cannot find some SQL tables?
It maybe that the upgrade is halted at this? Any ideas?
Kind Regards,
Gary Henshall
Hi Gary
Yes, the table you mention is one of the new tables added for User Group management in Umbraco 7.7 and above.
You'd expect a migration to update this in your Umbraco database.
So maybe something hasn't quite completed.
With the issue you had with dlls remaining in the bin folder, it might be worth taking a new backup and firing up the upgrade again.
Essentially you should be prompted to login to authorize the upgrade which should trigger the database schema upgrade.
so is useLegacyEncoding set to true?
regards
Marc
Hi Marc,
I have removed the current backup and created a fresh copy with a fresh backup of the database.
Having done all the steps above and gone straight to the login page to authorize the upgrade, when i login it says login failed. Then i check the logs and it still references the "UmbracoUser2UserGroup" table.
I have useLegacyEncoding set to true as that is how it was before upgrading and specifies to NOT change this in 7.6.0 version specific. I feel that i may have to do incremental upgrades but i was just hoping there was a way round this.
Cheers for the help.
Gary
Hi Gary
discovered this thread:
https://our.umbraco.com/forum/using-umbraco-and-getting-started/89324-ugrading-to-776-invalid-object-name-umbracouser2usergroup
wonder if it's worth going to 7.7.13 first as Markus suggests, it's basically the migration that adds the database tables for the new User Group functionality you are trying to get triggered!
See this issue: https://issues.umbraco.org/issue/U4-10138
regards
Marc
Hi Marc,
I have tried another fresh copy install to 7.7.13 from 7.1.4, still having issues relating to the missing tables. I have also tried to perform all the specific version upgrade steps but still no look. Below is the full error log from where the database errors begin, maybe this will shed some light?
EDIT: Just done incremental upgrades to see the issue. I managed to go from 7.1.4 -> 7.4.3 -> 7.5.14 -> 7.6.1 -> 7.6.13 -> 7.7.0. All worked apart from upgrading to 7.7.0 gave me the issue again (luckily i kept a backup of the 7.6.13 step). It doesn't like something..
Cheers again.
Kind Regards,
Gary
Hi Marc,
I have found the problem. When merging the configuration files, even making sure that the legacy encoding was correct, it seems to remove some configurations for the user Membership Provider.
The merge overwrites it with the below config:
but if i replace it back to how it was, it allows me to login and the upgrade completes:
So now i have managed to upgrade the site to 7.12.0. Thank you very much for the help. I am not sure if this is an umbraco issue or if i have missed a certain step somewhere..
Kind Regards,
Gary Henshall
Hi Gary
Awesome!
So once you could login the migration that adds those tables could occur, hence the original thought it was useLegacyEncoding related...
... but great you now have it resolved!
... and all that point release practice!
regards
Marc
You can test what Marc said easily by commenting the Microsoft.Web.Helpers.dll in your config.web file and restarting your site.
If the site then loads in fine you can go ahead and delete the DLL file from your bin folder.
Had this happen to me in the past as well with a different plugin.
Edit: Unless the DLL isn't called from the config.web file move it out of your bin folder and try again.
is working on a reply...