I just upgraded a site from 3.1.1 to 3.3.7.
Well there was an error in the upgrade on 3.2.1 and 3.2.3. Now, although it appears that users that existed can get by the login screen, they are seeing an error right away and aren't actually logged in. I am however able to login with a newly created user. I have 5,000 users I need to fix, please help!
Here is the exception users that existed are triggering:
AssemblyVersion: 03.03.07
PortalID: 0
PortalName: Environmental, Safety & Health, Inc.
UserID: -1
UserName:
ActiveTabID: 36
ActiveTabName: Home
RawURL: /portal/Home/tabid/36/ctl/Login/Default.aspx
AbsoluteURL: /portal/Default.aspx
AbsoluteURLReferrer: http://www.eshinc.com/portal/Home/tabid/36/ctl/Login/Default.aspx
UserAgent: Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; .NET CLR 1.0.3705; .NET CLR 1.1.4322; Media Center PC 4.0; .NET CLR 2.0.50727)
DefaultDataProvider: DotNetNuke.Data.SqlDataProvider, DotNetNuke.SqlDataProvider
ExceptionGUID: 6a5eefd8-7f33-4cfe-9620-86dd90053d98
InnerException: Object reference not set to an instance of an object.
FileName:
FileLineNumber: 0
FileColumnNumber: 0
Method: DotNetNuke.Security.Membership.AspNetMembershipProvider.UserLogin
StackTrace:
Message: DotNetNuke.Services.Exceptions.PageLoadException: Object reference not set to an instance of an object. ---> System.NullReferenceException: Object reference not set to an instance of an object. at DotNetNuke.Security.Membership.AspNetMembershipProvider.UserLogin(Int32 portalId, String username, String password, String verificationCode, UserLoginStatus& loginStatus) at DotNetNuke.Entities.Users.UserController.ValidateUser(Int32 portalId, String Username, String Password, String VerificationCode, String PortalName, String IP, UserLoginStatus& loginStatus) at DotNetNuke.Modules.Admin.Security.Signin.cmdLogin_Click(Object sender, EventArgs e) at System.Web.UI.WebControls.Button.OnClick(EventArgs e) at System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) at System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) at System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) at System.Web.UI.Page.ProcessRequestMain() --- End of inner exception stack trace ---
Source:
Server Name: IPSWBZ0005ATL2
And here is what bombed in 3.2.3:
System.Data.SqlClient.SqlException: There is already an object named 'dnn_GetOnlineUsers' in the database.
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL)
at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions)
CREATE PROCEDURE dbo.dnn_GetOnlineUsers @PortalID int
AS
SELECT
UO.UserID,
U.Username
FROM dnn_UsersOnline UO
INNER JOIN dnn_Users U ON UO.UserID = U.UserID
INNER JOIN dnn_UserPortals UP ON U.UserID = UP.UserId
WHERE UP.PortalID = @PortalID
System.Data.SqlClient.SqlException: The Log space limit for your database has been exceeded. You must reduce the space required for your transactions or contact Sales to purchase more space. The Log will clear automatically. To clear manually run: BACKUP LOG eshinccom WITH TRUNCATE_ONLY
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL)
at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions)
--Declare Variables
DECLARE @PortalID int
-- Transfer Super Users
EXECUTE dnn_TransferUsersToSameContext N'DotNetNuke', NULL
--Iterate through Portals to transfer users
SELECT @PortalID = min(PortalID)
FROM dbo.dnn_Portals
WHILE @PortalID IS NOT NULL
BEGIN
-- Transfer Portal Users
EXECUTE dnn_TransferUsersToSameContext N'DotNetNuke', @PortalID
SELECT @PortalID = min(PortalID)
FROM dbo.dnn_Portals
WHERE PortalID > @PortalID
END
System.Data.SqlClient.SqlException: The Log space limit for your database has been exceeded. You must reduce the space required for your transactions or contact Sales to purchase more space. The Log will clear automatically. To clear manually run: BACKUP LOG eshinccom WITH TRUNCATE_ONLY
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL)
at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions)
--Drop temp objects
DROP TABLE dbo.dnn_TransferredUsers
DROP PROCEDURE dbo.dnn_TransferUsersToSameContext