Hi Tom,
I have been successful in replicating the behavior you are reporting.
To resolve the issue navigate to the following stored procedure in SQL. Then copy and paste the following the following script below the dashed line in the stored procedure:
Smith_ListCategoryMenuCount
ALTER PROCEDURE [dbo].[dnn_Smith_ListCategoryMenuCount]
@TabModuleId int
AS
select
CategoryID,
CategoryName + ' (' + cast( (
--select count(*) FROM dnn_Smith_CategoryProduct cp
select count(*) FROM dnn_Smith_CategoryProduct cp
join dnn_Smith_Products p
on cp.ProductID = p.ProductID
WHERE cp.categoryid=c.CategoryID and p.LogicallyDeleted != 1 AND p.Archived != 1
) as varchar) + ')' as 'CategoryName',
--Create ChildNodeCount field
(select count(*) FROM dnn_Smith_Category sc
WHERE parentid=sc.CategoryID) as 'childnodecount'
FROM dnn_Smith_Category c
where parentID = 0 and ( TabModuleId = @TabModuleId OR Share = 1)
ORDER BY SortOrder
Please Note: You will need to remove the dnn_ prefix if you are not using an object qualifier
Please let me know if you have any additional question or concerns. Thanks!