aC forum: Timezone keeps resetting in user profile? (Fix)

Post #4 by Ilija Studen

Ilija Studen — Tue, 13 Feb 2007 02:27:24 CST

He posted it here and I moved it to FAQ.

Post #3 by Ryan Cross

Ryan Cross — Tue, 13 Feb 2007 01:22:02 CST

you posted this under the FAQ section. but thanks again ;)

Post #2 by adamld

adamld — Mon, 12 Feb 2007 17:48:54 CST

Also note that your database is usually prefixed, so the tables are actually ac_timezone and ac_companies

Cheers,

Adam

Post #1 by adamld

adamld — Mon, 12 Feb 2007 17:48:17 CST

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);