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 web...@googlegroups.com.
To unsubscribe from this group, send email to
web2py+unsubscr...@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/web2py?hl=en.
