DNN4.9.1升级到DNN5.2.1

1.如果安装了CISS.SideMenu，需要先修复SideMenu的bug
2.修改05.02.01.SqlDataProvider 文件，这里有多处修改的地方：

1)修正PortalLanguages,需要在“CREATE PROCEDURE {databaseOwner}{objectQualifier}UpgradeDefaultLanguages  ”这句之前，插入下面的代码：

 

修正AddPortalLanguages存储过程

/* ***** Object: Table [dbo].[PortalLanguagesBackUp] Script Date: 01/11/2010 17:45:45 ***** */
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [ dbo ] . [ PortalLanguagesBackUp ] (
[ PortalLanguageID ] [ int ] IDENTITY ( 1 , 1 ) NOT NULL ,
[ PortalID ] [ int ] NOT NULL ,
[ LanguageID ] [ int ] NULL ,
[ CreatedByUserID ] [ int ] NULL ,
[ CreatedOnDate ] [ datetime ] NULL ,
[ LastModifiedByUserID ] [ int ] NULL ,
[ LastModifiedOnDate ] [ datetime ] NULL ,
CONSTRAINT [ PK_PortalLanguagesBackUp ] PRIMARY KEY CLUSTERED
(
[ PortalLanguageID ] ASC
) WITH (PAD_INDEX = OFF , IGNORE_DUP_KEY = OFF ) ON [ PRIMARY ]
) ON [ PRIMARY ]

GO


if exists ( select * from dbo.sysobjects where id = object_id (N ' {databaseOwner}[{objectQualifier}AddPortalLanguage] ' ) and OBJECTPROPERTY (id, N ' IsProcedure ' ) = 1 )
DROP PROCEDURE {databaseOwner} [ {objectQualifier}AddPortalLanguage ]
GO

CREATE PROCEDURE [ dbo ] . [ AddPortalLanguage ]

@PortalId int ,
@LanguageId int ,
@CreatedByUserID int

AS
if @LanguageId > 0
begin
INSERT INTO dbo.PortalLanguages (
PortalId,
LanguageId,
[ CreatedByUserID ] ,
[ CreatedOnDate ] ,
[ LastModifiedByUserID ] ,
[ LastModifiedOnDate ]

)
VALUES (
@PortalId ,
@LanguageId ,
@CreatedByUserID ,
getdate (),
@CreatedByUserID ,
getdate ()

)
SELECT SCOPE_IDENTITY ()
end
else
begin
INSERT INTO dbo.PortalLanguagesBackUp (
PortalId,
LanguageId,
[ CreatedByUserID ] ,
[ CreatedOnDate ] ,
[ LastModifiedByUserID ] ,
[ LastModifiedOnDate ]

)
VALUES (
@PortalId ,
@LanguageId ,
@CreatedByUserID ,
getdate (),
@CreatedByUserID ,
getdate ()

)
SELECT SCOPE_IDENTITY ()
end
GO

 

2)在05.02.01.SqlDataProvider 文件的末尾增加下面的代码：

 

代码

/* update AddDesktopModulePermission */
/* ******************************** */

GO
/* ***** Object: Table [dbo].[DesktopModulePermission] Script Date: 01/11/2010 13:46:38 ***** */
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
/* ***** Object: Table [dbo].[DesktopModulePermissionBackUp] Script Date: 01/11/2010 17:46:25 ***** */
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [ dbo ] . [ DesktopModulePermissionBackUp ] (
[ DesktopModulePermissionID ] [ int ] IDENTITY ( 1 , 1 ) NOT NULL ,
[ PortalDesktopModuleID ] [ int ] NOT NULL ,
[ PermissionID ] [ int ] NOT NULL ,
[ AllowAccess ] [ bit ] NOT NULL ,
[ RoleID ] [ int ] NULL ,
[ UserID ] [ int ] NULL ,
[ CreatedByUserID ] [ int ] NULL ,
[ CreatedOnDate ] [ datetime ] NULL ,
[ LastModifiedByUserID ] [ int ] NULL ,
[ LastModifiedOnDate ] [ datetime ] NULL ,
CONSTRAINT [ PK_DesktopModulePermissionBackUp ] PRIMARY KEY CLUSTERED
(
[ DesktopModulePermissionID ] ASC
) WITH (PAD_INDEX = OFF , IGNORE_DUP_KEY = OFF ) ON [ PRIMARY ]
) ON [ PRIMARY ]
GO

