Timezone keeps resetting in user profile? (Fix)
Page: 1
Recent posts in this topic
I thought I posted this yesterday but can't find it, here is the fix again:
_ONLY_ Do this if you know how to use MySQL and PhpMyAdmin. It could destroy your database.
Hemebond on Feb 4. 2007. 5:23 am said:#19
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);
_ONLY_ Do this if you know how to use MySQL and PhpMyAdmin. It could destroy your database.
Hemebond on Feb 4. 2007. 5:23 am said:#19
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);
Also note that your database is usually prefixed, so the tables are actually ac_timezone and ac_companies
Cheers,
Adam
Cheers,
Adam
Ilija Studen
on Feb 13. 2007. 8:27 am
He posted it here and I moved it to FAQ.
activeCollab team member
Topic is locked. If you have something important to say about issues discussed on this page please write at hi@a51dev.com.
