[web2py] MySQL migration fails adding unique

2012-07-05 Thread MichaelF
I have a working app using web2py `(1, 99, 7, datetime.datetime(2012, 3, 4, 22, 12, 8), 'stable'); Python 2.5.4: C:\Program Files (x86)\web2py\web2py_no_console.exe`) and MySQL 5.5. If I change one field to add `unique=True` the web2py migration fails with this error: `" 'institution_name'"` whe

[web2py] MySQL migration fails adding unique=

2012-07-05 Thread MichaelF
I have a working app using web2py `(1, 99, 7, datetime.datetime(2012, 3, 4, 22, 12, 8), 'stable'); Python 2.5.4: C:\Program Files (x86)\web2py\web2py_no_console.exe`) and MySQL 5.5. If I change one field to add `unique=True` the web2py migration fails with this error: `" 'institution_name'"` whe