Cannot login after upgrade

Topics: General, Installing BugNET
Jun 9, 2014 at 9:21 AM
After upgrading to the latest version I cannot login anymore. I think I've done the same steps I did in previous upgrades but still cannot login with any user.
Any ideas?
Jun 9, 2014 at 11:38 AM
Can you try from a incognito / private browsing tab?


Jun 9, 2014 at 11:49 AM
Just tried and same issue.
Jun 9, 2014 at 11:52 AM
what about clearing cookies just incase.


Jun 9, 2014 at 12:11 PM
No change. Is there anything special you need to take care of when upgrading? any specific value on web.config that can cause this issue?
Did you change anything on the membership/account stuff in this version?
Jun 9, 2014 at 12:23 PM

The web.config shouldn't effect it. The framework was upgraded to .net 4.5 and the membership providers are the same but updated to latest versions.

Jun 9, 2014 at 1:45 PM
This may help - http://forums.asp.net/t/1835788.aspx

I did log in successfully but i may have had a cached login cookie or something. Adding this web.config statement and see if that fixes it?


Jun 9, 2014 at 3:08 PM
I think I've found the problem: i was typing the username and password and then hit "Enter" and now I just realized that I was being redirected to :
/Account/Login.aspx?returnurl=/Issues/IssueSearch.aspx?q=

so in fact the Enter is not executing the login but the search!
Jun 9, 2014 at 3:09 PM
ah yes, someone else reported this as well. I will create a hotfix and re-upload the packages because I am sure that will cause a lot of grief with everyone.


Jun 9, 2014 at 3:13 PM
At least will save you from a lot of support emails :)
Jun 9, 2014 at 3:14 PM
For sure.


Jun 9, 2014 at 10:24 PM
I too was having the same problem. I looked into the differences in the tables in Users. The Password format was set to 1, but in my backup it was set to 2. I changed all the passwords to format 2, and that fixed my problem
Jun 10, 2014 at 12:34 PM
I find clear application pool when restart can login
these sql profiler
exec sp_executesql N'SELECT
[Limit1].[PasswordFormat] AS [PasswordFormat], 
[Limit1].[UserId1] AS [UserId], 
[Limit1].[ApplicationId1] AS [ApplicationId], 
[Limit1].[UserName] AS [UserName], 
[Limit1].[IsAnonymous] AS [IsAnonymous], 
[Limit1].[LastActivityDate] AS [LastActivityDate], 
[Limit1].[UserId] AS [UserId1], 
[Limit1].[ApplicationId] AS [ApplicationId1], 
[Limit1].[Password] AS [Password], 
[Limit1].[PasswordSalt] AS [PasswordSalt], 
[Limit1].[Email] AS [Email], 
[Limit1].[PasswordQuestion] AS [PasswordQuestion], 
[Limit1].[PasswordAnswer] AS [PasswordAnswer], 
[Limit1].[IsApproved] AS [IsApproved], 
[Limit1].[IsLockedOut] AS [IsLockedOut], 
[Limit1].[CreateDate] AS [CreateDate], 
[Limit1].[LastLoginDate] AS [LastLoginDate], 
[Limit1].[LastPasswordChangedDate] AS [LastPasswordChangedDate], 
[Limit1].[LastLockoutDate] AS [LastLockoutDate], 
[Limit1].[FailedPasswordAttemptCount] AS [FailedPasswordAttemptCount], 
[Limit1].[FailedPasswordAttemptWindowStart] AS [FailedPasswordAttemptWindowStart], 
[Limit1].[FailedPasswordAnswerAttemptCount] AS [FailedPasswordAnswerAttemptCount], 
[Limit1].[FailedPasswordAnswerAttemptWindowsStart] AS [FailedPasswordAnswerAttemptWindowsStart], 
[Limit1].[Comment] AS [Comment]
FROM ( SELECT TOP (1) 
    [Extent1].[UserId] AS [UserId], 
    [Extent1].[ApplicationId] AS [ApplicationId], 
    [Extent1].[Password] AS [Password], 
    [Extent1].[PasswordFormat] AS [PasswordFormat], 
    [Extent1].[PasswordSalt] AS [PasswordSalt], 
    [Extent1].[Email] AS [Email], 
    [Extent1].[PasswordQuestion] AS [PasswordQuestion], 
    [Extent1].[PasswordAnswer] AS [PasswordAnswer], 
    [Extent1].[IsApproved] AS [IsApproved], 
    [Extent1].[IsLockedOut] AS [IsLockedOut], 
    [Extent1].[CreateDate] AS [CreateDate], 
    [Extent1].[LastLoginDate] AS [LastLoginDate], 
    [Extent1].[LastPasswordChangedDate] AS [LastPasswordChangedDate], 
    [Extent1].[LastLockoutDate] AS [LastLockoutDate], 
    [Extent1].[FailedPasswordAttemptCount] AS [FailedPasswordAttemptCount], 
    [Extent1].[FailedPasswordAttemptWindowStart] AS [FailedPasswordAttemptWindowStart], 
    [Extent1].[FailedPasswordAnswerAttemptCount] AS [FailedPasswordAnswerAttemptCount], 
    [Extent1].[FailedPasswordAnswerAttemptWindowsStart] AS [FailedPasswordAnswerAttemptWindowsStart], 
    [Extent1].[Comment] AS [Comment], 
    [Extent2].[UserId] AS [UserId1], 
    [Extent2].[ApplicationId] AS [ApplicationId1], 
    [Extent2].[UserName] AS [UserName], 
    [Extent2].[IsAnonymous] AS [IsAnonymous], 
    [Extent2].[LastActivityDate] AS [LastActivityDate]
    FROM   [dbo].[Memberships] AS [Extent1]
    INNER JOIN [dbo].[Users] AS [Extent2] ON [Extent1].[UserId] = [Extent2].[UserId]
    INNER JOIN [dbo].[Applications] AS [Extent3] ON [Extent2].[ApplicationId] = [Extent3].[ApplicationId]
    WHERE ((((LOWER([Extent3].[ApplicationName])) = (LOWER(@p__linq__0))) AND ( NOT ((LOWER([Extent3].[ApplicationName]) IS NULL) OR (LOWER(@p__linq__0) IS NULL)))) OR ((LOWER([Extent3].[ApplicationName]) IS NULL) AND (LOWER(@p__linq__0) IS NULL))) AND ((((LOWER([Extent2].[UserName])) = (LOWER(@p__linq__1))) AND ( NOT ((LOWER([Extent2].[UserName]) IS NULL) OR (LOWER(@p__linq__1) IS NULL)))) OR ((LOWER([Extent2].[UserName]) IS NULL) AND (LOWER(@p__linq__1) IS NULL)))
)  AS [Limit1]',N'@p__linq__0 nvarchar(4000),@p__linq__1 nvarchar(4000)',@p__linq__0=N'BugNET',@p__linq__1=N'admin'
Bug second login when logout after

