http://web2py.com/books/default/chapter/29/06?search=reserved#Reserved-keywords
Standard SQL keywords are normally reserved in all SQL databases. "Order" is a sql keyword, so it may not be reserved by web2py but the database itself. To give you an example, here are a few... http://dev.mysql.com/doc/refman/5.5/en/reserved-words.html You'll want to check the reserved keywords for your database if you don't know them already. It's always documented. On Monday, October 8, 2012 12:42:33 PM UTC-7, 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. --
