Local Time setting for Forum, Calendar and "Link Event"

[Rumbaar]

Yeah, never got a response when it was asked in the appropriate private section in regards to the 1.1.x stream of SMF.  So I'm unable to give a definitive answer.  Other than it appears to be not an issue in 2.x.

[kripz]

Unless im doing something wrong, this bug is still here in 1.1.10.

[Gavin Chatt]

Yep same here, just noticed it, see following post I placed in another thread on the same subject:

http://www.simplemachines.org/community/index.php?topic=329975.msg2238226#msg2238226

[JimM]

Yes this is a known bug and is on the bugtracker.

http://dev.simplemachines.org/mantis/view.php?id=3699

[MrPhil]

Something I haven't seen mentioned yet -- apparently MySQL doesn't pay any attention to PHP timezone settings. Supposedly, "now()" in SQL queries always returns or inserts the server's local time, rather than whatever timezone you set PHP to use. That might have some bearing on the problem if now() is involved and compared against some time in PHP. You would think that the timestamp stored in the database would be UTC (Unix epoch seconds count), but possibly it's having some offset added to correct to the server's timezone and DST rules?

Can anyone confirm this behavior of now()? I haven't looked through the code in detail, but I'm thinking that it might explain some of the really odd calendar-related behaviors seen here. If so, the solution may be to not use timedate fields, but to store PHP's time() value (UTC) as an integer (32 or 64 bit), and do formatting manually in PHP code. In calendar functions, you would take care to always compare raw timestamps (time() values) against each other, not time() vs now().

Anyway, worth pondering, if we're still looking for a solution...

[JimM]

Yes this is a known bug and is on the bugtracker.

http://dev.simplemachines.org/mantis/view.php?id=3699