Re: [web2py] Re: Error on default "Lost password" function

2010-08-10 Thread Andrew Buchan
Yep, that was it. Thanks a bunch Massimo! On Tue, Aug 10, 2010 at 11:46 AM, mdipierro wrote: > Your auth_user table is missing the reset_password_key field. > If you use auth.define_tables(migrate=False), set migrate=True. If you > use a custom field, add a hidden string field 'reset_password_ke

[web2py] Re: Error on default "Lost password" function

2010-08-10 Thread mdipierro
Your auth_user table is missing the reset_password_key field. If you use auth.define_tables(migrate=False), set migrate=True. If you use a custom field, add a hidden string field 'reset_password_key' On Aug 10, 5:18 am, Andrew Buchan wrote: > Should have looked more carefully, its clearly the sec

Re: [web2py] Re: Error on default "Lost password" function

2010-08-10 Thread Andrew Buchan
Should have looked more carefully, its clearly the second... On Tue, Aug 10, 2010 at 11:17 AM, Andrew Buchan wrote: > Massimo, > > it's either: > > SELECT count(*) FROM auth_user WHERE auth_user.email=' > avalidemailaddr...@mycompany.co.uk'; > > or > > UPDATE auth_user SET WHERE auth_user.id=13

Re: [web2py] Re: Error on default "Lost password" function

2010-08-10 Thread Andrew Buchan
Massimo, it's either: SELECT count(*) FROM auth_user WHERE auth_user.email=' avalidemailaddr...@mycompany.co.uk'; or UPDATE auth_user SET WHERE auth_user.id=13; On Tue, Aug 10, 2010 at 10:22 AM, mdipierro wrote: > Can you determine somehow the sql statement that mssql is complaining > abo

[web2py] Re: Error on default "Lost password" function

2010-08-10 Thread mdipierro
Can you determine somehow the sql statement that mssql is complaining about? On Aug 10, 3:03 am, Andrew Buchan wrote: > Hi, > > When I click on the default "Lost password" link, I get to the page > which prompts for an email address, submit, then get the following > error: > > Traceback (most rec