I’ve modified an existing group and set the Trust level automatically granted to members when they're added value to be 2, so all members of this group will be prompted to Trust Level 2 when added to the group: [Screenshot 2023-02-25 at 17.15.17] However, it doesn’t retrospectively add all the existing group members to Trust Level 2 :confused: How can I force this to occur? Or how can I retrospectively upgrade all the members of the group up to TL2? :thinking:

:warning: This solution is advanced. Rails command can be only done if you have SSH access to your server and should be avoided if you’re not sure of what you’re doing. In any case, always do a backup first. Hello Richie :slight_smile: You can use a rails script similar to this: That should do it from the rails console: target_group = Group.find_by_name("test") users = User.joins(:group_users).where(group_users:{group_id: target_group.id}) users.each do |u| u.trust_level = 2 u.save end Thanks @nathank for Delete all users not in a specific group - #2 by nathank :slight_smile:

Thanks @Canapin I’m not familiar with the rails console at all, but I ran what you posted here and it’s now sitting on END and flashing a cursor at me: [Screenshot 2023-02-25 at 19.49.33] Do I need to commit this change somehow? :thinking: (it has not promoted them to TL2)

[image] Richie Rich: Do I need to commit this change somehow? :thinking: No, that’s just an output that doesn’t have any effect on the script execution. I believe you can press q to leave it. You can also use this: [intellidiot] How to suppress Rails console/irb outputs ruby-on-rails, ruby, irb answered by intellidiot on 10:04AM - 13 Jan 11 UTC [image] Richie Rich: (it has not promoted them to TL2) It may be related to the Group.find_by_name("test") part. I don’t know if it accepts the actual group name, or slug. :person_shrugging: Also, I should have mentioned that using rails commands is fairly advanced and a backup should be made before doing this kind of stuff. I apologize for that.

[image] Richie Rich: (it has not promoted them to TL2) Hmmm, something strange has occurred. If I look at a user which was TL1 before I ran this rails script, I can see they are now TL2 (which is great, thank you so much!) [Screenshot 2023-02-25 at 19.59.16] But, if I look at the TL2 user group, the total number of users in the group has not increased :thinking: Similarly, if I search for one of the users that was just upgraded to TL2, they do not appear in the search results for the TL2 group: [Screenshot 2023-02-25 at 19.59.39] :thinking: Also, the user has not gained the TL2 badge: [Screenshot 2023-02-25 at 20.01.35] :thinking:

The groups are updated during a Sidekiq job. The task is EnsureDbConsistency and can be triggered through Sidekiq, if you know how to do it. You can also wait a few hours; groups will be updated automatically. :slight_smile: I figured it out this here: [image] How do I promote all users to trust level 1? Support I figured it out. The sidekiq task which triggers the trust level groups population is EnsureDbConsistency. After updating users trust levels from command line (either gaining or losing trust levels), EnsureDbConsistency will move users in and out from these groups. :slight_smile:

Brilliant, thank you! I shall wait patiently for it to resolve itself :blush: Thanks for your time @Canapin - and your solution - you have saved me a mountain of time by doing this manually :scream:

You’re welcome. I was just a bit too quick suggesting a rails command without proper warning as it can go bad if we don’t really know what we’re doing. I’ll add a more visible warning to my post :slight_smile:

This rails task appears to have downgraded all our TL4 and TL3 users, to TL2 :thinking: I’m hoping the EnsureDbConsistency task will automatically fix them all overnight :blush:

It will, the TL3 users will be re-promoted assuming they meet the criteria still. TL4 will need to be manually promoted. To avoid this each user needs to be evaluated by the statement and only promoted if they’re currently below TL2. If your TL4 users are also members of a group you could use that to promote them en-masse.

[image] Stephen: TL4 will need to be manually promoted. Great info, thanks @Stephen I’ll do that now :slight_smile:

Everything looks peachy this morning :blush: Thanks again @Canapin and @Stephen :wave:

Promoting users to TL2 when joining a group - retrospectively?

Product Support

Richie (Richie Rich) February 25, 2023, 9:56pm 18

Great info, thanks @Stephen I’ll do that now

Topic		Replies	Views
How do I promote all users to trust level 1? Product Support trust-levels	6	1744	March 19, 2020
Rails command to mass promote users to TL2? Development rails-console	9	1285	April 25, 2020
Is there a way to retroactively update trust level and title for existing group members? Product Support	2	1115	May 4, 2016
How to update and unlock all groups? Product Support	4	664	June 8, 2023
Trust level changes while automatic groups do not change Bug	4	1261	September 14, 2016

Promoting users to TL2 when joining a group - retrospectively?

Related topics