if exists ( select * from dbo.sysobjects where id = object_id (N ' {databaseOwner}[{objectQualifier}AddDesktopModulePermission] ' ) and OBJECTPROPERTY (id, N ' IsProcedure ' ) = 1 )
DROP PROCEDURE {databaseOwner} [ {objectQualifier}AddDesktopModulePermission ]
GO

CREATE PROCEDURE [ dbo ] . [ AddDesktopModulePermission ]
@PortalDesktopModuleID int ,
@PermissionID int ,
@RoleID int ,
@AllowAccess bit ,
@UserID int ,
@CreatedByUserID int
AS

declare @aa int ;
-- set @aa = 0;
select @aa = count ( * ) from DesktopModulePermission
where PortalDesktopModuleID = @PortalDesktopModuleID
and [ PermissionID ] = @PermissionID
and [ RoleID ] = @RoleID
and ( [ UserID ] = @UserID or UserID is null )
-- select @aa;

if @aa < 1
begin

INSERT INTO dbo.DesktopModulePermission (
[ PortalDesktopModuleID ] ,
[ PermissionID ] ,
[ RoleID ] ,
[ AllowAccess ] ,
[ UserID ] ,
[ CreatedByUserID ] ,
[ CreatedOnDate ] ,
[ LastModifiedByUserID ] ,
[ LastModifiedOnDate ]
) VALUES (
@PortalDesktopModuleID ,
@PermissionID ,
@RoleID ,
@AllowAccess ,
@UserID ,
@CreatedByUserID ,
getdate (),
@CreatedByUserID ,
getdate ()
)

select SCOPE_IDENTITY ()
end
else
begin
INSERT INTO dbo.DesktopModulePermissionBackUp (
[ PortalDesktopModuleID ] ,
[ PermissionID ] ,
[ RoleID ] ,
[ AllowAccess ] ,
[ UserID ] ,
[ CreatedByUserID ] ,
[ CreatedOnDate ] ,
[ LastModifiedByUserID ] ,
[ LastModifiedOnDate ]
) VALUES (
@PortalDesktopModuleID ,
@PermissionID ,
@RoleID ,
@AllowAccess ,
@UserID ,
@CreatedByUserID ,
getdate (),
@CreatedByUserID ,
getdate ()
);

select SCOPE_IDENTITY ()

end

GO
/* Delete FK_DesktopModules_Packages */
IF EXISTS ( SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID (N ' [dbo].[FK_DesktopModules_Packages] ' ) AND parent_object_id = OBJECT_ID (N ' [dbo].[DesktopModules] ' ))
ALTER TABLE [ dbo ] . [ DesktopModules ] DROP CONSTRAINT [ FK_DesktopModules_Packages ]

3.升级完成后，记得Restart Application

 

4.由于在升级的时候，删除了FK_DesktopModules_Packages，所以需要重新添加：

 

Create FK_DesktopModules_Packages

ALTER TABLE [ dbo ] . [ DesktopModules ] WITH NOCHECK ADD CONSTRAINT [ FK_DesktopModules_Packages ] FOREIGN KEY ( [ PackageID ] )
REFERENCES [ dbo ] . [ Packages ] ( [ PackageID ] )
ON UPDATE CASCADE
ON DELETE CASCADE
GO
ALTER TABLE [ dbo ] . [ DesktopModules ] CHECK CONSTRAINT [ FK_DesktopModules_Packages ]

 

 

5.删除DNN4下的HTML Module的代码：删除App_Code下的HTML目录。如果你同时安装了Survey Module，也可以一起App_Code/Survey目录.

6.由于DNN升级过程中，会自动清除部分目录和文件，所以，如果在本地升级完成后，不要直接覆盖远程目录，而是先把远程目录清空，或者转移远程目录到某个其它文件夹，然后在上传本地升级好的网站文件

待续...

转载于:https://www.cnblogs.com/nevernet/archive/2010/01/12/1645821.html