Having built the latest source code and applied the database changes I'm seeing an issue around the category count on the Roadmap. It is zero for all categories for the two projects we have currently running in Bugnet.
Looking at the 20120421_Performance_Enhancement.sql I can see the following line below repeated in four places (line no's 398, 429, 459, 523) within the sql
Select Count(*) FROM BugNet_IssuesView where IssueCategoryId = c.CategoryId and c.ProjectId =
96 and [Disabled] = 0 and IsClosed = 0 AS IssueCount
Should this not be the variable @ProjectId instead of this hardcoded value of 96??