Sugar Dates in DB off GMT by 35 minutes

[danny_mulvihill]

Hello and thanks for any insight into this!

I am working on an installation of Sugar and have uncovered a very bizarre issue. Datetimes are being stored in the MySQL database 35 minutes after GMT.

The server is set to UTC and synced with NTP.

All three of these output the correct UTC time, but when I edit a record and then check the date_modified moments later (via the api) it is off by exactly 35 minutes.

1. $ date -u

2. mysql> select UTC_TIMESTAMP();

3. make a file named time.php, put this code into it and then execute it: $ php time.php

 <?php
     date_default_timezone_set('UTC');
     echo date('G:i:s');
?>  

It seems that API retrieves the exact date in the database without doing any timezone transformations. Is that true?

The weirdest part is that the result is off by 35 minutes. If it was a factor of an hour, or even 15 minute interval I could assume it was a timezone issue, but this seems like Sugar is adding 35 minutes to GMT.

What method does Sugar use to get the GMT time? Does it use a php method? Any ideas where to look next for tracking this down?

Thank you so much for any help with this.

[danny_mulvihill]

I just came across the get_server_info() method available in the API and am getting the same results:

Array
(
    [flavor] => PRO
    [version] => 6.1.0
    [gmt_time] => 2011-02-28 18:33:43
)

But GMT is 17:58:43.

Any ideas out there?

[Joe9898]

hey guys!
where can I find the implementation of get_server_info() method available in the API that returns server information such as version, flavor, and gmt_time.

thanks

[danny_mulvihill]

The first place you can get some info is by going here in a browser:
http://localhost/service/v3_1/rest.php
(Assuming you're working locally.)

The actual files are here:
<sugar root>/service/core/REST/*

There is some more info about it here: (the link is anchored to the right spot btw :-)
Developer's Guide
If that link doesn't work, just click it again. It should since you already have a session with Sugar though)

If you need some help getting started with the API check this out:
Being RESTful with SugarCRM

I hope this helps you out.

Now does anyone have some advice on my 35 minutes off issue? :-)