Friday, November 21, 2008 Blog RegisterLogin
Menu
 
My IT blog
 
My IT blog
 
My IT blog
Aug5

Written by:Tomasz Modelski
2008-08-05 09:23:50Z

After upgrade DotNetNuke to 4.6 and higher versions error occurs : Page Host > Module Definitions > Import module definition is empty.

I've found solution  on DNN forums , and posted it in 'usable' version :.

So, the solution is to run SQL script with Run as Script option, in Host > SQL :

IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = object_id(N'{databaseOwner}[{objectQualifier}GetUserRoles]') AND OBJECTPROPERTY(id, N'IsPROCEDURE') = 1)
  DROP PROCEDURE {databaseOwner}{objectQualifier}GetUserRoles
GO

CREATE PROCEDURE {databaseOwner}{objectQualifier}GetUserRoles 
@PortalId  int,
@UserId    int

AS

SELECT    
    R.*,
    UR.UserRoleID,
    U.UserID,
    U.DisplayName,
    U.Email,
    UR.EffectiveDate,
    UR.ExpiryDate,
    UR.IsTrialUsed
FROM {databaseOwner}{objectQualifier}UserRoles UR
    INNER JOIN {databaseOwner}{objectQualifier}Users U ON UR.UserID = U.UserID
    INNER JOIN {databaseOwner}{objectQualifier}Roles R ON UR.RoleID = R.RoleID
WHERE
    U.UserID = @UserId AND R.PortalID = @PortalId
   
GO

declare @ModuleDefID int

select @ModuleDefID = ModuleDefID
from   {databaseOwner}{objectQualifier}ModuleDefinitions
where  FriendlyName = 'Module Definitions'
IF NOT EXISTS (SELECT ModuleControlID FROM {databaseOwner}{objectQualifier}ModuleControls WHERE ModuleDefID = @ModuleDefID AND ControlKey = N'Import')
BEGIN
insert into {databaseOwner}{objectQualifier}ModuleControls ( ModuleDefID, ControlKey, ControlTitle, ControlSrc, IconFile, ControlType, ViewOrder, HelpUrl, SupportsPartialRendering )
values ( @ModuleDefID, 'Import', 'Import Module Definition', 'Admin/ModuleDefinitions/ImportModuleDefinition.ascx', NULL, 3, NULL, NULL, 0 )
END