Support Forum
It seems to only affect views using sp_nicedate()
sp_nicedate() uses: time() and calculates the difference in seconds between now and the post udate (UTC?), would his server timezone or the users timezone even matter? Correct me if I'm wrong, but doesn't time() use UTC by default unless a timezone is set by date_default_timezone_set()? Could another plugin be setting date_default_timezone_set() throwing everything off?
As close as I can figure, sp_nicedate() on Conrads server is returning -21600 seconds (exactly -6 hours)
There I go thinking too much. Tell me to go jump in a lake if needed.
what is the wp server time set to on wp - settings - options?
Visit Cruise Talk Central and Mr Papa's World
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.
YELLOW
SWORDFISH
|
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)
YELLOW
SWORDFISH
|