After migrating data from wordpress I have an issue the the default ordering of ‘latest’ doesn’t make a lot of sense. Posts from 2012 show up as active 7 hours ago. When importing the created_at and updated_at are set to the original posting date.
I have noticed that any posts with images, discourse will download the images (which is nice) which then flags it as being edited right NOW which I presume is why these posts are now in latest. The others I’m not so sure about…
Staging Server: http://dev.discourse.visitpedro.com/t/expert-character-illustration-to-animation/12257/last
I’ve not delved greatly into the db schema other than a quick look at some of the models.
Is there a simple SQL update I can run here,? I’m happy for latest to reflect activity for all imported data.
Going forward all new posts will populate latest correctly however it just looks wrong right now.