Run this script. Thre was a dyslexic mistake I had the Parent and moduleid around the wrong way.
ALTER PROCEDURE {databaseOwner}[{objectQualifier}Help_ListCategoryActiveByParent]
@ParentID int,
@ModuleID int
AS
SELECT [CategoryID],
[CategoryGUID],
[Name],
[Description],
[Image],
[KeyWords],
[ModuleID],
[Order],
[Level],
[Parent],
[Visible],
[Deleted]
FROM {databaseOwner}{objectQualifier}Help_Category
WHERE [Parent] = @ParentID AND [ModuleID] = @ModuleID
AND [Deleted] <> 1
AND [Visible] <> 0
ORDER BY [Level] ASC,
[Parent] ASC,
[Order] ASC
GO