2938: Long timezone values in Account Preferences cause an unexpected error

pablo******@gmai***** (Google Code) (Is this you? Claim this profile.)
Aug. 7, 2013
What version are you running?
1.7.6

What's the URL of the page containing the problem?
Any place where a timezone is set, such as: 
/account/preferences/

What steps will reproduce the problem?
1. Access the account preferences page
2. Attempt to set the timezone to one of the longer names, such as: America/Argentina/Buenos_Aires

What is the expected output? What do you see instead?
Timezone should be set accordingly. Instead, an error (500) occurs.

What operating system are you using? What browser?
Windows 2008, backend database on MySQL 5.5.29

The error seems to be caused by the length of the accounts_profile.timezone field, which is only varchar(20), so "America/Argentina/Buenos_Aires" exceeds the 20 characters.
#1 pablo******@gmai***** (Google Code) (Is this you? Claim this profile.)
The actual error is the following:

DatabaseError: (1406, "Data too long for column 'timezone' at row 1")
david
#2 david
This was fixed at http://reviews.reviewboard.org/r/4230/
  • +Fixed