The problem is that update=auth.user.username
the right hand site is node defined if you are not logged in. Try: update=auth.user and auth.user.username On Oct 27, 4:50 pm, baloan <[email protected]> wrote: > I am trying to use versioning in an authenticated section of a > website. Instead of this: > > db.define_table('my_table', > Field('saved_by',auth.user, > default=auth.user_id,update=auth.user_id,writable=False) > > I was trying this: > > db.define_table('my_table', > Field('saved_by','string', > default=auth.user.username,update=auth.user.username, writable=False) > > Whenever I try to visit the website's home page (as an > unauthenticated user) web2py chokes on the table definition in models/ > db.py. See below for the traceback. > > Any idea how to solve this? > Maybe I should use a decorator with the define_table statement? > > Regards, Andreas > [email protected] > > ------------------------------------------------------------------------------ > > Error traceback > > 1. > 2. > 3. > 4. > 5. > 6. > 7. > > Traceback (most recent call last): > File "D:\Home\web\web2py\gluon\restricted.py", line 188, in > restricted > exec ccode in environment > File "D:/Home/web/web2py/applications/invest/models/db.py", line > 159, in <module> > Field('change_user', 'string', default=auth.user.username, > update=auth.user.username, writable=False), > AttributeError: 'NoneType' object has no attribute 'username' > > Error snapshot > Detailed traceback description > > * Exception: <type 'exceptions.AttributeError'>('NoneType' object > has no attribute 'username') > Exception instance attributes > o args: ("'NoneType' object has no attribute 'username'",) > o __setattr__: <method-wrapper '__setattr__' of > exceptions.AttributeError object> > o __reduce_ex__: <built-in method __reduce_ex__ of > exceptions.AttributeError object> > o __getslice__: <method-wrapper '__getslice__' of > exceptions.AttributeError object> > o __getitem__: <method-wrapper '__getitem__' of > exceptions.AttributeError object> > o __setstate__: <built-in method __setstate__ of > exceptions.AttributeError object> > o __getattribute__: <method-wrapper '__getattribute__' of > exceptions.AttributeError object> > o __str__: <method-wrapper '__str__' of > exceptions.AttributeError object> > o __format__: <built-in method __format__ of > exceptions.AttributeError object> > o __reduce__: <built-in method __reduce__ of > exceptions.AttributeError object> > o __class__: <type 'exceptions.AttributeError'> > o __dict__: {} > o __delattr__: <method-wrapper '__delattr__' of > exceptions.AttributeError object> > o __subclasshook__: <built-in method __subclasshook__ of > type object> > o __repr__: <method-wrapper '__repr__' of > exceptions.AttributeError object> > o __init__: <method-wrapper '__init__' of > exceptions.AttributeError object> > o __hash__: <method-wrapper '__hash__' of > exceptions.AttributeError object> > o __sizeof__: <built-in method __sizeof__ of > exceptions.AttributeError object> > o __doc__: 'Attribute not found.' > o __unicode__: <built-in method __unicode__ of > exceptions.AttributeError object> > o __new__: <built-in method __new__ of type object> > * Python 2.6.5: C:\Program Files\Apache2.2\bin\httpd.exe > > File D:\Home\web\web2py\gluon\restricted.py in restricted at line 188 > [ code | arguments | variables ] > Function argument list: (code='# coding: utf8\n\nimport datetime as dt > \n\n#########...ail),\n db.email)\n \n', environment={'A': <class > 'gluon.html.A'>, 'Auth': <class 'gluon.tools.Auth'>, 'B': <class > 'gluon.html.B'>, 'BEAUTIFY': <class 'gluon.html.BEAUTIFY'>, 'BODY': > <class 'gluon.html.BODY'>, 'BR': <class 'gluon.html.BR'>, 'CENTER': > <class 'gluon.html.CENTER'>, 'CLEANUP': <class > 'gluon.validators.CLEANUP'>, 'CODE': <class 'gluon.html.CODE'>, > 'CRYPT': <class 'gluon.validators.CRYPT'>, ...}, layer=r'D:\Home\web > \web2py\applications\invest/models/db.py') > > 183. > 184. > 185. > 186. > 187. > 188. > > 189. > 190. > 191. > 192. > > if type(code) == types.CodeType: > ccode = code > else: > ccode = compile2(code,layer) > > exec ccode in environment > > except HTTP: > raise > except Exception: > # XXX Show exception in Wing IDE if running in debugger > > * environment: {'A': <class 'gluon.html.A'>, 'Auth': <class > 'gluon.tools.Auth'>, 'B': <class 'gluon.html.B'>, 'BEAUTIFY': <class > 'gluon.html.BEAUTIFY'>, 'BODY': <class 'gluon.html.BODY'>, 'BR': > <class 'gluon.html.BR'>, 'CENTER': <class 'gluon.html.CENTER'>, > 'CLEANUP': <class 'gluon.validators.CLEANUP'>, 'CODE': <class > 'gluon.html.CODE'>, 'CRYPT': <class 'gluon.validators.CRYPT'>, ...} > * ccode: <code object <module> at 03DB9BA8, file "D:\Home...web2py > \applications\invest/models/db.py", line 3> > > File D:\Home\web\web2py\applications\invest\models\db.py in <module> > at line 159 > [ code | arguments | variables ] > Function argument list: () > > 154. > 155. > 156. > 157. > 158. > 159. > > 160. > 161. > 162. > 163. > > db.define_table('email', > Field('email', 'string', length=40, notnull=False, > unique=True, represent=lambda s: s), > Field('active', 'boolean', default=True), > Field('expires', 'date', default=None, > represent=lambda s: s or 'Never'), > Field('change_user', 'string', default=auth.user.username, > update=auth.user.username, writable=False), > > Field('change_date', 'datetime', default=request.now, > update=request.now, writable=False), > ) > > db.define_table('email_archive', > > * default: undefined > * Field: <class 'gluon.sql.Field'> > * auth.username: undefined > * auth: <gluon.tools.Auth object>
