Author Topic: Timezones inaccurate  (Read 2489 times)

Don

  • Freshman
  • *
  • Posts: 36
    • ICQ Messenger - 41785409
    • View Profile
    • Email
Timezones inaccurate
« on: 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)

ignacio

  • Hero Member
  • *****
  • Posts: 1703
    • View Profile
Re: Timezones inaccurate
« Reply #1 on: 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:

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

  • Freshman
  • *
  • Posts: 36
    • ICQ Messenger - 41785409
    • View Profile
    • Email
Re: Timezones inaccurate
« Reply #2 on: January 12, 2009, 07:33:10 pm »
That worked fine - thanks.

 

anything