Support Forum

Timestamping Issue

KS Karthik Subramanian
Karthik Subramanian
Member

Hi guys,

 

I just upgraded my current forum to the latest mini-patch regarding the security issue via the update schedule in WP and now my forum is experiencing issues relating to the timestamp when posting replies to existing topics.For posts that were made today, we’re seeing “seconds” on the last posts column and in the widget. Same thing happens when creating a new topic, – I get a “-28793 seconds ago” as a last post.  Is there a way of fixing this problem? Do I need to update my themes as well? I have a tweaked theme based on black-gold. We need this resolved as soon as possible.

 

Here are the images of the issues:

 

http://imageshack.us/photo/my-images/580/prob1u.jpg/

http://imageshack.us/photo/my-images/822/prob2ih.jpg/

 

Cheers.

 

**EDIT** Managed to fix the issue with forum timestamps not showing right on the forum. I changed my wordpress to associated with an actual city location rather than a UTC but the widget is still having the issue.

29 Answers

New Answer

YS Yellow Swordfish
Yellow Swordfish
Member

Could you tell me what the setting was for the WP server originally and also what your setting was personally in your SP profile? Would like to see if I can replicate this….

KS Karthik Subramanian
Karthik Subramanian
Member

Setting was on UTC 8 (Changed to Perth which fixed the forums)for WP server and SP Profile ins on Australia/Perth.  Members across Oceania are getting the same issue with the widget.  Forums is fine though now.

YS Yellow Swordfish
Yellow Swordfish
Member

I might have worked out the problem with the widget. I have someone who is going to run some tests later today so I will know soon. If I haven’t replied by tomorrow morning can you give me another shout on this?

EK Edward Koon
Edward Koon
Member

I am experiencing a 4 hour difference in my posts.

Server is in -4 and my time is -5. Time in WordPress setting page is correct. As is my profile settings in SP. Is there any other place in SP to set the time zone?

Thanks.. smile

YS Yellow Swordfish
Yellow Swordfish
Member

Sorry –   to answer your question – there is nowhere else.

do you have easy access to your database and know your way around in one? If so would it be possible for you to take a quick look at the ‘sfposts‘ table – at a recent forum post (highest post_id) to check of the post time recorded is accurate with your WP server setting?

EK Edward Koon
Edward Koon
Member

Looks like something is hokey. I’m 1 hour away from my server Hostgator in Dallas TX.

Just did a time test post. From the DB: Time 2012-03-29 16:59:27

YS Yellow Swordfish
Yellow Swordfish
Member

Well the date/time saved in the database should represent the time zone as set in the WP General Settings. So to save me doing contortions on this are you saying that was not the case? Looks like it was an hour out maybe.

EK Edward Koon
Edward Koon
Member

I just noticed the post time was correct when i was logged out. So it must have something to do with my profile time setting not being right.

When i just logged in here after getting your email notification, i clicked on the subscribed button, one new message and was told the last post was 5 hours ago. >Last Post  Yellow Swordfish  5 hours ago<

Maybe the time offsets in the user profile settings are off by 5 hours? I’m sure i can either add or deduct what ever time zone it takes to be correct.

I just noticed the difference in message times between login and log out.

EK Edward Koon
Edward Koon
Member

I should add on my site the logged in and logged out times are different. Don’t know if that’s the case here since i cant see the message unless I’m logged in.

EK Edward Koon
Edward Koon
Member

Changing my profile TZ to UTC+0 corrected the problem.. wink

YS Yellow Swordfish
Yellow Swordfish
Member

I am not really sure what it is you are trying to tell me – a bit confused. So maybe if I tell you what is supposed to happen you can ascertain whether it is or not…

Forum posts – like WP blog posts – are saved with the date/time as set in the WP server timezone (Settings > General). Once set – this should never be changed. This setting is NOT intended to be the location of the physical server but the timezone you want your dated posts to be stamped in usually your ‘home’ zone. (Although – of course -the site owner can set it to whatever they prefer).

Anybody who visits your site as a non-logged in user – or – a user who has not set up their personal timezone (SP > Profile > Display Options) – will see the forum posts with the date/time as recorded in the database – i.e., the server timezone.

A logged in user who HAS set their personal timezone will see the date/time on posts adjusted to their personal timezone if this is different from the server zone.

Does this make sense? Is this how things are working on your site?