MyBB Community Forums

Full Version: Fixing the Moderation number?
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
My site has a small bug that I cause a while back when moving posts from one section to another. If you take a look at the attached you'll see that it says I have two posts that need moderation attention, but when I go into that section there's nothing there that is needing anything...

So my question is the following...

Is there a generic SQL statement that I could run to reset these all to 0 so that it's not constantly there?

Thanks in advance!
Try this: ACP > Tools & Maintenance > Recount & Rebuild > try the first 4. Also just check the moderation queue in the MCP.
(2008-11-11, 06:54 PM)Matt_ Wrote: [ -> ]Try this: ACP > Tools & Maintenance > Recount & Rebuild > try the first 4. Also just check the moderation queue in the MCP.

That seemed to fix it...

Thanks for your help!
Goodo Smile