How to fix problems with timezones larger than -9.5, +9.5
Page: 1
Recent posts in this topic
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);
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);
Ilija Studen
on Feb 11. 2007. 11:05 pm
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.
activeCollab team member | LinkedIn
Topic is locked. If you have something important to say about issues discussed on this page please write at hi@a51dev.com.
