Archive for the 'English' Category

Bug in CommunityServer::Forums fixed

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.