I snipped a lot of the intermediate stuff out but basically I try to
use the lost_password link on the login page and get the following
traceback. Looking at the sql statement it appears that the parameters
for SET are missing.
from below: Function argument list: (*a=('UPDATE auth_user SET WHERE
auth_user.id=806;',), **b={})
I have a custom auth_user table in that I added some fields.
Other data: I can set a new password by using change_password after
logging in.
Let me know what kind of additional information might help.
Pieces of the traceback information.
***************************************************************
web2py Version 1.89.5 (2010-11-21 22:12:54)
Error traceback:
Traceback (most recent call last):
File "gluon/restricted.py", line 188, in restricted
File "E:/web2py/applications/psc/controllers/default.py", line 55,
in <module>
File "gluon/globals.py", line 96, in <lambda>
File "E:/web2py/applications/psc/controllers/default.py", line 34,
in user
File "gluon/tools.py", line 1038, in __call__
File "gluon/tools.py", line 1998, in request_reset_password
File "gluon/sql.py", line 3416, in <lambda>
File "gluon/sql.py", line 3551, in update_record
File "gluon/sql.py", line 3506, in update
File "gluon/sql.py", line 965, in <lambda>
OperationalError: near "WHERE": syntax error
Error snapshot
Detailed traceback description
* Exception: <class 'sqlite3.OperationalError'>(near "WHERE":
syntax error)
* Python 2.5.4: E:\web2py\web2py.exe
File E:\web2py\gluon\sql.py in <lambda> at line 965
[ code | arguments | variables ]
Function argument list: (*a=('UPDATE auth_user SET WHERE
auth_user.id=806;',), **b={})