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
-~----------~----~----~----~------~----~------~--~---
