I’ve imported a large older mailing list into Discourse and found (after merging various threads that were not initially properly identified to be part of a parent thread) that threads have become disordered. Many earlier dated thread messages are being shown in Discourse AFTER parent threads that have earlier dates. Is there a method to resort threads so that they are ordered by date from oldest (original post) to newest?

No. The problem is that topics are sorted in post-id order. And, as you have described, you have imported posts in an order other than the order that they should have been created. I am afraid that the only proper solution is to fix the import so that posts are imported in the proper order. It sounds like, though, that all you’d need to do is wipe the database and re-run the import script. (Or other “solutions” include don’t care about the post order, it’s old stuff that no one is going to read anyway, and contrive to, for each topic, delete all of the existing posts and re-create them in the correct order.)

Hmm, these have been in place now for quite some months. I don’t really believe the deletion and reimportation is an appropriate solution. I wonder if we can build a plugin that will allow post-id reordering… hmm.

Oh. That’s too bad. Anything is possible, I suppose, but that will affect performance on the whole site forever.. You could conceivably delete those topics and the associated custom fields and then run the script again. You’d want to test very carefully on a staging site before you do it on your live data.

If the post-ids are reordered then I wouldn’t think it would permanently affect it. I suppose another option would be a plugin that would simply sort a thread by date as it’s queried…

[image] mreach: the post-ids are reordered then I wouldn’t think it would permanently affect it Right. If you delete and recreate all the posts on the right order you’ll be all set.

How to resort a topic's messages by date?

Product Support

pfaffman (Jay Pfaffman) August 4, 2020, 12:30am 6

Right. If you delete and recreate all the posts on the right order you’ll be all set.

Topic		Replies	Views
Mailing list import: posts out of order Product Support	2	1195	August 23, 2018
How can I sort the topic replies by date Migration rest-api	7	1296	September 8, 2022
Importing from Vanilla Forums results in out-of-order replies. Re-index Replies? Development	9	887	November 11, 2021
How to Order Topic Replies in Chronological Order By Default Product Support	4	648	March 27, 2024
A way to reorder posts? Feature	23	7761	February 1, 2025

How to resort a topic's messages by date?

Related topics