Is this two separate databases -- one from the other app for Auth, and one for this app? If so, I don't think you can join tables across databases.
Also, does the other app call its user table 'auth_user', or is it using a different name for that table? Anthony On Thursday, December 15, 2011 2:02:56 PM UTC-5, Chandra wrote: > > no, i'm sharing the auth tables from another application in a separate > model (auth.py) and this code is defined in db.py. so, alphabetically > auth.py is exceuted first. > > On Fri, 16 Dec 2011 00:27:59 +0530, Anthony <[email protected]> wrote: > > > Does this code get run before your db.auth_user table has been defined? > > > > On Thursday, December 15, 2011 1:49:31 PM UTC-5, Chandra wrote: > >> > >> > >> I'm trying to establish one to many relation with auth_user, but i'm > >> getting this error: > >> > >> Traceback (most recent call last): > >> File "/home/chandra/dev/web2py/gluon/restricted.py", line 194, in > >> restricted > >> exec ccode in environment > >> File "/home/chandra/dev/web2py/applications/jobs/models/db.py", line > >> 15, > >> in <module> > >> Field('org', db.auth_user), > >> File "/home/chandra/dev/web2py/gluon/dal.py", line 4511, in > >> __getattr__ > >> return self[key] > >> File "/home/chandra/dev/web2py/gluon/dal.py", line 4505, in > >> __getitem__ > >> return dict.__getitem__(self, str(key)) > >> KeyError: 'auth_user' > >> > > >
