Hello everyone, this is my first post here, I hope I am doing everything right. Is it possible to change the joined date for any given user? I ask, because I want to bootstrap my forum and make it ready for launch day, but I want the first user (admin and system) to be joined on launch day and no…

I did some manual join date modification for some of the oldest users on a forum when I migrated. Like Jeff suggested, you basically need to pick out the users manually, like so: user = User.find_by(username: 'krilnon') user.created_at = Time.now # user.created_at = Time.parse('2013-02-04 3:00 PM')…

Thanks @codinghorror , I tried to search for the mentioned howtos, but I can’t find them. Can you please link to them.

Yeah good point I did some searching but nothing good came up immediately. We should have a dedicated howto topic for entering the container, and running an arbitrary SQL query. @techapj can you assist? It’s kind of like this [image] Edit a user preference for everyone or a…

If me and @system are the only two users in the forum I can run a query to change the joined date for all users, as mentioned in the topic you linked. But I’ve no idea how that query should look like. I will wait for @techapj , hopefully he can help me with that.

That worked just perfect on point. Thanks a lot @krilnon ! :punch:

Possible to change joined date?

Product Support

codinghorror (Jeff Atwood) July 23, 2015, 7:25am 2

Only from SQL at the Ruby command prompt. Not in the UI at this time. But changing it via a DB query should be straightforward, there are some howtos here on that.

Topic		Replies	Views
Bulk change user settings Product Support	1	1667	March 31, 2017
Change user registration date (created_at) via API Development rest-api	7	1491	July 28, 2021
Edit a user preference for everyone or a subset of users Self-Hosting how-to	0	14262	February 12, 2015
Adjust register date for user Product Support	2	578	April 17, 2021
Editing post date? Feature	20	3842	November 12, 2024

Possible to change joined date?

Related topics