Aha!
this line
auth_table=db.define_table(auth.settings.table_user_name,
should be
auth.settings.table_user=db.define_table
(auth.settings.table_user_name,
On Jan 6, 11:44 am, annet <annet.verm...@gmail.com> wrote:
> Massimo,
>
> Thanks for your reply.
>
> > Back to your original problem:
> > 2) You have a custom auth_user in the wrong place in db.py (or with
> > wrong syntax) and the table gets defined twice. I am pretty sure this
> > is the case but I cannot point to the error if I do not see the code.
>
> This is the code I have in db.py:
>
> from gluon.tools import *
> auth=Auth(globals(),db) # authentication/
> authorization
> # auth.settings.hmac_key='sha512:a94ab0df-7d00-4326-bc4b-e8732ed0e81a'
>
> auth_table=db.define_table(auth.settings.table_user_name,
> Field('bedrijf', db.bedrijf, default='',
> notnull=True,ondelete='CASCADE', writable=False, readable=False),
> Field('first_name', length=128, default='', notnull=True),
> Field('last_name', length=128, default='', notnull=True),
> Field('email', length=128, default='', notnull=True),
> Field('site', type='boolean', writable=False, readable=False),
> Field('username', length=128, default='', notnull=True,
> unique=True),
> Field('password', type='password', length=256, readable=False,
> default='', notnull=True),
> Field('created_on',type='datetime', writable=False,
> readable=False),
> Field('modified_on',type='datetime', writable=False,
> readable=False),
> Field('most_recent_login',type='datetime', writable=False,
> readable=False),
> Field('registration_key', length=128, writable=False,
> readable=False, default=''))
>
> auth_table.bedrijf.requires=[IS_IN_DB(db, db.bedrijf.id, '%
> (bedrijfsnaam)s')]
> auth_table.bedrijf.label='Bedrijf * '
> auth_table.first_name.requires=[IS_LENGTH(128,error_message='lengte
> overschreidt 128 tekens'), IS_NOT_EMPTY()]
> auth_table.first_name.label='Voornaam * '
> auth_table.last_name.requires=[IS_LENGTH(128,error_message='lengte
> overschreidt 128 tekens'), IS_NOT_EMPTY()]
> auth_table.last_name.label='Achternaam * '
> auth_table.email.requires=[IS_LENGTH(128,error_message='lengte
> overschreidt 128 tekens'), IS_EMAIL(), IS_NOT_EMPTY()]
> auth_table.email.label='E-mail * '
> auth_table.site.default=False
> auth_table.username.requires=[IS_LENGTH(128,error_message='lengte
> overschreidt 128 tekens'), IS_NOT_EMPTY(), IS_NOT_IN_DB(db,
> 'auth_user.username')]
> auth_table.username.label='Gebruikersnaam * '
> auth_table.password.requires=[IS_NOT_EMPTY(), CRYPT()]
> auth_table.password.label='Wachtwoord * '
> auth_table.created_on.default=request.now
> auth_table.modified_on.default=request.now
> auth_table.modified_on.update=request.now
> auth_table.most_recent_login.default=request.now
> auth.settings.table_user=auth_table
>
> auth.define_tables() # creates all needed
> tables
>
> I hope this provides you with sufficient information to help me solve
> the problem.
>
> The fact that the tables related to authentication and authorization
> are defined in a different application than the other tables isn't a
> problem then?
>
> Kind regards,
>
> Annet.
--
You received this message because you are subscribed to the Google Groups
"web2py-users" group.
To post to this group, send email to web...@googlegroups.com.
To unsubscribe from this group, send email to
web2py+unsubscr...@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/web2py?hl=en.
