order is a keyword in the database, just change the table name to orders.
On Mar 9, 10:49 pm, Jamboo <ghett...@gmail.com> wrote: > I tried making this simple database, and then tried the db admin panel > and then a ticket gets generated. I tried copying the examples from > Chapter 3 of the web2py book and I get the same type of message. I > have the db and error herehttp://www.pastie.org/1654196 > > ---------------- > > ## db.py > > db = DAL('sqlite://storage.sqlite') > > db.define_table('order', > Field('name'), > Field('address'), > Field('city'), > Field('state'), > Field('zipcode','integer')) > > db.order.name.requires=IS_NOT_EMPTY() > db.order.address.requires=IS_NOT_EMPTY() > db.order.city.requires=IS_NOT_EMPTY() > db.order.state.requires=IS_NOT_EMPTY() > db.order.zipcode.requires=IS_NOT_EMPTY()
