Timezones inaccurate

[Don]

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)

[ignacio]

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:

Code: [Select]

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.

[Don]

That worked fine - thanks.