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/1281427075-30d47af6-5608-4dc7-9478-92eb7ac08b3b
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.
