This project is read-only.
3
Vote

Cannot assign categories after adding module!

description

After adding help module to a page for the first time, you are prompted to add a category, however, the category drop down box is not populated (empty) in help modules settings, to fix this you must run a SQL script like this one. refer url http://www.dotnetnuke.com/Resources/Forums/forumid/81/threadid/375007/scope/posts.aspx
 
ALTER procedure [dbo].[Help_GetCategoryModules]
@TabId int
AS
SELECT
*
FROM
dbo.ModuleDefinitions AS MD INNER JOIN
dbo.Modules AS M ON MD.ModuleDefID = M.ModuleDefID INNER JOIN
dbo.ContentItems AS CI ON M.ContentItemID = CI.ContentItemID LEFT OUTER JOIN
dbo.TabModules AS TM ON M.ModuleID = TM.ModuleID

WHERE
(MD.FriendlyName = N'Category') AND 
(TM.TabID = @TabId)
and M.IsDeleted=0
order by
TM.TabID
 
Warning, if you added a prefix to sql database during the install then you need to do something like this example (prefix was db) so needed to add db_ prefix to each table name
 
ALTER procedure [dbo].[db_Help_GetCategoryModules]
@TabId int
AS
SELECT
*
FROM
dbo.db_ModuleDefinitions AS MD INNER JOIN
dbo.db_Modules AS M ON MD.ModuleDefID = M.ModuleDefID INNER JOIN
dbo.db_ContentItems AS CI ON M.ContentItemID = CI.ContentItemID LEFT OUTER JOIN
dbo.db_TabModules AS TM ON M.ModuleID = TM.ModuleID

WHERE
(MD.FriendlyName = N'Category') AND 
(TM.TabID = @TabId)
and M.IsDeleted=0
order by
TM.TabID

comments

mryckman wrote Feb 14, 2012 at 4:10 PM

Great fix! This is a major breaking change though... Is anybody going to update the module itself?

wrote Feb 13, 2013 at 3:20 AM

wrote Oct 5, 2013 at 4:58 AM