SuiteCRM shows current time but DB shows GMT timestamp

šŸ’¬ General Discussion
1

Hi,

When I create a task (or any record for that matter) the date time stamp in my DB is defaulted to GMT while SuiteCRM shows me the correct values.

This is causing an issue for my work flows that trigger on the date condition.

I have checked my php & DB time zones and they are both set correctly to +03:00.

I have also placed ā€˜timezoneā€™ => ā€˜Africa/Nairobiā€™, in my config.php & $sugar_config[ā€˜timezoneā€™] = ā€˜Africa/Nairobiā€™; in my config_override.php file.

Any more suggestions of where else I should be looking?

Many thanks,

Saagar

2

Hi Saagar,

Set the log level in SuiteCRM to DEBUG and create a project. Have a look in sugarcrm.log for the insert statement to see what format the dates are in.

Also, if you change php.ini you might have to restart apache to have the settings take effect, depending on whether you are using fastcgi or not.

Cheers

Bruce

1 Like
3

Hi Bruce,

While in DEBUG mode, the dates and times are in the GMT time zone. I have attached the log for your reference.

Secondly, I had restarted Apache after the php.ini change. I noted this worked as sugarcrm.log used to log in GMT but now it is logging the correct times against each entry.

4

Hi Saagar,

All dates are stored in the CRM database as GMT values. Those date values are converted to the ā€œlocalā€ time zone for each user based on their preference. That preference is usually set on first login but can also be accessed/modified later on the ā€œAdvancedā€ tab of their user profile.

The same should be true of the workflow date triggers. They should be converted from your local time and saved as GMT so that any comparison would work correctly. This is what needs to be confirmed.

Cheers

Bruce