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.
