Support Forum

Not Really.  In the topics database table there is no column entry for post_date which is why the option offered was giving an invalid query, the post_date column is in the posts database table. 

The topic_date column gives the date the topic was posted (supplied either by the actual posting date or the amended date if using that option) so using that to sort desc will give the same output as sorting by topic_id desc if the topic post date wasn't altered by a moderator;  In which case the topic would then appear out of position in the topic list when viewed (the exact issue I was having).

Using the topic_date instead sorts the forum topics correctly, repositioning the altered date topics accordingly.

It may be a good idea to use this as the default way of sorting forum topics if you are going to allow moderators and admins permission to change the post dates.

TBH I am surprised that it hasn't been picked up on before, but maybe no-one has had to do quite what I am having to do with it

Hi Papa

I am manually having to transfer over 2000 forum topics from a hosted forum which allows no access to the back end.

The issue happens when I am adding these topics and replies (in reverse order) and an existing member decides to post a new topic on the new forum.  Everything then goes out of the window as far as sorting is concerned hence my need of the filter and having to make so (oh so many) topic date edits.

I sometimes wish I had turned the guy down but a customer is a customer.