Both apps are using same mysql database. masterapp calls it auth_user and
it is present in the database, as i checked it in mysql console.
On Fri, 16 Dec 2011 01:13:02 +0530, Anthony <[email protected]> wrote:
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'
>>
