user warning: Unknown column 'timezone_name' in 'field list'

Same here, any updates on this?

Me too. No column in the db. Will try turning timezone support on and off again after a little more grant permission given.

Did an uninstall and reinstall, placed the column :)

However still curious about why Date API chooses to place a timezone_name field in the user table.
Shouldn't that just be a foreign ID key, like the already existing timezone field? Why would the architecture call for a string, seems wasteful and bad normalization.
Am I missing something?

Sorry for cross posting this question in two threads.

Hi same here !
I temporaly solved the problem setting off the User-configurable time zones, but it's not a long term solution.
I didn't try more and neither to read date_timezone module code.

There is an update hook that creates that field. If you didn't run the update the table will be missing the field. You can disable and uninstall and then re-install the module if you don't need to preserve any data, or run update.php to be sure all the updates have run. If you still don't have the field, you can add it manually.

Follow up: believe D7 has new architecture for user timezones.
D6 had both a timezone column (in seconds) and a timezone_name as a string.
D7 now have just the timezone column, but it's the string.