[web2py] Re: Problem with reference fields

2011-08-08 Thread Anthony
On Monday, August 8, 2011 6:12:42 PM UTC-4, Eric Scott wrote: > > Thanks, Richard. Yes, I did make sure the custom auth_user was > correct before I added the reference fields that caused the error. > And I do have the student and contact tables defined. They were > defined in the db_wizard.py

[web2py] Re: Problem with reference fields

2011-08-08 Thread Eric Scott
Thanks, Richard. Yes, I did make sure the custom auth_user was correct before I added the reference fields that caused the error. And I do have the student and contact tables defined. They were defined in the db_wizard.py file but I put all the model defs in the same db.py file, but still get the

[web2py] Re: Problem with reference fields

2011-08-08 Thread Cliff
The problem is in line 61 of your db.py. When you make "Field('student', db.student", you are telling the DAL to go look for a table named "student." If you have no such table, it will raise an exception. If you're going to do a self join, the right syntax would be "Field('student', db.auth_user

Re: [web2py] Re: Problem with reference fields

2011-08-08 Thread Richard Vézina
Yes... Maybe they are after the table they are referenced by!!! They should be before... Richard On Mon, Aug 8, 2011 at 4:47 PM, Jim Steil wrote: > Eric > > Do you also have student and contact tables defined? > >-Jim > > > On 8/8/2011 3:33 PM, Eric Scott wrote: > >> Thanks for your respons

Re: [web2py] Re: Problem with reference fields

2011-08-08 Thread Jim Steil
Eric Do you also have student and contact tables defined? -Jim On 8/8/2011 3:33 PM, Eric Scott wrote: Thanks for your response, Richard and Jim. Richard, the traceback is in my original message, as is the problematic part of the model code. The error occurs with any view/controller -- I c

Re: [web2py] Re: Problem with reference fields

2011-08-08 Thread Richard Vézina
Without the whole model it is difficult to clearly understand what you are trying to acheive... You add those line to auth_user that you have customized?? Field('student', db.student), # = one to many Field('contact', db.contact), # idem It could depend of your backend database if it support FK.

[web2py] Re: Problem with reference fields

2011-08-08 Thread Eric Scott
Thanks for your response, Richard and Jim. Richard, the traceback is in my original message, as is the problematic part of the model code. The error occurs with any view/controller -- I can't access the app at all. The problem is definitely in the model and not the controller. The problem occurs