I found the problem. I think someone broke backward compatibility. A
new field was added to auth_user after I started the project. I think
the field was added to improve the security of the reset password
process so that's a good thing. Why this broken compatibility wasn't
disclosed and explained is a mystery. I discovered it by creating a
new project with the latest code and comparing the auth_user table to
what I had.
Anyway, for anyone experiencing this issue you need to add a field to
auth_user:
Field('reset_password_key', length=512, default='', writable=False,
readable=False)
On Dec 14, 9:02 am, DenesL denes1...@yahoo.ca wrote:
As you suspect, the error is caused by the missing arguments **b, but
it is hard to tell why without seeing your code.
On Dec 13, 5:58 pm, kevski corbett.ke...@gmail.com wrote:
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={})- Hide quoted text -
- Show quoted text -