Item 'stuck' in the Moderation Queue

[PVO_Dave]

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:



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.

 

[Jake Bunce]

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

TRUNCATE TABLE xf_moderation_queue;

The count should update the next time you visit that page.

 

[PVO_Dave]

Thanks Jake, will give it a go!