Having user registration/profile problems?

[psoTFX]

It seems some (but not all?) users who have upgraded to phpBB 2.0.0 from phpBB 1.4.x are having problems with user registration or profile changes.

The problem seems to be a missing field in the users table, user_timezone. We'll try and track down this problem as soon as possible but for that time being anyone affected by this can run the following statement (using phpMyAdmin, the mysql command line application, etc.):

Code: Select all

ALTER TABLE phpbb_users ADD COLUMN user_timezone float DEFAULT '0' NOT NULL

Of course if you chose a different prefix than phpbb_ during upgrade you should alter the above statement appropriately.