Wrong time in sugarCRM

[Rkhamas]

Hi everyone,

I am currently setting up SugarCRM at work, everything seems to go ok however the time value is one hour behind, its 11:07am right now however in sugar when I added an activity it said "added on 10:07am" or so.

can anyone help?

regards,

[Angel]

Verify that your time zone is set correctly within Sugar by clicking the "My Account" link in the upper right section.

[Rkhamas]

hi, thanks for the reply
the time zone is correct, GMT+10 Sydney, is there anything else i can do?

[Angel]

Make sure that the time is set correctly on the server as well.

[Rkhamas]

hi,
the time is correct on the server
thanks

[clint]

It turns out this is an issue we are preparing a patch for now. I'm not sure if the timing for daylight savings has changed for Australia or what, but we are going to change the daylight savings definition for all of the Australia timezones in the next patch.

The file that will be patched is: include/timezone/timezones.php

Here is a sample change that will be made. This is just for Melbourne. There are multiple other entries in this file for other Australian cities.

Old:
'Australia/Melbourne' =>
array (
'gmtOffset' => 600,
'dstOffset' => 60,
'dstMonth' => 10,
'dstStartday' => -1,
'dstWeekday' => 0,
'stdMonth' => 3,
'stdStartday' => -1,
'stdWeekday' => 0,
'dstStartTimeSec' => 7200,
'stdStartTimeSec' => 7200,
),

New:
'Australia/Melbourne' =>
array (
'gmtOffset' => 600,
'dstOffset' => 60,
'dstMonth' => 10,
'dstStartday' => 1,
'dstWeekday' => 0,
'stdMonth' => 4,
'stdStartday' => 1,
'stdWeekday' => 0,
'dstStartTimeSec' => 7200,
'stdStartTimeSec' => 7200,
),

[rodsingleton]

Thanks for the new timezone patch, I've been looking for this one.

[thowden]

The patch needs to address the following changes to Daylight Saving Time in Australia. I have this in SugarCRM 5.2.0g

Perth WA is no longer using DST and can have all DST settings removed. Their standard offset is 480.

Adelaide, Broken Hill, Sydney, Melbourne, Hobart & Currie are the others that need to be changed to reflect the newly agreed consistent use of DST. The main change is that we have started earlier than previously on the first weekend in October rather than the last and for reverting next year we are now a week later on the first weekend in April rather than the last weekend of March.

Change all the capitals in the timezones.php file as per this example for Australia. Noting that Perth, Darwin, Brisbane(& Lindeman) do not use DST settings.

   'Australia/Adelaide' => 
  array (
    'gmtOffset' => 570,
    'dstOffset' => 60,
    'dstMonth' => 10,
    'dstStartday' => -1,     <---  change this to 1 (not negative)
    'dstWeekday' => 0,
    'stdMonth' => 3,                  <---  change this to 4
    'stdStartday' => -1,              <--- change this to 1 (not negative)
    'stdWeekday' => 0,
    'dstStartTimeSec' => 7200,
    'stdStartTimeSec' => 7200,
  ), 
  

[matthew]

A hot fix for Australian Daylight Savings Time has been posted here:

http://www.sugarcrm.com/forums/showt...456#post188456

[Kupo]

Very nice. applying the patch now

Thanks!