I do not understand this line monitordb.updates['processes']=dict(updatetime=datetime.datetime.now())
I do not think this is valid. Anyway, that is not the problem you asked about. Where are you executing these lines? From shell? Did you do -M? From another model? remember they are executed alphabetically. On Sep 2, 10:19 am, Geo <[email protected]> wrote: > 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
