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={})

Reply via email to