# User attributes
**URL:** https://meta.discourse.org/t/user-attributes/315619
**Category:** Development
**Tags:** rails-console
**Created:** [July 9, 2024, 5:21pm UTC](https://meta.discourse.org/t/user-attributes/315619 "2024-07-09T17:21:51Z")
**Posts on this page:** 9
**Page:** 1
### Author:  [@anon82911141](https://meta.discourse.org/u/anon82911141)
#### Post date: [July 9, 2024, 5:21pm UTC](https://meta.discourse.org/t/user-attributes/315619/1 "2024-07-09T17:21:51Z")
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:
How would I change these values?
Thanks.
---
### Author:  [@pfaffman](https://meta.discourse.org/u/pfaffman)
#### Post date: [July 9, 2024, 6:37pm UTC](https://meta.discourse.org/t/user-attributes/315619/2 "2024-07-09T18:37:45Z")
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?
---
### Author:  [@anon82911141](https://meta.discourse.org/u/anon82911141)
#### Post date: [July 9, 2024, 6:55pm UTC](https://meta.discourse.org/t/user-attributes/315619/3 "2024-07-09T18:55:14Z")
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.
---
### Author:  [@pfaffman](https://meta.discourse.org/u/pfaffman)
#### Post date: [July 9, 2024, 7:08pm UTC](https://meta.discourse.org/t/user-attributes/315619/4 "2024-07-09T19:08:54Z")
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
```plaintext
PostTiming.destroy_for(current_user.id, [topic_id])
```
So that’s a start. Maybe this:
```plaintext
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.
---
### Author:  [@anon82911141](https://meta.discourse.org/u/anon82911141)
#### Post date: [July 9, 2024, 7:23pm UTC](https://meta.discourse.org/t/user-attributes/315619/5 "2024-07-09T19:23:56Z")
In that case, is it possible to merge an admin account via the console? I’m aware it’s not with the admin interface.
---
### Author:  [@pfaffman](https://meta.discourse.org/u/pfaffman)
#### Post date: [July 9, 2024, 7:26pm UTC](https://meta.discourse.org/t/user-attributes/315619/6 "2024-07-09T19:26:07Z")
Just remove their admin privs and do it?
But it looks like you can do it with a rake task: [Merging user accounts](https://meta.discourse.org/t/merging-user-accounts/275288)
> [@Merging user accounts](https://meta.discourse.org/t/merging-user-accounts/275288/1):
>
> `rake users:merge['source_username','target_username']`
---
### Author:  [@anon82911141](https://meta.discourse.org/u/anon82911141)
#### Post date: [July 9, 2024, 7:29pm UTC](https://meta.discourse.org/t/user-attributes/315619/7 "2024-07-09T19:29:37Z")
Thanks for that - not sure if it’s possible to take away the original administrator’s admin privileges though.
---
### Author:  [@pfaffman](https://meta.discourse.org/u/pfaffman)
#### Post date: [July 11, 2024, 6:23pm UTC](https://meta.discourse.org/t/user-attributes/315619/8 "2024-07-11T18:23:15Z")
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
```
>
Looks like that might do what you want.
---
### Author:  [@system](https://meta.discourse.org/u/system)
#### Post date: [August 10, 2024, 6:23pm UTC](https://meta.discourse.org/t/user-attributes/315619/9 "2024-08-10T18:23:24Z")
This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.