Dear all,
i'm trying to upgrade umbraco version 7.6.13 to 7.7.0 but after coping config and dlls i canno't login anymore, i get "Login failed for user ".
I've checked that useLegacyEncoding is set to true and that usernameIsEmail is set to false.
In the log file i get the following exception:
Error Number:208,State:1,Class:16
2019-08-20 09:03:20,016 [P1444/D8/T12] ERROR Umbraco.Core.Persistence.UmbracoDatabase - Exception (3fb5ad74).
System.Data.SqlClient.SqlException (0x80131904): Invalid object name 'umbracoUser2UserGroup'.
at System.Data.SqlClient.SqlConnection.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, 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, 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 Umbraco.Core.Persistence.PetaPocoCommandExtensions.<>cDisplayClass5_0.0()
at Umbraco.Core.Persistence.FaultHandling.RetryPolicy.ExecuteAction[TResult](Func1 func)
at Umbraco.Core.Persistence.Database.<Query>d__1151.MoveNext()
ClientConnectionId:c86a56a9-b29d-45ae-97f7-8b21b2f1ca2a
Error Number:208,State:1,Class:16
2019-08-20 09:03:20,094 [P1444/D8/T12] ERROR Umbraco.Core.Persistence.UmbracoDatabase - Exception (db0bd481).
System.Data.SqlClient.SqlException (0x80131904): Invalid column name 'createDate'.
Invalid column name 'updateDate'.
at System.Data.SqlClient.SqlConnection.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.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, TaskCompletionSource1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource1 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](Func1 func)
at Umbraco.Core.Persistence.Database.Update(String tableName, String primaryKeyName, Object poco, Object primaryKeyValue, IEnumerable`1 columns)
ClientConnectionId:c86a56a9-b29d-45ae-97f7-8b21b2f1ca2a
It seems your table has not been created causing the issue. Have you got a locked down DB user in your web.config string? I had issues on upgrade earlier due to the DB user not being SA.
I've found what cause my issue, the useLegacyCoding="true" attribute needs to be added to the UsersMembershipProvider, not just the UmbracoMembershipProvider.
I would suggest that you login using useLegacyCoding="true" for UsersMembershipProvider. Then turn useLegacyCoding="false" and change the password while you are still logged in.
As useLegacyCoding="true" is removed from later version of Umbraco upgrade. So, you will not face any issue while upgrading due to login issue.
Cannot upgrade Umbraco 7.6.13 to 7.7.0
Dear all, i'm trying to upgrade umbraco version 7.6.13 to 7.7.0 but after coping config and dlls i canno't login anymore, i get "Login failed for user ".
I've checked that useLegacyEncoding is set to true and that usernameIsEmail is set to false.
In the log file i get the following exception:
Thanks a lot
Davide
Hi,
It seems your table has not been created causing the issue. Have you got a locked down DB user in your web.config string? I had issues on upgrade earlier due to the DB user not being SA.
Please can you check and confirm.
Regards,
Shaishav
Hi Shaishav, thanks a lot for your suggestion.
I've found what cause my issue, the useLegacyCoding="true" attribute needs to be added to the UsersMembershipProvider, not just the UmbracoMembershipProvider.
Regards Davide
Hi,
I would suggest that you login using useLegacyCoding="true" for UsersMembershipProvider. Then turn useLegacyCoding="false" and change the password while you are still logged in.
As useLegacyCoding="true" is removed from later version of Umbraco upgrade. So, you will not face any issue while upgrading due to login issue.
is working on a reply...