Fixing a topic timestamp change gone wrong?

[adamengst (Adam C. Engst)]

I have a topic where the post date matters for an external system (it’s a leaderboard that looks for posts by people who ran a certain course on the same day). I mistakenly thought I could redate a post within the topic and ended up changing the topic’s date from April 17 to June 19. I did this on June 26, one week later. When I realized what I’d done and reset the topic date back to April 17, nearly all the posts ended up being given a date of April 24, presumably because Discourse tried to give them dates relative to June 19 and ran out of dates after June 26 (because they would have been in the future). And setting the date back to April 17 gave them relative dates one week later, or April 24.

Is there any way I can manually fix the dates on the interim posts?

Sweet 1600 Star Posts (2026)

Thanks!

[Moin]

I think this should still work:

Editing post date?

Here’s how to do it via the command line # ssh into your server cd /var/discourse # or /var/docker on pre-V1 install ./launcher enter app rails c post = Post.find_by(id: 1234) post.created_at = DateTime.new(2001,2,3,0,0,42) # year, month, day, hour, minute, seconds post.save

This might be helpful too, because finding the post ID is more difficult than the topic ID and post number:

Editing post date?

By the way, you can also find the post by the topic id and post number which are perhaps easier to read from the forum via the share link instead of inspecting source: Post.find_by(topic_id: 123, post_number: 45)

As always when using the Rails console: it’s a good idea to make a backup first, just to be safe.

[adamengst (Adam C. Engst)]

Thanks! I’ll give it a try.

[adamengst (Adam C. Engst)]

That worked, and since I had 24 posts to fix, I spent some time with Claude to build a Ruby script that would do it. And it was able to scan my email and other files to find the correct timestamps. The overall process wasn’t quick, but it was much less tedious than laboriously figuring out and copying and pasting timestamps.

Thanks!