exec sp_executesql N'SELECT
[Limit1].[C1] AS [C1], 
[Limit1].[UserName] AS [UserName], 
[Limit1].[UserId] AS [UserId], 
[Limit1].[Email] AS [Email], 
[Limit1].[PasswordQuestion] AS [PasswordQuestion], 
[Limit1].[Comment] AS [Comment], 
[Limit1].[IsApproved] AS [IsApproved], 
[Limit1].[IsLockedOut] AS [IsLockedOut], 
[Limit1].[CreateDate] AS [CreateDate], 
[Limit1].[LastLoginDate] AS [LastLoginDate], 
[Limit1].[LastActivityDate] AS [LastActivityDate], 
[Limit1].[LastPasswordChangedDate] AS [LastPasswordChangedDate], 
[Limit1].[LastLockoutDate] AS [LastLockoutDate]
FROM ( SELECT TOP (1) 
    [Extent1].[UserId] AS [UserId], 
    [Extent1].[UserName] AS [UserName], 
    [Extent1].[LastActivityDate] AS [LastActivityDate], 
    [Extent3].[Email] AS [Email], 
    [Extent3].[PasswordQuestion] AS [PasswordQuestion], 
    [Extent3].[IsApproved] AS [IsApproved], 
    [Extent3].[IsLockedOut] AS [IsLockedOut], 
    [Extent3].[CreateDate] AS [CreateDate], 
    [Extent3].[LastLoginDate] AS [LastLoginDate], 
    [Extent3].[LastPasswordChangedDate] AS [LastPasswordChangedDate], 
    [Extent3].[LastLockoutDate] AS [LastLockoutDate], 
    [Extent3].[Comment] AS [Comment], 
    1 AS [C1]
    FROM   [dbo].[Users] AS [Extent1]
    INNER JOIN [dbo].[Applications] AS [Extent2] ON [Extent1].[ApplicationId] = [Extent2].[ApplicationId]
    INNER JOIN [dbo].[Memberships] AS [Extent3] ON [Extent1].[UserId] = [Extent3].[UserId]
    WHERE ((((LOWER(@p__linq__0)) = (LOWER([Extent1].[UserName]))) AND ( NOT ((LOWER(@p__linq__0) IS NULL) OR (LOWER([Extent1].[UserName]) IS NULL)))) OR ((LOWER(@p__linq__0) IS NULL) AND (LOWER([Extent1].[UserName]) IS NULL))) AND ((((LOWER([Extent2].[ApplicationName])) = (LOWER(@p__linq__1))) AND ( NOT ((LOWER([Extent2].[ApplicationName]) IS NULL) OR (LOWER(@p__linq__1) IS NULL)))) OR ((LOWER([Extent2].[ApplicationName]) IS NULL) AND (LOWER(@p__linq__1) IS NULL)))
)  AS [Limit1]',N'@p__linq__0 nvarchar(4000),@p__linq__1 nvarchar(4000)',@p__linq__0=N'',@p__linq__1=N'BugNET'
Jun 12, 2014 at 7:44 AM
Edited Jun 12, 2014 at 1:11 PM
I have the same issue after upgrade from 1.4 pro to 1.6 pro.

Update: The login works fine but only when i click to the login button. When i enter username and password and press
enter the the login doesn't work an i show the login page again.