aC forum: How to fix problems with timezones larger than -9.5, +9.5 http://www.activecollab.com/forums/topic/1388/ Recent posts on topic: How to fix problems with timezones larger than -9.5, +9.5 en-us Thu, 16 Oct 2008 04:27:16 UTC http://www.activecollab.com/forums/post/6575/#post6575 http://www.activecollab.com/forums/post/6575/#post6575 Post #4 by Ryan Cross Ryan Cross Sorry - thanks for fixing it! =)

]]> Mon, 12 Feb 2007 05:34:29 UTC http://www.activecollab.com/forums/post/6573/#post6573 http://www.activecollab.com/forums/post/6573/#post6573 Post #3 by Ilija Studen Ilija Studen
Ryan Cross:
Isn't this a bug that should be filed with the developer?


I'm aware of the problem. It will be fixed. Until then this is a working solution.

]]> Mon, 12 Feb 2007 05:05:54 UTC http://www.activecollab.com/forums/post/6571/#post6571 http://www.activecollab.com/forums/post/6571/#post6571 Post #2 by Ryan Cross Ryan Cross Isn't this a bug that should be filed with the developer?

]]> Mon, 12 Feb 2007 04:38:51 UTC http://www.activecollab.com/forums/post/6565/#post6565 http://www.activecollab.com/forums/post/6565/#post6565 Post #1 by adamld adamld If you have a problem where you cannot set your timezone correctly (Anything above +9.5 hours does not stick) then use the below suggestion from Hemebond.

The problem is with the database. The "timezone" column in the "companies" table is set to FLOAT(2,1). This is too small. It needs to be FLOAT(3,1).

ALTER TABLE companies MODIFY timezone FLOAT(3,1);

You'll also need to alter the users table.

ALTER TABLE users MODIFY timezone FLOAT(3,1);

]]> Mon, 12 Feb 2007 00:49:39 UTC