Go Down

Topic: posting time-warp oddity (Read 1 time) previous topic - next topic


I have been wondering for a while now why I get odd results when I browse the forums (fora?)

The main symptom is that unread posts appear, but not at the top of the list

I always mark all read when I leave a forum
then when I go back, a cheeky one has slipped in apparently 3 hours ago!

I suspect that the local time (either by time zone, or just from the user's PC) is being used as the time of posting

Would it make more sense to use the database time (time at the server)
That way threads would appear in order, as indeed would posts

You can see that some threads have posts apparently out of time order, too!
there are only 10 types of people
them that understands binary
and them that doesn't

Coding Badly

I think it's the result of someone editing a post.


The server uses its own clock to do timestamps, and the time is translated to the timezone specified on user profile.

Topics are sorted by the descending time of LAST post in each topic.
This means that if someone posts a reply on a topic, the topic pops up on the first place.

If you find some topic out-of-order can you post a link to that so we can further investigate?

Coding Badly

Feb 19, 2011, 08:37 pm Last Edit: Feb 19, 2011, 08:41 pm by Coding Badly Reason: 1
Post timestamps are not updated when a post is modified...

Reply #3 on: Today at 01:37:09 PM
Last Edit: Today at 01:38:49 PM by Coding Badly
Reply #3 on: Today at 01:37:09 PM

...which (I think) explains the behaviour @mmcp42 is seeing.  A post is displayed with a has-been-modified marker but is not at the top of the list.


there are only 10 types of people
them that understands binary
and them that doesn't


I remember, doing the time-warp ...
Designing & building electrical circuits for over 25 years.  Screw Shield for Mega/Due/Uno,  Bobuino with ATMega1284P, & other '328P & '1284P creations & offerings at  my website.

Go Up

Please enter a valid email to subscribe

Confirm your email address

We need to confirm your email address.
To complete the subscription, please click the link in the email we just sent you.

Thank you for subscribing!

via Egeo 16
Torino, 10131