We made a tiny mistake on our instance where we set a user to trust level 0. This hid all of their posts… Any way to automatically unhide them now? There are thousands of posts, so doing it manually is out of the question. Thanks.

I had a similar problem. Used the following and it worked. First, entered ./launcher enter app then rails c and then: ActiveRecord::Base.exec_sql("UPDATE posts SET hidden = false, hidden_reason_id = NULL, hidden_at = NULL WHERE user_id = ?", User.find_by_username("USER_NAME_HERE").id)

I don’t think so. But the default trust level for our users is trust level one.

Yeah hi that user was me… My trust level was set to 0, and there were about 5000 posts, so doing it manually is out of the question. :confused: @codinghorror @sam

[图片] NomNuggetNom: the default trust level for our users is trust level one This is a bad idea, and I strongly advise against this. TL0 has important spam protection. You are opening yourself up to a lot of spam with TL1 default. I just added this to the site setting description: Default t…

That’s not the issue we’re having (nor have we had that issue in the past). We use SSO which requires a different sign up method, so we don’t get spam bots or anything. Anyway, this is a topic for another time :stuck_out_tongue:

OK cool, with SSO enabled it is probably safe, but we have seen sites with bad login protections (no captcha, no email verification, etc) do much worse with SSO enabled. We’ve had to go back and enable many spam protections that we normally disable with SSO turned on.

Also, by the way, we tried to change that users trust level back to zero… with no change. I might just go back and change all posts [200] to listed if there isn’t a fix.

Okay then, put this in a psql console: discourse=# UPDATE posts SET hidden = false, hidden_reason_id = NULL, hidden_at = NULL WHERE user_id = (SELECT id FROM users WHERE username_lower = 'fhtzoob') ; UPDATE 5000 discourse=# \q Or, from a Rails console: (./launcher enter app then rails c) ActiveR…

Awesome! Thank you very much :smile:

Um… not all my posts came back…

I think you’ll have to log in for the posts to update… which you can’t since your suspended.

Batch unhide posts

Support

codinghorror (Jeff Atwood) 2019 年3 月 3 日 22:02 20

Yes that does sound like a good idea

话题		回复	浏览量
Trust Level 1 hiding post with one flag Support moderation , trust-levels	3	722	2020 年9 月 22 日
How do I promote all users to trust level 1? Support trust-levels	6	1682	2020 年3 月 19 日
"Hide new user profiles" setting applies to TL2 users Bug	4	238	2025 年7 月 3 日
Understanding Discourse Trust Levels Blog trust-levels	119	93576	2026 年8 月 29 日
Please update 'Understanding Discourse Trust Levels' — or is there a different doc? Support	28	3728	2022 年4 月 23 日

Batch unhide posts

相关话题