Funny order for posts in thread

Posted on 2010-01-13 04:20:14.747972-08 by exiftool

Originally I thought that you just changed the forum so the most recent posts appeared at the top of a thread instead of the bottom, but it isn't this simple. Take a look at this thread:

http://cpanforum.com//threads/12017

One of the posts from January 2010 appears at the bottom, underneath some posts from December 2009..

- Phil

Direct Responses: 12189 | 12192 | Write a response

Posted on 2010-01-13 08:09:13.642881-08 by exiftool in response to 12188

Re: Funny order for posts in thread

And while I have your attention: The post date/time format should be fixed. For example, my last post shows up in the forum list with a date/time of "2010-01-13 04:20:14.747972-08". I think dropping the sub-seconds would be good. Also, if the "-08" is a timezone, it should be formatted as "-08:00".

- Phil

Direct Responses: Write a response

Posted on 2010-01-13 23:28:48.574018-08 by szabgab in response to 12188

Re: Funny order for posts in thread

Apparently SQLite kept the order of the lines in the database straight so we have not noticed the lack of ORDER BY on the queries. Now that we moved to PostgreSQL this created the funny ordering.

I put an "ORDER BY id DESC" on the SELECT statement of the query now for displaying threads. This is showing the most recent post at the top. Please check.

I know in the near future I should allow each user to decide how s/he wants to see the posts and even adding a threaded view but in the meantime, should I leave it this way or should I turn it around showing the most recent post at the bottom?

Direct Responses: 12193 | Write a response

Posted on 2010-01-14 04:13:16.877298-08 by exiftool in response to 12192

Re: Funny order for posts in thread

Thanks.

I would go back to most recent at the bottom because this seems to be the standard for other forums and is therefore less confusing.

- Phil

Direct Responses: 12194 | Write a response

Posted on 2010-01-14 04:35:01.594773-08 by szabgab in response to 12193

Re: Funny order for posts in thread

done, I'll deal with the timestamp later.

Direct Responses: Write a response

Perl Weekly newsletter
A free weekly newsletter for people who are busy to read all the blogs. click here to check it out.