[web2py] Error when executing select command

[Kenneth]

I don´t understand what am I doing wrong.

command:
days = db((db.troop_place_day.day ==
2)&(db.troop_place_day.troop_place == 21)).select()

gives this error:

Traceback (most recent call last):
  File "gluon/restricted.py", line 178, in restricted
    exec ccode in environment
  File "/data/domains/exp-kal.nudata.fi/applications/init/controllers/
troop.py", line 2195, in <module>
  File "gluon/globals.py", line 96, in <lambda>
    self._caller = lambda f: f()
  File "gluon/tools.py", line 2219, in f
    return action(*a, **b)
  File "/data/domains/exp-kal.nudata.fi/applications/init/controllers/
troop.py", line 985, in edit_saleplace
    days = db((db.troop_place_day.day ==
2)&(db.troop_place_day.troop_place == 21)).select()
  File "gluon/sql.py", line 3162, in select
    return self.parse(db,rows,self.colnames,SetClass=Set)
  File "gluon/sql.py", line 3231, in parse
    str(value)[:8].strip().split(':')[:3]]
ValueError: invalid literal for int() with base 10: '1 day, 0'

My model for that table looks like this:

db.define_table('troop_place_day',
    db.Field('troop_place', db.troop_place, required=True),
    db.Field('day', 'integer'),
    db.Field('starts', 'time', requires=IS_TIME()),
    db.Field('ends', 'time', requires=IS_TIME()))

This error just started coming maybe an hour ago. I just deleted all
records from the record and same thing continues.

I really don't understand what is happening.


Kenneth