Emailed. Thanks for looking at it for me! -rob
On Jul 1, 9:45 am, mdipierro <[email protected]> wrote: > can you please email me your db.py? > > On Jul 1, 5:12 am, Rob Scheibel <[email protected]> wrote: > > > Thanks for the quick reply! I added the line > > "auth.settings.table_user=db.siteuser" and I'm still getting the same > > error. Here's the traceback: > > > Traceback (most recent call last): > > File "/home/rob/Desktop/web2py/gluon/restricted.py", line 107, in > > restricted > > exec ccode in environment > > File "/home/rob/Desktop/web2py/applications/test/models/db.py", line > > 87, in <module> > > auth.define_tables() # creates all needed tables > > File "/home/rob/Desktop/web2py/gluon/tools.py", line 528, in > > define_tables > > migrate=self.__get_migrate(self.settings.table_membership_name, > > migrate)) > > File "/home/rob/Desktop/web2py/gluon/sql.py", line 989, in > > define_table > > query = t._create(migrate=migrate) > > File "/home/rob/Desktop/web2py/gluon/sql.py", line 1341, in _create > > sql_fields_aux, logfile) > > File "/home/rob/Desktop/web2py/gluon/sql.py", line 1389, in _migrate > > self._db._execute(sub_query) > > File "/home/rob/Desktop/web2py/gluon/sql.py", line 761, in <lambda> > > self._execute = lambda *a, **b: self._cursor.execute(*a, **b) > > ProgrammingError: relation "siteuser" does not exist > > > Line #87 in db.py is: auth.define_tables() > > > -rob > > > On Jun 30, 5:53 pm, mdipierro <[email protected]> wrote: > > > > Try this: > > > > db.define_table( > > > "siteuser", > > > db.Field('user_id'), > > > db.Field('user_id__tmp'), > > > db.Field('firstname', length=128, default=''), > > > db.Field('lastname', length=128, default=''), > > > db.Field('email', length=128, default='', requires = [IS_EMAIL(), > > > IS_NOT_IN_DB(db,'siteuser.email')]), > > > db.Field('password', 'password', readable=False, label='Password', > > > requires=CRYPT()), > > > db.Field('registration_key', length=128, writable=False, > > > readable=False,default=''), > > > db.Field('last_logged_in', type='datetime', default='now'), > > > db.Field('last_logged_in_from', length=36, default=''), > > > db.Field('created_on', type='datetime', default='now'), > > > db.Field('active', type='boolean', default=True) > > > ) > > > > auth=Auth(globals(),db) # authentication/authorization > > > auth.settings.table_user_name = 'siteuser' > > > auth.settings.table_user=db.siteuser ### this was missing > > > auth.define_tables() # creates all needed tables --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
