auth_table = db.define_table(
auth.settings.table_user_name,
Field('first_name', length=128, default=''),
Field('last_name', length=128, default=''),
Field('username', length=128, default=''),
Field('email', length=128, default='', unique=True),
Field('password', 'password', length=256, readable=False,
label='Password', requires=CRYPT()),
Field('picture','upload'),
Field('thumb','upload',writable=False,readable=False),
Field('registration_key', length=128, default= '', writable=False,
readable=False)
)
auth_table.username.requires = IS_NOT_IN_DB(db, auth_table.username)
auth_table.first_name.requires = \
IS_NOT_EMPTY(error_message=auth.messages.is_empty)
auth_table.last_name.requires = \
IS_NOT_EMPTY(error_message=auth.messages.is_empty)
auth_table.password.requires = [CRYPT()]
auth_table.email.requires = [
IS_EMAIL(error_message=auth.messages.invalid_email),
IS_NOT_IN_DB(db, auth_table.email)]
auth.settings.table_user = auth_table
and
auth.define_tables(migrate=True)
On Aug 25, 2:58 pm, mdipierro <mdipie...@cs.depaul.edu> wrote:
> 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?
