OK. I think there is no problem then. Somebow the database was corrupted. Now everything should work. Let me know if not.
Massimo On Jul 16, 11:13 pm, FERNANDO VILLARROEL <[email protected]> wrote: > > I suspect we have a major problem here: > > > "role" is a keyword in postgresql and I did not know about > > it. To > > check if this is the problem: > > > 1) remove the database > > 2) remove everything in databases/* > > 3) create the database again > > 4) go to appadmin and tell me which tables you see > > Done > > i see the following tables: > > db.tarifa > db.clientes > db.accountcode > db.pagos > db.proveedor > db.rutaproveedor > db.webuser > db.auth_user > db.auth_group > db.auth_membership > db.auth_permission > db.auth_event > > > Once we have identified the problem, we'll find a > > solution. > > > Massimo > > > On Jul 16, 9:49 pm, FERNANDO VILLARROEL <[email protected]> > > wrote: > > > 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 <[email protected]> > > > > 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 [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/web2py?hl=en -~----------~----~----~----~------~----~------~--~---
