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 <andyha...@gmail.com> wrote:
> Should have looked more carefully, its clearly the second...
>
> On Tue, Aug 10, 2010 at 11:17 AM, Andrew Buchan <andyha...@gmail.com> 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;
>
> > On Tue, Aug 10, 2010 at 10:22 AM, mdipierro <mdipie...@cs.depaul.edu>wrote:
>
> >> Can you determine somehow the sql statement that mssql is complaining
> >> about?
>
> >> On Aug 10, 3:03 am, Andrew Buchan <andyha...@gmail.com> 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 recent call last):
> >> > File "C:\Program Files\Hub Pages\web2py\gluon\restricted.py", line
> >> > 178, in restricted
> >> > exec ccode in environment
> >> > File "C:/Program Files/Hub Pages/web2py/applications/HubFormsDevTest/
> >> > controllers/default.py", line 65, in <module>
> >> > File "C:\Program Files\Hub Pages\web2py\gluon\globals.py", line 96,
> >> > in <lambda>
> >> > self._caller = lambda f: f()
> >> > File "C:/Program Files/Hub Pages/web2py/applications/HubFormsDevTest/
> >> > controllers/default.py", line 44, in user
> >> > return dict(form=auth())
> >> > File "C:\Program Files\Hub Pages\web2py\gluon\tools.py", line 988,
> >> > in __call__
> >> > return self.request_reset_password()
> >> > File "C:\Program Files\Hub Pages\web2py\gluon\tools.py", line 1927,
> >> > in request_reset_password
> >> > user.update_record(reset_password_key=reset_password_key)
> >> > File "C:\Program Files\Hub Pages\web2py\gluon\sql.py", line 3245, in
> >> > <lambda>
> >> > colset.update_record = lambda _ = (colset, table, id), **a:
> >> > update_record(_, a)
> >> > File "C:\Program Files\Hub Pages\web2py\gluon\sql.py", line 3375, in
> >> > update_record
> >> > table._db(table.id==id).update(**c)
> >> > File "C:\Program Files\Hub Pages\web2py\gluon\sql.py", line 3330, in
> >> > update
> >> > self._db._execute(query)
> >> > File "C:\Program Files\Hub Pages\web2py\gluon\sql.py", line 1039, in
> >> > <lambda>
> >> > self._execute = lambda *a, **b: self._cursor.execute(*a, **b)
> >> > ProgrammingError: ('42000', "[42000] [Microsoft][ODBC SQL Server
> >> > Driver][SQL Server]Incorrect syntax near the keyword 'WHERE'. (156)
> >> > (SQLExecDirectW)")
>
> >> > However, the email does send, and I get the following link in it:
>
> >> > http://MyFatWindowsServer/HubFormsDevTest/default/user/reset_password.
> >> ..
>
> >> > When I click on that link, the flash message says: "Invalid reset
> >> > password".
>
> >> > I'm using version 1.81.5 on a Windows server with MS SQL Server 2005.
