that's because probably you are using names that your db does not allow as names because they are functions (i.e. naming a field "select" wouldn't work on most of the dbs). http://web2py.com/books/default/chapter/29/06#Reserved-keywords
On Monday, October 8, 2012 9:42:33 PM UTC+2, VP wrote: > > I've always had this problem with web2py. Sometime, I got a weird name > violation. For example, you can't name a table "order", or can't name a > field "item". It doesn't seem to be documented anywhere. --

