Friday, November 21, 2008 Home RegisterLogin
Menu
 
Counter
 
Tomasz Modelski IT site
86_115_web.jpg

My name is Tomasz Modelski.
This is my website about IT & my proffesional interests.
If you're looking for my CV / resume, please go
here.
Main topics of this site are : .Net, web development, software architecture, frameworks, BizTalk Server, project management, DotNetNuke, ...... .

I'm also owner of 'IDev Tomasz Modelski' company.

 
My 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

Tags:

1 comments so far...

Re: DotNetNuke : Import module definition blank page error solution

Hi,

Thanks for this blog post.I used this style and got it working..


Inder Singh
http://blog.indiapoly.com/

By Inder Singh on  2008-08-27 17:56:11Z

Your name:
Title:
Comment:
Security Code
Enter the code shown above in the box below
Add Comment   Cancel  
 
MCP-RGB-smaller.gif

Quick links