If you have auth.define_tables(migrate=False), try change it to true
If you use a custom auth_user table, please post it.
On Aug 25, 7:10 am, Francisco Costa <m...@franciscocosta.com> wrote:
> I have this function in the default controller
>
> def retrieve_password():
> return dict(form=auth.retrieve_password())
>
> and I have this view default/retrieve_password.html
>
> {{response.title=T('Retrieve Password')}}
> {{extend 'layout.html'}}
> {{app=request.application}}
> {{=form}}
>
> When I click submit this error happens: ProgrammingError: (1064, "You
> have an error in your SQL syntax; check the manual that corresponds to
> your MySQL server version for the right syntax to use near 'WHERE
> auth_user.id=1' at line 1")
>
> But the email is sent. When i click on the email link I get a flash
> message with 'Invalid reset password'
>
> Any help?
