It's on the Registration Id field. This field is blank.
I removed all requires. Good news is that I can now update the
record. Bad news is that I still can't log into the application.
I'm now getting 'Invalid Login' when I try to login after verifying
the registration. Grr..
On Jan 4, 11:29 am, Anthony <abasta...@gmail.com> wrote:
> When an error occurs with a form submission, the form should be
> re-displayed with an error message attached to the field that caused the
> error. Where is the error being displayed? I notice you have
> db.auth_user.registration_id.requires = IS_NOT_IN_DB(...). If the
> registration_id field is left empty, that would cause the error in
> question. Note, I don't think you need that validator for the
> registration_id field (it is not included in the standard auth_user table
> definition in Auth). Try removing that line.
>
> Anthony
>
>
>
>
>
>
>
> On Wednesday, January 4, 2012 11:13:53 AM UTC-5, OpenMercury wrote:
>
> > I get it on any field. As soon as I hit submit, I get that error and
> > no updating takes place.
> > Here is my model db.py:
>
> > from gluon.tools import Auth, Crud, Service, PluginManager, prettydate
> > auth = Auth(db, hmac_key=Auth.get_or_create_key())
> > crud, service, plugins = Crud(db), Service(), PluginManager()
>
> > ## create all tables needed by auth if not custom tables
>
> > ########################################
> > db.define_table('auth_user',
> > Field('username', type='string',
> > label=T('Username')),
> > Field('first_name', type='string',
> > label=T('First Name')),
> > Field('last_name', type='string',
> > label=T('Last Name')),
> > Field('email', type='string',
> > label=T('Email')),
> > Field('password', type='password',
> > readable=False,
> > label=T('Password')),
> > Field('created_on','datetime',default=request.now,
> > label=T('Created On'),writable=False,readable=False),
> > Field('modified_on','datetime',default=request.now,
> > label=T('Modified On'),writable=False,readable=False,
> > update=request.now),
> > Field('registration_key',default='',
> > writable=True,readable=False),
> > Field('reset_password_key',default='',
> > writable=False,readable=False),
> > Field('registration_id',default='',
> > writable=False,readable=False),
> > format='%(username)s',
> > migrate=settings.migrate)
>
> > db.auth_user.first_name.requires =
> > IS_NOT_EMPTY(error_message=auth.messages.is_empty)
> > db.auth_user.last_name.requires =
> > IS_NOT_EMPTY(error_message=auth.messages.is_empty)
> > db.auth_user.password.requires = CRYPT(key=auth.settings.hmac_key)
> > db.auth_user.username.requires = IS_NOT_IN_DB(db,
> > db.auth_user.username)
> > db.auth_user.registration_id.requires = IS_NOT_IN_DB(db,
> > db.auth_user.registration_id)
> > db.auth_user.email.requires =
> > (IS_EMAIL(error_message=auth.messages.invalid_email),
> > IS_NOT_IN_DB(db, db.auth_user.email))
> > auth.define_tables(migrate = settings.migrate)
>
> > On Jan 4, 9:27 am, Anthony <abas...@gmail.com> wrote:
> > > I cannot reproduce this problem. Do you get the "value already in
> > database
> > > or empty" message specifically on the registration_key field, or on the
> > > email or username field? Have you set any validators for
> > > db.auth_user.registration_key (you can check by printing
> > > db.auth_user.registration_key.requires)?
>
> > > Anthony
>
> > > On Wednesday, January 4, 2012 8:48:29 AM UTC-5, OpenMercury wrote:
>
> > > > Hi,
>
> > > > I'm using the basic scaffolding app and have set it up so new users
> > > > need to be approved to use the application.
> > > > I'm registered and there is an entry in auth_user table. The
> > > > registration key field value is 'Pending'. From reading the docs, all
> > > > I should have to do is blank out the registration key field. I'm
> > > > trying to do that via appAdmin and editing the current record. When I
> > > > blank out registration key field and hit 'submit' I get the message
> > > > "value already in database or empty". What am I doing wrong
> > or is
> > > > this a bug?
>
> > > > Thanks Scott
