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.


Reply via email to