Copied to clipboard

Flag this post as spam?

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


  • Davide Balosetti 37 posts 218 karma points
    Aug 20, 2019 @ 07:28
    Davide Balosetti
    0

    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:

    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

    Thanks a lot

    Davide

  • Shaishav Karnani from digitallymedia.com 354 posts 1638 karma points
    Aug 20, 2019 @ 08:00
    Shaishav Karnani from digitallymedia.com
    0

    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

  • Davide Balosetti 37 posts 218 karma points
    Aug 20, 2019 @ 09:45
    Davide Balosetti
    101

    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

  • Shaishav Karnani from digitallymedia.com 354 posts 1638 karma points
    Aug 20, 2019 @ 09:52
    Shaishav Karnani from digitallymedia.com
    0

    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.

Please Sign in or register to post replies

Write your reply to:

Draft