Should have looked more carefully, its clearly the second...
On Tue, Aug 10, 2010 at 11:17 AM, Andrew Buchan <andyha...@gmail.com> wrote:
> Massimo,
>
> it's either:
>
> SELECT count(*) FROM auth_user WHERE auth_user.email='
> avalidemailaddr...@mycompany.co.uk';
>
> or
>
> UPDATE auth_user SET WHERE auth_user.id=13;
>
>
>
> On Tue, Aug 10, 2010 at 10:22 AM, mdipierro <mdipie...@cs.depaul.edu>wrote:
>
>> Can you determine somehow the sql statement that mssql is complaining
>> about?
>>
>> On Aug 10, 3:03 am, Andrew Buchan <andyha...@gmail.com> 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.
>
>
>
