Hello,
I am using a database Postgres.
> Can you show the entire traceback?
Traceback (most recent call last):
File "/home/fvillarroel/web2py/gluon/restricted.py", line 107, in restricted
exec ccode in environment
File "/home/fvillarroel/web2py/applications/clientes/controllers/default.py",
line 53, in <module>
File "/home/fvillarroel/web2py/gluon/globals.py", line 80, in <lambda>
self._caller = lambda f: f()
File "/home/fvillarroel/web2py/applications/clientes/controllers/default.py",
line 32, in user
return dict(form=auth())
File "/home/fvillarroel/web2py/gluon/tools.py", line 436, in __call__
return self.register()
File "/home/fvillarroel/web2py/gluon/tools.py", line 745, in register
group_id = self.add_group("user_%s" % form.vars.id, description)
File "/home/fvillarroel/web2py/gluon/tools.py", line 1211, in add_group
description=description)
File "/home/fvillarroel/web2py/gluon/sql.py", line 1377, in insert
self._db._execute(query)
File "/home/fvillarroel/web2py/gluon/sql.py", line 726, in <lambda>
self._execute = lambda *a, **b: self._cursor.execute(*a, **b)
ProgrammingError: no existe la relación «auth_group»
> Do you get error even if
> auth.settings.create_user_groups=True?
yes
> If you use appadmin, do you see the auth_group?
No
appadmin is the front end for administrator?
>
>
>
> On Jul 16, 4:29 pm, FERNANDO VILLARROEL <fvillarr...@yahoo.com>
> wrote:
> > Dear all.
> >
> > I am trying to use authentication:
> >
> > http://www.web2py.com/examples/default/tools
> >
> > I have the following code on my db.py:
> >
> > from gluon.tools import *
> > auth=Auth(globals(),db) #
> authentication/authorization
> >
> > # define custom tables (table_user_name is
> 'auth_user')
> > auth.settings.table_user =
> db.define_table(auth.settings.table_user_name,
> > db.Field('first_name', length=128,default=''),
> > db.Field('last_name', length=128,default=''),
> > db.Field('email', length=128,default='',
> requires = [IS_EMAIL(),
> IS_NOT_IN_DB(db,'%s.email'%auth.settings.table_user_name)]),
> > db.Field('password', 'password', readable=False,
> label='Password', requires=CRYPT()),
> > db.Field('registration_key', length=128,
> writable=False, readable=False,default=''),migrate=False)
> >
> > auth.define_tables() # creates
> all needed tables
> > auth.settings.create_user_groups=False
> >
> > But the application return the next exception:
> >
> > self._db._execute(query)
> > File "/home/fvillarroel/web2py/gluon/sql.py", line
> 726, in <lambda>
> > self._execute = lambda *a, **b:
> self._cursor.execute(*a, **b)
> > ProgrammingError: no existe la relación
> «auth_group»
> >
> > What is the struct of the table auth_group?
> >
> > what i am doing wrong?
> >
> > Any idea or how i can solved the problem.
> >
> > Fernando
> >
>
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"web2py Web Framework" group.
To post to this group, send email to web2py@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
-~----------~----~----~----~------~----~------~--~---
