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.
