I don't know when this started but I have a number of these entries in Recent Log Entries.

Unknown column 'timezone_id' in 'where clause' query: UPDATE xxx_pfshared.users SET timezone_id = 304 WHERE timezone = -39600 AND timezone_id = 0 in /home/xxx/public_html/pressflow-6.15.73/sites/all/modules/event/event.module  on line 276.

It looks like an error occurs when a users saves his profile with or without updating.

I checked the table users and there is no column timezone_id. When was this column supposed to be created. I can see a number of entries in the timezone column of 228|-180.

Not sure where to start looking.

Comments

waverate’s picture

waverate commented

Any ideas?

killes@www.drop.org’s picture

killes@www.drop.org commented

The column should have been created when you installed event.module.

waverate’s picture

waverate commented

Killes,

Thanks for the reply. Is there a way to fix this by reinstalling without losing my existing events?

killes@www.drop.org’s picture

killes@www.drop.org commented

You should simply create that column manually.

waverate’s picture

waverate commented

SOLVED

Thanks Killes. That was it.

From mysql, select the correct database and issue:

ALTER TABLE users ADD timezone_id int NOT NULL default '0'
pfrenssen’s picture

pfrenssen
Location Sofia
commented
Status: Active » Fixed

changing status

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.