1- Now is a record in DesktopModulePermission for Admin/RecycleBin module That RoleId is Null value

2- I modify PROCEDURE [dbo].[AddDesktopModulePermission] These that insert @RoleId in other table for check what RoleId insert ?
As following Line 10



ALTER PROCEDURE [dbo].[AddDesktopModulePermission]
@PortalDesktopModuleID Int, -- not null!
@PermissionId Int, -- not null!
@RoleId Int, -- might be negative for virtual roles
@AllowAccess Bit, -- false: deny, true: grant
@UserId Int, -- -1 is replaced by Null
@CreatedByUserId Int -- -1 is replaced by Null
AS
BEGIN
Line10: INSERT INTO TblTest (RoleId)VALUES (@RoleId)

INSERT INTO dbo.[DesktopModulePermission] (
[PortalDesktopModuleID],
[PermissionID],
[RoleID],
[AllowAccess],
[UserID],
[CreatedByUserID],
[CreatedOnDate],
[LastModifiedByUserID],
[LastModifiedOnDate]
) VALUES (
@PortalDesktopModuleID,
@PermissionID,
@RoleId,
@AllowAccess,
CASE WHEN @UserId = -1 THEN Null ELSE @UserId END,
CASE WHEN @CreatedByUserID = -1 THEN Null ELSE @CreatedByUserID END,
GetDate(),
CASE WHEN @CreatedByUserID = -1 THEN Null ELSE @CreatedByUserID END,
GetDate()
)
SELECT SCOPE_IDENTITY()
END

But after install one Module 52 row inserted in TblTest Table. Furthermore one of RoleId not in Rolls table.

Thanks in advance

this is for sure an issue of the 3rd Party module you should Report to the module developer/vendor.

---

Cheers from Germany,
Sebastian Leupold

   

Speed up your DNN Websites with TurboDNN