Yep, that was it. Thanks a bunch Massimo! On Tue, Aug 10, 2010 at 11:46 AM, mdipierro <[email protected]> wrote:
> 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 <[email protected]> wrote: > > Should have looked more carefully, its clearly the second... > > > > On Tue, Aug 10, 2010 at 11:17 AM, Andrew Buchan <[email protected]> > wrote: > > > Massimo, > > > > > it's either: > > > > > SELECT count(*) FROM auth_user WHERE auth_user.email=' > > > [email protected]'; > > > > > or > > > > > UPDATE auth_user SET WHERE auth_user.id=13; > > > > > On Tue, Aug 10, 2010 at 10:22 AM, mdipierro <[email protected] > >wrote: > > > > >> Can you determine somehow the sql statement that mssql is complaining > > >> about? > > > > >> On Aug 10, 3:03 am, Andrew Buchan <[email protected]> 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. >
