Products

Solutions

Resources

Partners

Community

Blog

About

QA

Ideas Test

New Community Website

Ordinarily, you'd be at the right spot, but we've recently launched a brand new community website... For the community, by the community.

Yay... Take Me to the Community!

Welcome to the DNN Community Forums, your preferred source of online community support for all things related to DNN.
In order to participate you must be a registered DNNizen

HomeHomeGetting StartedGetting StartedInstalling DNN ...Installing DNN ...Cannot complete upgrade from 3.1.1 to 3.3.5Cannot complete upgrade from 3.1.1 to 3.3.5
Previous
 
Next
New Post
10/2/2006 7:39 AM
 

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

 
Previous
 
Next
HomeHomeGetting StartedGetting StartedInstalling DNN ...Installing DNN ...Cannot complete upgrade from 3.1.1 to 3.3.5Cannot complete upgrade from 3.1.1 to 3.3.5


These Forums are dedicated to discussion of DNN Platform and Evoq Solutions.

For the benefit of the community and to protect the integrity of the ecosystem, please observe the following posting guidelines:

  1. No Advertising. This includes promotion of commercial and non-commercial products or services which are not directly related to DNN.
  2. No vendor trolling / poaching. If someone posts about a vendor issue, allow the vendor or other customers to respond. Any post that looks like trolling / poaching will be removed.
  3. Discussion or promotion of DNN Platform product releases under a different brand name are strictly prohibited.
  4. No Flaming or Trolling.
  5. No Profanity, Racism, or Prejudice.
  6. Site Moderators have the final word on approving / removing a thread or post or comment.
  7. English language posting only, please.
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out