[web2py] Re: OperationalError: no such column

2016-06-13 Thread Dave S
On Monday, June 13, 2016 at 6:11:56 PM UTC-7, Marty Jones wrote: > > Resolved it - the line that was triggering the error: > > company = db.auth_user.company) > > should have been: > > company = auth.user.company) > > :P > > Glad you caught that, because I sure didn't. /dps > On Monday, June

[web2py] Re: OperationalError: no such column

2016-06-13 Thread Marty Jones
Resolved it - the line that was triggering the error: company = db.auth_user.company) should have been: company = auth.user.company) :P On Monday, June 13, 2016 at 9:03:39 PM UTC-4, Dave S wrote: > > > > On Monday, June 13, 2016 at 5:49:35 PM UTC-7, Marty Jones wrote: >> >> OK - I reverted to

[web2py] Re: OperationalError: no such column

2016-06-13 Thread Dave S
On Monday, June 13, 2016 at 5:49:35 PM UTC-7, Marty Jones wrote: > > OK - I reverted to auth.settings.extra_fields and expanded the code shown > below. The same error is persisting. > What do the entries in yourapp/databases/sql.log say about the table schema? /dps -- Resources: -

[web2py] Re: OperationalError: no such column

2016-06-13 Thread Marty Jones
OK - I reverted to auth.settings.extra_fields and expanded the code shown below. The same error is persisting. db.py # -*- coding: utf-8 -*- # ## This scaffolding model makes your app work on Google App Engine too ## File

[web2py] Re: OperationalError: no such column

2016-06-13 Thread Dave S
On Monday, June 13, 2016 at 1:57:38 PM UTC-7, Marty Jones wrote: > > Hi - > > I created a custom auth_user table with a new field ('company') and am > having trouble accessing it in my controller: > The book recommends using auth.settings.extra_fields

[web2py] Re: OperationalError 1054 Unknown column 'auth_user.reset_password_key' in 'field list'

2010-03-27 Thread mdipierro
You have set migrate=False or you have a custom auth.user table. But web2py 1.75.6 requires a new field in auth_user Field('reset_password_key', length=512, writable=False, readable=False, default='', label=auth,.messages.label_reset_password_key), You either create