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: <a class="lightbox" href="https://global.discourse-cdn.com/meta/original/4X/7/3/e/73e56e75aa1500ed9b8cfce92c0c88dc42498f94.png" data-download-href="/uploads/short-url/gxgsKNn2nQGl7GnH5PW2XOrsHU8.png?dl=1" title="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)" rel="noopener nofollow ugc">[The image shows user account details with various fields such as username, email, activity status, trust level, and a…

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, t…

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 [image] 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(a…

User attributes

Development

pfaffman (Jay Pfaffman) July 9, 2024, 6:37pm 2

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?

Topic		Replies	Views
How to re-calculate the top users stats? Support	3	1399	January 12, 2017
Merged two users, stats don't change Support merge-user	2	400	July 26, 2023
How to prevent the updating of specific user fields Development	3	153	February 24, 2025
Reset user logins Support	5	232	June 25, 2024
Bulk change user settings Support	1	1664	March 31, 2017

User attributes

Related topics