I have not been able to have a completely successful upgrade from 3.1.1 to 3.3.4 or 3.3.5 - everytime I cannot login with Admin nor Host. I have verified that the DecryptionKey is copied properly from web.config - now with 3.3.5 I am getting two errors which I may have missed before. First - when performing the upgrade to 3.2.1 I get this error:
System.Data.SqlClient.SqlException: CREATE UNIQUE INDEX terminated because a duplicate key was found for index ID 2. Most significant primary key is 'tuấn'.
Could not create constraint. See previous errors.
The statement has been terminated.
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL)
at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions)
ALTER TABLE dbo.suff_SearchWord ADD CONSTRAINT
IX_suff_SearchWord UNIQUE NONCLUSTERED (Word) ON [PRIMARY]
Secondly I get an error at 3.2.3
System.Data.SqlClient.SqlException: There is already an object named 'suff_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.suff_GetOnlineUsers @PortalID int
AS
SELECT
UO.UserID,
U.Username
FROM suff_UsersOnline UO
INNER JOIN suff_Users U ON UO.UserID = U.UserID
INNER JOIN suff_UserPortals UP ON U.UserID = UP.UserId
WHERE UP.PortalID = @PortalID
System.Data.SqlClient.SqlException: Cannot insert duplicate key row in object 'aspnet_Users' with unique index 'aspnet_Users_Index'.
Cannot insert duplicate key row in object 'aspnet_Users' with unique index 'aspnet_Users_Index'.
The statement has been terminated.
The statement has been terminated.
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 suff_TransferUsersToSameContext N'DotNetNuke', NULL
--Iterate through Portals to transfer users
SELECT @PortalID = min(PortalID)
FROM dbo.suff_Portals
WHILE @PortalID IS NOT NULL
BEGIN
-- Transfer Portal Users
EXECUTE suff_TransferUsersToSameContext N'DotNetNuke', @PortalID
SELECT @PortalID = min(PortalID)
FROM dbo.suff_Portals
WHERE PortalID > @PortalID
END
To me the first error looks like an issue with the users - but I have tried deleting all users from the site before attempting the upgrade and it made no difference. The second I am assuming is a result of the first upgrade not completing properly. I know that no users actually exist as I once forgot to logout of the site before performing the upgrade - when I accessed the portal I still had Host privledges and could see that no users (not even Admin) existed. Any help on this would be greatly appreciated.
Allan