How do I change forum created date?

[Falco]

@pfaffman

That’s not quite it. I had someone else who wanted to change that date before. I tracked down the query that gets this date and found a way to change it. I can’t remember and can’t find any notes I may have made.

Wow our AI response told that to me too, but I dismissed it as an hallucination because I couldn’t believe we would do that, but looks like it is indeed true

So the AI solution is correct here @lilstranded

@support-bot

Steps to update the date:

1. Access your Discourse database (e.g., via SSH or a database GUI tool such as psql or HeidiSQL).
2. Identify the first row in the schema_migration_details table.
3. Run a query to update the created_at field with the desired date:

UPDATE schema_migration_details SET created_at = ‘2016-01-01 00:00:00’ WHERE id = 1;

* After making this change, restart your Discourse instance:
* For Docker-based installations: `./launcher restart app`.

Just adding how to get there would be

# ssh into the server
cd /var/discourse
docker exec -it app bash
su postgres
psql
/connect discourse
UPDATE schema_migration_details SET created_at = '2016-01-01 00:00:00' WHERE id = 1;
\q
exit
exit
exit