1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Where are moderations stored?

Discussion in 'XenForo Development Discussions' started by Marcus, Oct 8, 2012.

  1. Marcus

    Marcus Well-Known Member

    I have deleted a user and after that set all his threads and posts to "deleted" with mysql queries. However I did not approve nor delete the one last moderated post of him. I still have this one post in the moderation queue and the red "1 new moderation issue" is up in red on the top left of each page visible for me.

    Do you know in which database table the moderation notification of this one post is stored? I have lookedin xf_moderation_queue but it seems to be the wrong table.
     
  2. Jake Bunce

    Jake Bunce XenForo Moderator Staff Member

    xf_moderation_queue is correct.

    To reset the count in the mod bar you can run this query:

    Code:
    DELETE
    FROM xf_data_registry
    WHERE data_key = 'moderationCounts';
    
     
    Marcus likes this.
  3. Marcus

    Marcus Well-Known Member

    I run the query, the red "1" alert in the upper left corner is still there. I guess something bad happened as I removed the user in ACP and after that set his posts to "deleted".
     
  4. Jake Bunce

    Jake Bunce XenForo Moderator Staff Member

    Try re-logging. That count is recalculated when a mod logs in.
     
    Marcus likes this.
  5. Marcus

    Marcus Well-Known Member

    After re-logging it is the same. The number also switches to a higher one if new moderations come in. It is just that this one message can't be approved / disapproved as I manually stated it to "deleted" with mysql and the user is removed in ACP.
     
  6. Jake Bunce

    Jake Bunce XenForo Moderator Staff Member

    Then that post must still have an entry in xf_moderation_queue, which it shouldn't if it's marked as deleted.
     
    Marcus likes this.
  7. Marcus

    Marcus Well-Known Member

    You got it ! There was really this one post. There are dozens of threads still there. Although they don't make the moderation alert icon red, nor are they counted. I guess then I can remove all these threads from xf_moderation_queue, too?
     
  8. Jake Bunce

    Jake Bunce XenForo Moderator Staff Member

    If they aren't moderated then yes, you should remove them from that table.
     
    Marcus likes this.
  9. Marcus

    Marcus Well-Known Member

    Thanks! You help keeping my xenforo forum clean :)
     

Share This Page