Re: [web2py] Re: Referencing user results in syntax-error?

Thanks, that did the trick. On Fri, Jul 27, 2012 at 5:25 PM, Niphlod wrote: > Massimo is right, but you're having the error for another reason. > > it's plain and clear (*Variables* section). You are also lucky that in > all of this statement there is only one dot. > > ('ALTER TABLE rsvp_list AD

[web2py] Re: Referencing user results in syntax-error?

Massimo is right, but you're having the error for another reason. it's plain and clear (*Variables* section). You are also lucky that in all of this statement there is only one dot. ('ALTER TABLE rsvp_list ADD event_id INTEGER REFERENCES db.event (id) ON DELETE CASCADE;',) you have Field('ev

[web2py] Re: Referencing user results in syntax-error?

On Friday, July 27, 2012 6:45:04 AM UTC+10, Massimo Di Pierro wrote: > > Person cannot be not null and default to auth.user_id which likely is null. > > It also cannot defaul to auth.user. > > Use the second line and remove notnull > Thanks, but that gave me the same error. Full ticket: http://jsf