I have a member, he makes an occasional post that needs to be hidden.

Yesterday, a mod seems to have marked him as a spammer and banned him, even though he intended to give him a one day suspension.

Now all his posts before that point are hidden as spam.

Is there a way to undo that? There are tens of thousands of posts from this person, so manually is not an option.

Thanks

You can fix with a SQL query to unhide all their posts. But it will be a blunt tool and mark all past posts as unhidden.

That, or restore a forums backup. Maybe more advance you can restore a backed up database and examine what was hidden before and then use that knowledge to mass unhide items in the live database and then selective rehide things.

tl;dr no simple solution that I know of.

Edited March 6Mar 6 by Fast Lane!

There is no undo to this utility. You would need to manually unhide all topics or restore from a backup. We would recommend providing training to your moderators so they know what each piece of the moderator toolkit does or only provide one-way tools to mods you can trust with their functionality.

 

I have a member, he makes an occasional post that needs to be hidden.

Yesterday, a mod seems to have marked him as a spammer and banned him, even though he intended to give him a one day suspension.

Now all his posts before that point are hidden as spam.

Is there a way to undo that? There are tens of thousands of posts from this person, so manually is not an option.

Thanks

This can be done easily with a couple of sql queries. Although manipulating the database directly isn't recommended, unless one knows what one is doing, short of developing a custom app for this, running manual queries is the only option to achieve what you want. I don't have access to my installation now to check the database so I can post the precise queries needed for this. But I will do so at a later time if no one beats me to it in the meantime.

Edited March 6Mar 6 by Miss_B

I had a mod do this once, put him on the naughty step and removed that option from them. Only I have that power. Absolute nightmare 😂

(But yeah, SQL query soon fixed it)

 

I had a mod do this once, put him on the naughty step and removed that option from them. Only I have that power. Absolute nightmare 😂

(But yeah, SQL query soon fixed it)

How do I set it so mods can't do this?

Also, if someone wants to post (or PM me a query), I'd love to get this cleaned up.

Thanks

 

How do I set it so mods can't do this?

Also, if someone wants to post (or PM me a query), I'd love to get this cleaned up.

Thanks

I would adjust the settings not to hide all the posts, but to just restrict new posts, until you have the time to review the situation when someone is flagged as a spammer.

 

How do I set it so mods can't do this?

Also, if someone wants to post (or PM me a query), I'd love to get this cleaned up.

Thanks

Members > Moderators > Edit the group > Member Management > Turn off “Can use the flag a spammer tool”

I don’t have the SQL query anymore.

 

I don’t have the SQL query anymore.

Thank you for your other help above!

Does anyone have a query to unhide all those posts?

The posts themselves are unhidden, but if you look at this users activity, they still look hidden.

If you click the first post, here's the top of it.

How do I edit it so they don't look hidden in their activity?

Thanks

You can try rebuilding the search index to see if that helps. However, custom queries are outside our scope of support, I'm afraid.

 

You can try rebuilding the search index to see if that helps. However, custom queries are outside our scope of support, I'm afraid.

That seemed to work, thank you.

Edited March 7Mar 7 by Square Wheels