Please try 2.3.1. If the problem persists open a ticket.
On Thursday, 13 December 2012 15:06:48 UTC-6, Florian Letsch wrote:
>
> I have a few additional fields set on my db_auth table, mainly in order to
> implement a simple invite system:
>
> auth.settings.extra_fields['auth_user']= [ Field('invite_sent', 'datetime'
> , default=None), # None for activated users
> Field('invite_key')]
>
> When the invite has been accepted, I want to set both field to None. This
> works for db.auth_user.invite_sent but not for the second field. I try the
> following in the web2py python shell:
> >>> db(db.auth_user.id==123).validate_and_update(invite_key=None)
>
> <Row {'updated': None, 'errors': <Row {'invite_key': 'enter from 0 to 255
> characters'}>}>
>
> I tried to check for the field's attributes, but this looks alright to me:
> >>> repr(db.auth_user.invite_key.default)
> 'None'
> >>> db.auth_user.invite_key.notnull
> False
>
> Setting to a zero length string works, but that's not what I want. Also, I
> can set it to NULL in SQL, so the underlying DB scheme seems to be okay.
> I am running web2py Version 1.99.7 on Python 2.7.3 right now.
>
> What am I missing, why can I not set the field to be None?
>
--
