Bug in CommunityServer::Forums fixed

Posted Januar 26, 2005 * Comments(2)
After playing a while with Telligent’s
Community Server :: Forums 2.0.1, I found a (the?) solution for solving
that annoying moderation issue:
  1. Open the stored procudure forums_Moderate_Forums in Query Analyzer or Enterprise Manager
  2. Change the line with “PostsToModerate” to “ToModerate”:

    ToModerate = (SELECT Count(PostID) FROM forums_Posts P WHERE ForumID = F.ForumID AND P.IsApproved = 0),

  3. Open the web projekt in the installation folder via Visual Studio (or an other tool of your choice)
  4. Open in the sub-project Components the file /Provider/ForumDataProvider.cs and change the text in line 794 to

    forum.PostsToModerate = (int) dr["ToModerate"];

  5. Compile the projekt again and copy the assembly
    AspNetForums.Components.dll into the /bin folder of your productive
    installation.

This should have fixed the bug and you should be able to use the moderation feature.

Be Sociable, Share!

2 Comments so far

  1. Michael Hensen on Januar 26th, 2005

    ? I don’t see the change here instead of some naming?

  2. Karsten Samaschke on Januar 26th, 2005

    Actually, the bug is caused by two columns in the result of the sp having the same name but different values. The solution is to rename one of the columns and to use its value. That’s all!