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

Item 'stuck' in the Moderation Queue

Discussion in 'Troubleshooting and Problems' started by PVO_Dave, Dec 13, 2012.

  1. PVO_Dave

    PVO_Dave Active Member

    Hi,

    I think during some problems with Elastic Search we somehow managed to get an item stuck in the Moderation Queue.

    It was some reported spam, the post was removed, user banned etc..

    But we now have this stuck in the queue:

    stuck in queue.png

    Choosing any of those options and clicking 'Update Moderation Queue' makes no difference, the report is still stuck.

    What can I do to get rid of this rouge alert?

    Thanks,
    Dave.
     
  2. Jake Bunce

    Jake Bunce XenForo Moderator Staff Member

    Run this query on your database to empty the moderation queue:

    Code:
    TRUNCATE TABLE xf_moderation_queue;
    
    The count should update the next time you visit that page.
     
  3. PVO_Dave

    PVO_Dave Active Member

    Thanks Jake, will give it a go!
     

Share This Page