Pages: [1]   Go Down
Author Topic: posting time-warp oddity  (Read 850 times)
0 Members and 1 Guest are viewing this topic.
Leighton Buzzard, UK
Offline Offline
Edison Member
*
Karma: 21
Posts: 1339
View Profile
 Bigger Bigger  Smaller Smaller  Reset Reset

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!
Logged

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

Global Moderator
Dallas
Online Online
Shannon Member
*****
Karma: 212
Posts: 13085
View Profile
WWW
 Bigger Bigger  Smaller Smaller  Reset Reset

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

Forum Administrator
Milano, Italy
Offline Offline
Sr. Member
*****
Karma: 23
Posts: 292
View Profile
WWW
 Bigger Bigger  Smaller Smaller  Reset Reset

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?
Logged

C.

Global Moderator
Dallas
Online Online
Shannon Member
*****
Karma: 212
Posts: 13085
View Profile
WWW
 Bigger Bigger  Smaller Smaller  Reset Reset

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.
« Last Edit: February 19, 2011, 02:41:21 pm by Coding Badly » Logged

Leighton Buzzard, UK
Offline Offline
Edison Member
*
Karma: 21
Posts: 1339
View Profile
 Bigger Bigger  Smaller Smaller  Reset Reset

thanks
that makes sense!
Logged

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

Global Moderator
Boston area, metrowest
Offline Offline
Brattain Member
*****
Karma: 549
Posts: 27425
Author of "Arduino for Teens". Available for Design & Build services. Now with Unlimited Eagle board sizes!
View Profile
WWW
 Bigger Bigger  Smaller Smaller  Reset Reset

I remember, doing the time-warp ...
Logged

Designing & building electrical circuits for over 25 years. Check out the ATMega1284P based Bobuino and other '328P & '1284P creations & offerings at  www.crossroadsfencing.com/BobuinoRev17.
Arduino for Teens available at Amazon.com.

Pages: [1]   Go Up
Jump to: