Hi guys, Today I had an unusual request after a migration where we skipped all accounts that never posted. A user that had never posted, but values having an account, wanted his account back. I told him he could just re-register with his old username which he did. But now he wants to have his ‘member since’ adjusted to 2011, when he registered his old account… Is there any way I can accomplish this?

By ‘member since’ do you mean the Joined section in your account summary? [Screenshot_2021-04-17 Profile - cocococosti - Discourse Meta] If you have admin access to the server or database, you could edit the created_at parameter for that user in the Users table. You can do it from the rails console this way: rails c user = User.where(username: ' ') user.update(created_at: "2011-02-10 00:00:00.00000") You could also do it directly in the Postgre database (although I don’t recommend it): update public.users set created_at='2011-02-10 00:00:00.00000' where username = ' '; I tested this in my local environment and worked correctly: Changed from: [Screenshot_2021-04-17 Profile - costi abarca - Constanza's discourse(1)] To: [Screenshot_2021-04-17 Profile - costi abarca - Constanza's discourse] Please be very careful if you decide to go with this, I suggest you take a backup of the database before doing anything :sweat_smile:

עדכן תאריך רישום למשתמש

תמיכה

rmens 17 באפריל,‏ 2021,‏ 10:06am 3

Thanks a lot. That was the parameter I needed to change.

נושא		תגובות	צפיות
Change user registration date (created_at) via API Development rest-api	7	1516	28 ביולי,‏ 2021
Possible to change joined date? Product Support	6	3505	23 ביולי,‏ 2015
I need a plugin that enables changing user registration dates Marketplace	2	1316	17 בינואר,‏ 2017
Users.updated_at not renewed on all updates Development rest-api	4	451	7 במאי,‏ 2020
Incorrect account stats Site feedback	4	245	25 באפריל,‏ 2025

עדכן תאריך רישום למשתמש

נושאים קשורים