We have found a moderation inconsistency on a topic where the ? icon appears in the viewforum listing and if they hover over it the tooltip "At least one post in this topic has not been approved" is displayed.
So our moderators looks over the topic, there are no unapproved posts. The moderator uses the Quick-mod tools to view the topic log, there is nothing to approve. The MCP Moderation queue doesn't have any Topics awaiting approval or Posts awaiting approval.
Upon further review, there is a post in the topic from a new member from a couple of days ago, but this post is visible and has been quoted by another member. Double-checking the topic log again, the moderator can find no mention of this post being approved.
Another moderator was active doing some moderation work around the time of this new post and we've checked with them and they believe it is possible they did actually approve the post. If so, why doesn't this show up in the MCP Topic Log?
A two part question
- How can we resolve this moderation inconsistency, particular making the ? icon disappear from the viewforum listing.
- How can we get MCP to recognize that this new member's post has been moderator approved?
For an unapproved post, what values should be in the
phpbb.post_visibility, phpbb_posts.post_delete_time and phpbb_posts.post_delete_user? What should the values change to when a moderator approves the post? What other tables/fields get updated?
Based on my layman's checking of the database and previous approved posts on our board this is what I think also should happen when a post is approved. When a post is approved,
phpbb_topics.topic_posts_unapprovedshould be decremented and
phpbb.topic_posts_approvedshould be incremented and should match the number of posts on the topic. Correct? There should also be a corresponding entry into the phpbb_log table correct?