Products

Solutions

Resources

Partners

Community

Blog

About

QA

Ideas Test

New Community Website

Ordinarily, you'd be at the right spot, but we've recently launched a brand new community website... For the community, by the community.

Yay... Take Me to the Community!

Welcome to the DNN Community Forums, your preferred source of online community support for all things related to DNN.
In order to participate you must be a registered DNNizen

HomeHomeDNN Open Source...DNN Open Source...Module ForumsModule ForumsForumForumMinus sign in number of postsMinus sign in number of posts
Previous
 
Next
New Post
10/29/2006 3:37 PM
 

When in a new, clean moderated forum I reject a new post the number of post will be -1, -2 etc,.... The same things is shown to a global moderator. Some forums will have minus posts,...

 

Can I do something about that?

 

THX Frank

 
New Post
10/30/2006 1:30 AM
 

In the Forum_Forums table there is a column named PostsToModerate I believe, this is where it gets those figures from. When you delete a post, that count should be decreased by one but it seems there is a bug somewhere else around this. I know this is an issue and I have to look into it further (I have seen it here) but I have never seen it actually show the negative numbers.

 


Chris Paterra

Get direct answers to your questions in the Community Exchange.
 
New Post
11/4/2006 3:35 PM
 

Is it safe to just edit the table and put the numbers to 0 again?

 

THX Frank

 
New Post
11/5/2006 7:06 AM
 

You could do that, but it would be best if you created a query to do this that did something like:

"DECLARE @@PostsToModerate int
DELCARE @@ForumID int
SET @@ForumID = X" <- X = the forumid you want to deal with first, you will need to cycle
"SET @@PostsToModerate = (SELECT COUNT(POSTID) FROM Forum_Posts P
INNER JOIN Forum_Threads T ON P.ThreadID = T.ThreadID
INNER JOIN Forum_Forums F ON T.ForumID = F.ForumID
WHERE IsApproved = 0 AND F.IsActive = 1 AND F.ForumID = @@ForumID)
UPDATE Forum_Forums
SET PostsToModerate = @@PostsToModerate WHERE ForumID = @@ForumID"

I just did that statement from memory, but it would be very similar to that. You could also write a cursor statement that would loop through each ForumID.


Chris Paterra

Get direct answers to your questions in the Community Exchange.
 
Previous
 
Next
HomeHomeDNN Open Source...DNN Open Source...Module ForumsModule ForumsForumForumMinus sign in number of postsMinus sign in number of posts


These Forums are dedicated to discussion of DNN Platform and Evoq Solutions.

For the benefit of the community and to protect the integrity of the ecosystem, please observe the following posting guidelines:

  1. No Advertising. This includes promotion of commercial and non-commercial products or services which are not directly related to DNN.
  2. No vendor trolling / poaching. If someone posts about a vendor issue, allow the vendor or other customers to respond. Any post that looks like trolling / poaching will be removed.
  3. Discussion or promotion of DNN Platform product releases under a different brand name are strictly prohibited.
  4. No Flaming or Trolling.
  5. No Profanity, Racism, or Prejudice.
  6. Site Moderators have the final word on approving / removing a thread or post or comment.
  7. English language posting only, please.
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out