odd. On Dec 16, 11:37 am, David <[email protected]> wrote: > I was just working with custom auth and adding a username and details > for the app I am working on today. I was following in the tutorial in > the book (page 229) on version 1.72.3 with sqlite. > > When I added > > Field('username', length=32, default='', unique=True), > > I get error: > > Traceback (most recent call last): > File "gluon/restricted.py", line 184, in restricted > File "/Users/davinci/Downloads/web2py 2/web2py.app/Contents/ > Resources/applications/app/models/db.py", line 44, in <module> > File "gluon/sql.py", line 1205, in define_table > File "gluon/sql.py", line 1647, in _create > File "gluon/sql.py", line 1701, in _migrate > File "gluon/sql.py", line 846, in <lambda> > OperationalError: Cannot add a UNIQUE column > > I removed the unique=True from the field and was able to generate the > custom auth table. > > Then I went back in and added unique=True to that line and it seems to > work. > > If this was already noticed then please disregard. > > - David
-- You received this message because you are subscribed to the Google Groups "web2py-users" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/web2py?hl=en.

