Approving Thread Starter Post Hides Post

Issue

In Community Server 2007 and Community Server 2.1 SP3 whenever a new thread is created in a forum that is moderated, or when the user starting the thread is moderated, and then the post that starts the thread is approved, the thread is not visible.

Bug / Problem

The cs_system_UpdateThread stored procedure updates the thread starter post that is approved with a PostLevel of 2.  As a result, and because the PostId already equals the ParentId for this post, the post is not visible when viewing its parent forum. However, the post should still be searchable. This can be an issue for forums that are heavily moderated.

Resolution

Update your cs_system_UpdateThread stored procedure with the one attached.

Severity

Medium

Files

CS_SP3_system_UpdateThread.sql