I was just investigating an issue with trust levels, and realized that a handful of moderators had their trust level locked and I don’t know why. Does this happen automatically when you promote someone to moderator or shouldn’t their trust levels adjust automatically as they move along and up in the…

That’s do the trick! SELECT username from users WHERE manual_locked_trust_level = 1

Is each lock logged and if so, is the lock presented as a filter that can apply?

Using Data Explorer , you can query them using. locked-trust-levels.dcquery.json (184 Bytes)

that’s a good idea - I checked, however and there is no admin action log for “locked trust level”. [图片] cpradio: Using Data Explorer , you can query them using. locked-trust-levels.dcquery.json (184 Bytes) cool! I’d like to try this but am realizing I am unable to import data queries - click…

That is indeed a bug. [图片] In the meantime this is the query: SELECT username, trust_level from users WHERE trust_level_locked = true

ok - after refreshing a few times and clicking around in the query explorer I finally got the option to create a new query. This is super helpful - many thanks. According to your query, it looks like I have 351 users with locked trust levels. This is a fairly random list of users who don’t have any…

Ohhh… I think I have an idea what’s happening here. I have been using the group feature to automatically grant a trust level when they are added. Is it possible that this has been actually locking them at this trust level? This is not what I want, and it’s not what I think the feature does. But I c…

That may be doing it. IIRC, when TL is set higher than what the user currently qualifies for, it locks them in to prevent the system from downgrading them.

[图片] tobiaseigen: Would you be willing to provide me with a command to reset these to unlocked? I’m not at a computer right now. I imagine out would be easiest to do via command line but after reading your other post I’m not positive it is a good idea to do so.

Thanks! I think I’d rather have the automatic trust level system work than have people locked at a low trust level. So if you can provide the command when you get a chance I’d appreciate it. :seedling:

I believe this should do it. (be sure to backup your instance before running it) User.where(trust_level_locked: true).update_all(trust_level_locked: false) Edit: Well, duh! You could simplify this to (as no user should have a locked TL) User.update_all(trust_level_locked: false)

List of users with locked trust level due to group membership?

Community Building Data & reporting

JammyDodger 2023 年4 月 30 日 12:04 23

查看一下 explorer 表格，似乎现在有了 manual_locked_trust_level 和 group_locked_trust_level，如果您需要制作更新版本，这或许能帮到您？

话题		回复	浏览量
Trust level changes while automatic groups do not change Bug	4	1244	2016 年9 月 14 日
How to auto remove from groups when trust level falls? Support	6	559	2021 年8 月 13 日
Lock trust level doesn't seem to work Bug	5	1053	2018 年6 月 20 日
User trust level resets to zero when unlocked Bug	5	633	2023 年3 月 1 日
Trust Level locked after manual promotion Support	2	533	2019 年4 月 16 日

List of users with locked trust level due to group membership?

相关话题