I folow instruction from link for upgrade dnn from ver 4.3.7 to ver 4.5.5
http://www.mitchelsellers.com/Blogs...om-4x.aspx
I have three error during the update process:
1. Executing Script: 04.04.04. SqlDataProvider Error (see 04.04.00.log for more information)
- 04.04.00.log have text:
Error: HelpURL
2. Executing Script: 04.05.01. SqlDataProvider Error (see 04.05.01.log for more information)
- 04.05.01.log have text:
System.Data.SqlClient.SqlException: The CREATE UNIQUE INDEX statement terminated because a duplicate key was found for the object name 'dbo.Folders' and the index name 'IX_FolderPath'. The duplicate key value is (10, finansijskotrziste/).
Could not create constraint. See previous errors.
The statement has been terminated.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL)
at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions)
/************************************************************/
/***** SqlDataProvider *****/
/***** *****/
/***** *****/
/***** Note: To manually execute this script you must *****/
/***** perform a search and replace operation *****/
/***** for dbo. and *****/
/***** *****/
/************************************************************/
/* add unique constraint to Folders table */
IF NOT EXISTS (select * from dbo.sysobjects where id = object_id(N'dbo.[IX_FolderPath]') and OBJECTPROPERTY(id, N'IsConstraint') = 1)
BEGIN
declare @PortalID int
declare @FolderPath varchar(300)
declare @FolderID int
declare @MinFolderID int
select @PortalID = min(PortalID)
from dbo.Portals
while @PortalID is not null
begin
/* check for duplicate FolderPaths */
select @FolderPath = null
select @FolderPath = FolderPath
from dbo.Folders
where PortalID = @PortalID
group by FolderPath
having COUNT(*) > 1
/* if duplicates exist */
if @FolderPath is not null
begin
/* iterate through the duplicates */
select @FolderID = min(FolderID)
from dbo.Folders
where PortalID = @PortalID
and FolderPath = @FolderPath
/* save min FolderID */
select @MinFolderID = @FolderID
while @FolderID is not null
begin
if @FolderID <> @MinFolderID
begin
/* reassign FolderId to min FolderID for duplicate folders */
update dbo.Files
set FolderID = @MinFolderID
where FolderID = @FolderID
/* remove duplicate folder */
delete
from dbo.Folders
where FolderID = @FolderID
end
select @FolderID = min(FolderID)
from dbo.Folders
where PortalID = @PortalID
and FolderPath = @FolderPath
and FolderID > @FolderID
end
end
select @PortalID = min(PortalID)
from dbo.Portals
where PortalID > @PortalID
end
/* add unique constraint */
ALTER TABLE dbo.Folders ADD CONSTRAINT
IX_FolderPath UNIQUE NONCLUSTERED
(
PortalID,
FolderPath
) ON [PRIMARY]
END
3. Installing Module File Weather-ser: Error!
Help me if you can.