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?
--
