Details

    • Type: Bug
    • Status: Closed
    • Priority: High
    • Resolution: Duplicate
    • Affects Version/s: 7.1.0
    • Fix Version/s: None
    • Component/s: Login/Registration
    • Labels:
      None
    • Severity:
      Minor
    • Triage:
      Triaged

      Description

      Following an upgrade from 7.0.6 to 7.1.0, login via the login.aspx form fails.
      We are using the AD Authentication Provider 5.0.5 all other authentication systems are disabled.
      When the user submits the login form, they are redirected to the home page of the portal which displays message that a critical error has occured.
      It is possible to login to the portal by accessing /DesktopModules/AuthenticationServices/ActiveDirectory/WindowsSignin.aspx directly.
      In the event log there a page load errors for when the login page was submitted as below:
      AssemblyVersion: 7.1.0
      PortalID: 0
      PortalName: Executive Education
      UserID: -1
      UserName:
      ActiveTabID: 55
      ActiveTabName: Executive Education
      RawURL: /login.aspx
      AbsoluteURL: /Default.aspx
      AbsoluteURLReferrer: http://execed-dev.com.auckland.ac.nz/login.aspx
      UserAgent: Mozilla/5.0 (Windows NT 6.2; WOW64; rv:22.0) Gecko/20100101 Firefox/22.0
      DefaultDataProvider: DotNetNuke.Data.SqlDataProvider, DotNetNuke
      ExceptionGUID: bb32e6c7-29d7-43fe-a816-e190319349df
      InnerException: Cannot insert the value NULL into column 'UserID', table 'DnnExecEdDevDb.dbo.dnn_PasswordHistory'; column does not allow nulls. INSERT fails. The statement has been terminated.
      FileName:
      FileLineNumber: 0
      FileColumnNumber: 0
      Method: System.Data.SqlClient.SqlConnection.OnError
      StackTrace:
      Message: DotNetNuke.Services.Exceptions.PageLoadException: Cannot insert the value NULL into column 'UserID', table 'DnnExecEdDevDb.dbo.dnn_PasswordHistory'; column does not allow nulls. INSERT fails. The statement has been terminated. ---> System.Data.SqlClient.SqlException: Cannot insert the value NULL into column 'UserID', table 'DnnExecEdDevDb.dbo.dnn_PasswordHistory'; column does not allow nulls. INSERT fails. The statement has been terminated. 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) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at PetaPoco.Database.Execute(String sql, Object[] args) at DotNetNuke.Data.PetaPoco.PetaPocoHelper.ExecuteNonQuery(String connectionString, CommandType type, String sql, Object[] args) at DotNetNuke.Data.DataProvider.AddPasswordHistory(Int32 userId, String password, String passwordHistory, Int32 retained) at DotNetNuke.Security.Membership.AspNetMembershipProvider.AddPasswordHistory(String password, Int32 retained) at DotNetNuke.Security.Membership.AspNetMembershipProvider.ChangePassword(UserInfo user, String oldPassword, String newPassword) at DotNetNuke.Entities.Users.UserController.ChangePassword(UserInfo user, String oldPassword, String newPassword) at DotNetNuke.Authentication.ActiveDirectory.AuthenticationController.RandomizePassword(UserInfo objUser, String& strPassword) at DotNetNuke.Authentication.ActiveDirectory.AuthenticationController.AuthenticateUser(UserInfo objUser, ADUserInfo objAuthUser, UserLoginStatus& loginStatus, String ipAddress) at DotNetNuke.Authentication.ActiveDirectory.AuthenticationController.ManualLogon(String userName, String strPassword, UserLoginStatus& loginStatus, String ipAddress) at DotNetNuke.Authentication.ActiveDirectory.Login.cmdLogin_Click(Object sender, EventArgs e) at System.Web.UI.WebControls.LinkButton.RaisePostBackEvent(String eventArgument) at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) — End of inner exception stack trace —
      Source:
      Server Name: COMWEBDEV1

        Attachments

          Issue links

            Activity

              People

              • Assignee:
                Unassigned
                Reporter:
                wgra021 Wayne Gray
              • Watchers:
                4 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:

                  Zendesk Support