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

Reply via email to