Re: [web2py] How do I avoid this error?

Did you check if there is record with empty username? If you try to add not null over a column/table that is not empty it may happen that some record(s) don't respect the new rule so your constraint can't be apply... You need to first update your records make sure none are empty than try again the

[web2py] How do I avoid this error?

adding the field: Field('username', requires=IS_NOT_EMPTY(), unique=True) gives me the following error: Cannot add a UNIQUE column How to avoid this error? -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://