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 ...collaction Conflictcollaction Conflict
Previous
 
Next
New Post
3/21/2007 10:53 AM
 

Hi,

when trying to upgrade from DNN 3.1.1  to 3.3.7

i get following errors:
00:00:00.520 - Upgrading to Version: 3.2.1 Error! (seeC:\Inetpub\wwwroot\mscrmaddons\Providers\DataProviders\SqlDataProvider\03.02.01.log for more information)
00:00:00.831 - Upgrading to Version: 3.2.2 Success
00:00:01.041 - Upgrading to Version: 3.2.3 Error! (seeC:\Inetpub\wwwroot\mscrmaddons\Providers\DataProviders\SqlDataProvider\03.02.03.log for more information)
00:00:15.522 - Upgrading to Version: 3.2.4 Success

the other upgrades succeed.

Content of the log-files mentioned above:

03.02.01 LOG:

System.Data.SqlClient.SqlException: 'FK_SearchItemWord_SearchWord' is not a constraint.
Could not drop constraint. See previous errors.
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.SearchItemWord
DROP CONSTRAINT FK_SearchItemWord_SearchWord


System.Data.SqlClient.SqlException: 'FK_SearchItemWordPosition_SearchItemWord' is not a constraint.
Could not drop constraint. See previous errors.
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.SearchItemWordPosition
DROP CONSTRAINT FK_SearchItemWordPosition_SearchItemWord



03.02.03 LOG:
System.Data.SqlClient.SqlException: Cannot resolve the collation conflict between "SQL_Latin1_General_CP1_CI_AS" and "Latin1_General_CI_AS" in the equal to operation.
Cannot resolve the collation conflict between "SQL_Latin1_General_CP1_CI_AS" and "Latin1_General_CI_AS" in the equal to operation.
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 TransferUsersToSameContext N'DotNetNuke', NULL

--Iterate through Portals to transfer users
SELECT @PortalID = min(PortalID)
FROM dbo.Portals
WHILE @PortalID IS NOT NULL
BEGIN

-- Transfer Portal Users
EXECUTE TransferUsersToSameContext N'DotNetNuke', @PortalID

SELECT @PortalID = min(PortalID)
FROM dbo.Portals
WHERE PortalID > @PortalID
END



 
Previous
 
Next
HomeHomeGetting StartedGetting StartedInstalling DNN ...Installing DNN ...collaction Conflictcollaction Conflict


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