Support Forum

Post time display

71 Answers

New Answer

CF Conrad_Farlow
Conrad_Farlow
Member

London! London! London! So the wp time is British Summer Time = UTC+1.

I’m very familiar with UTC having used it for years in another hobby.

YS Yellow Swordfish
Yellow Swordfish
Member

Conrad: Sorry – I probably didn’t make myself clear. I wanted you to make sure that both your server timezone (wp settings) and your personal timezone (profile) were set explicitly to London. In other words remove ANY UTC setting from the equation. I am trying to eliminate possible causes and the use of UTC could well be the problem. If you an eliminate that and then make a new post to see the re4sult I would appreciate it.

Lee: While not discounting the nice date routine as the possible problem you do have to remember that the date passed to this routine has already been adjusted for the users personal timezone. This has been carried out when querying the database.

But – basically I am still looking into it but have a suspicion that the problem may lie with the use of a UTC setting in one of the timezones as opposed to an explicitly selected location. Hence my request to Conrad above.

CF Conrad_Farlow
Conrad_Farlow
Member

Guys how many times do I have to say this?

I do not have any UTC settings either in the wp settings or in my personal profile they are absolutely both set to London and always have been since I actually installed the blog and forum.

So I don’t think that’s it.

Conrad

YS Yellow Swordfish
Yellow Swordfish
Member

OK – good. It was your reference to UTC+1 above (post 16) that made me think that was what it was set to.

Are you able and would you be willing to take a look in the database for me? If possible I would like to know:

(1) – the sfmembers table – your entry – the user_options column. If you could copy and paste…

(2) – the WP options table – the option values for both ‘gmt_offset’ and ‘timezone_string’

That might help try and track this! Thanks

(My test settings here are currently the same – London and London – and I get correct times so I still need to try and track down the differences)

CF Conrad_Farlow
Conrad_Farlow
Member

My sfmembers ‘user_options’ entry:

a:7:{s:10:”hidestatus”;b:0;s:8:”timezone”;d:0;s:6:”editor”;i:1;s:8:”namesync”;b:1;s:7:”pmemail”;b:1;s:15:”timezone_string”;s:13:”Europe/London”;s:13:”pmdisplaysize”;s:1:”0″;}

WP options

‘gmt_offset’ has no value (i.e is empty)

‘timezone_string’ = Europe/London

YS Yellow Swordfish
Yellow Swordfish
Member

And there you have the problem:

“timezone”;d:0;s:6:

is set to 6 when it should be zero.

Thanks Conrad – this gives us something to work with and track down. Appreciate it.

CF Conrad_Farlow
Conrad_Farlow
Member

So what is setting it to 6? And what does that 6 mean? Should I manually alter it? I also meant to ask whether this could be affecting the new/recently updated topics and X Topic with unread posts because that is all over the place, or should that be another thread?

Conrad

CF Conrad_Farlow
Conrad_Farlow
Member

I get it, it is +6 hours which explains what Lee has observed.

YS Yellow Swordfish
Yellow Swordfish
Member

You got it. I have opened a ticket as the problem looks to be the way we are interpreting the setting somehow. Odd that t works just fine for me however…

CF Conrad_Farlow
Conrad_Farlow
Member

I did an SVN up and thought that the problem had gone away as all posts were reported in hours and seemed about right but alas I was mistaken

Any joy with this?

Conrad

YS Yellow Swordfish
Yellow Swordfish
Member

Not yet. It’s on the list.
Do you have access to look at the bug list?

MP Mr Papa
Mr Papa
Member

link in the top… information menu item…

CF Conrad_Farlow
Conrad_Farlow
Member

I have just done an svn up 6846.

I was required to upgrade which I duly did.

It then asked if I wanted to make the database format compatible with V5, I figured it probably doesn’t check so what the hell.

I mention this because…………

My time display is now correct and there is no – seconds displayed any more. So well done if it was you and how strange otherwise.

YS Yellow Swordfish
Yellow Swordfish
Member

Yes – finally managed to track down the issues with the timezones this evening. The profile overview of your timezone should also now be correct – although you being UK with a uk based server you probably didn’t notice that issue!

And Lee was half right as well although that wasn’t quite the full story.