try DAL(..., check_reserved=['all'])
You cannot name a field "group" it is a SQL reserved keyword. Bruno Rocha http://rochacbruno.com.br mobile Em 02/12/2012 02:46, "David Tucker" <[email protected]> escreveu: > I'm editing my data model in db.py and trying to add a field to a table of > accounts that groups them using a foreign key. > > Field('group', 'reference groups', ondelete='CASCADE', > required=True, default=db(db.groups).select().first().id), > > causes a ticket that reads: and causes web2py to freeze > (must force quit and reopen); however, > > Field('groupd', 'reference groups', ondelete='CASCADE', > required=True, default=db(db.groups).select().first().id), > > works fine. > > Can someone explain why this is? Also, is there a better/more elegant way > to specify a default for 'reference' types? Basically I want the default to > be the first entry in the 'groups' table (which is a generic 'ungrouped' > group). > > Thank you for any help, I'm a web2py noob coming from a PHP/MySQL > background. > > -- > > > > --
