I am getting such an error in last release of web2py, with previews
versions didn't try
Traceback (most recent call last):
File "...\web2py\gluon\restricted.py", line 178, in restricted
exec ccode in environment
File ".../web2py/applications/mailtest/models/models.py", line 7, in
<module>
Field("body", "text")
File "...\web2py\gluon\sql.py", line 1309, in define_table
t._create(migrate=migrate, fake_migrate=fake_migrate)
File "...\web2py\gluon\sql.py", line 1730, in _create
self._db._execute(query)
File "...\web2py\gluon\sql.py", line 897, in <lambda>
self._execute = lambda *a, **b: self._cursor.execute(*a, **b)
OperationalError: near "from": syntax error
Is 'body' a keyword that can't be used ?
model:
db.define_table("email",
Field("from"),
Field("to"),
Field("subject"),
Field("body", "text")
)
view:
def index():
form = crud.create(db.email)
if form.accepts(request.vars, session):
pass
return dict(form=form)