Feng Forum

Support => Older versions => Feng Office 1 => : Don January 12, 2009, 07:06:28 AM

: Timezones inaccurate
: Don January 12, 2009, 07:06:28 AM

Hi - setting the timezone for a country is a bit erratic. Any time zone over GMT +9 gets set to GMT -12.

In the database, the timezone gets set to 9 for GMT +9, and 9.9 for GMT +12 (or/and GMT -12 - which is how it is displayed)

: Re: Timezones inaccurate
: ignacio January 12, 2009, 01:14:14 PM

Hi Don, you're right. There's an error in the type definition of the timezone column. You can fix it by running this SQL in your database:

:

ALTER TABLE `og_contacts` MODIFY COLUMN `timezone` float(3,1) NOT NULL default '0.0';
ALTER TABLE `og_companies` MODIFY COLUMN `timezone` float(3,1) NOT NULL default '0.0';
ALTER TABLE `og_users` MODIFY COLUMN `timezone` float(3,1) NOT NULL default '0.0';
Note that you may need to change the prefix 'og_' if you chose another one for your installation.

This will be fixed in version 1.2.

Thanks.

: Re: Timezones inaccurate
: Don January 12, 2009, 07:33:10 PM

That worked fine - thanks.