Hi to everyone,
I'm using web2py Version 1.83.2 (2010-08-15 08:16:30) on windows xp
32, with Python 2.6
when I try to execute one of these commands:
monitordb.updates['processes']=dict(updatetime=datetime.datetime.now())
monitordb.commit()
or
query = monitordb.updates.task == 'processes'
for row in monitordb(query).select(monitordb.updates.updatetime):
updatetime = row.updatetime
I get this error:
Traceback (most recent call last):
File "C:\LOCALWORKS\python\web2py\applications\monitor/models/
processes.py", line 155, in _loadUpdateTime
for row in monitordb(query).select(monitordb.updates.updatetime):
File "C:\LOCALWORKS\python\web2py\gluon\sql.py", line 3216, in
select
rows = response(query)
File "C:\LOCALWORKS\python\web2py\gluon\sql.py", line 3211, in
response
db._execute(query)
File "C:\LOCALWORKS\python\web2py\gluon\sql.py", line 947, in
<lambda>
self._execute = lambda *a, **b: self._cursor.execute(*a, **b)
OperationalError: no such table: updates
the db and table are defined in models/db.py
monitordb = DAL('sqlite://monitor.sqlite')
monitordb.define_table('updates',
Field('task'),
Field('updatetime')
)
Just in case I also deleted the monitor.sqlite file so that web2py
could recreate it from scratch, but with no positive results.
Any idea on how to solve this?
Thanks