Hi, I tried running commands in rails c such as User.find(1).update(ip_address: nil, topics_viewed: nil) to update the things in this list below - however, I kept getting errors: [The image shows user account details with various fields such as username, email, activity status, trust level, and associated metrics, with some sensitive information redacted in red for privacy. (Captioned by AI)] How would I change these values? Thanks.

They can’t be edited because they aren’t part of the user model. There’s a model that keeps up with what topics a user has viewed (TopicViewItem), so you’d need to clear those (maybe TopicViewItem.destroy_all – no – that doesn’t work.) and then run whatever updates that. And if they were emailed, then the last time they were emailed is going to be the last time they were emailed. There’s a PostTiming model that keeps up with what posts are read, and read time. Ah, you can search the source for PostTiming and find something like PostTiming.destroy_for(current_user.id, [topic_id]) So that’s a start. Maybe this: PostTiming.destroy_for(1, PostTiming.where(user_id: 1).pluck(:topic_id).uniq)) There are some ensureconsistency tasks that might be how to update those, but I’m not quite sure.

What errors are you getting? Some of those things live in other tables/models. Email addresses, for example, are in their own table, so you need to update those there. What problem are you solving?

Just trying to reset statistics, want to get rid of topics_viewed, posts_read, read_time and last_emailed. Not interested in user details as they can be changed using the interface, only the values that affect the user’s profile but cannot be edited.

In that case, is it possible to merge an admin account via the console? I’m aware it’s not with the admin interface.

Just remove their admin privs and do it? But it looks like you can do it with a rake task: Merging user accounts [画像]Merging user accounts rake users:merge['source_username','target_username']

Thanks for that - not sure if it’s possible to take away the original administrator’s admin privileges though.

If it’s a developer (that’s set in the app.yml) then I think you’re right. Also, I just noticed this rake task! rake destroy:stats app/services/destroy_task.rb main end def destroy_private_messages Topic .where(archetype: "private_message") .find_each do |pm| @io.puts "Destroying #{pm.slug} pm" first_post = pm.ordered_posts.first @io.puts PostDestroyer.new( Looks like that might do what you want.

ユーザー属性

開発

pfaffman (Jay Pfaffman) 2024 年 7 月 9 日午後 7:26 6

管理権限を削除して実行するだけですか？

しかし、rakeタスクで実行できるようです: Merging user accounts

トピック		返信	表示
How to re-calculate the top users stats? Product Support	3	1431	2017 年 1 月 12 日
Merged two users, stats don't change Product Support merge-user	2	415	2023 年 7 月 26 日
How to prevent the updating of specific user fields Development	3	166	2025 年 2 月 24 日
Reset user logins Product Support	5	253	2024 年 6 月 25 日
Bulk change user settings Product Support	1	1674	2017 年 3 月 31 日

ユーザー属性

関連トピック