I fixed it in trunk anyway, the problem originates from the fact that your table "returing" has a "type" field which is a keyword
On Aug 2, 3:16 am, Kenneth Lundström <[email protected]> wrote: > Here s the definition: > > db.define_table('returning', > db.Field('troop', db.troop, required=True), > db.Field('campaign', db.campaign, required=True), > db.Field('type', 'string', length=2, default='', > requires=IS_IN_SET(['', 'r', 'c', 'd', 'p'])), > db.Field('edited_by', db[user_table], required=True), > db.Field('edited_date', 'datetime', required=True), > migrate=settings.migrate) > > db.define_table('returning_revision', > db.returning, > db.Field('returning', db.returning, required=True), > migrate=settings.migrate) > > I added db.Field("id","id"), and now it is working. > > Kenneth > > > > > > > > > Can you show the definition of table "returning"? > > I think I know what is wrong. > > > As a test, can you try adding a Field("id","id") on top of your table > > "returning_revision"? > > > On Aug 2, 2:24 am, Kenneth Lundstr m<[email protected]> > > wrote: > >> I tried to upgrade a development server from 1.91.4 to 1.98.1 and now I > >> get these tickets: > > >> Version > >> web2py^(TM) Version 1.98.1 (2011-07-31 10:15:50) > > >> Traceback (most recent call last): > >> File "/data/domains/gluon/restricted.py", line 192, in restricted > >> exec ccode in environment > >> File "/data/domains/applications/init/models/2_db.py", line 463, in > >> <module> > >> migrate=settings.migrate) > >> File "/data/domains/gluon/dal.py", line 4311, in define_table > >> polymodel=polymodel) > >> File "/data/domains/gluon/dal.py", line 593, in create_table > >> fields.append('PRIMARY KEY(%s)' % table._id.name) > >> File "/data/domains/gluon/dal.py", line 4730, in __getattr__ > >> return self[key] > >> File "/data/domains/gluon/dal.py", line 4674, in __getitem__ > >> return dict.__getitem__(self, str(key)) > >> KeyError: '_id' > > >> 462 db.define_table('returning_revision', > >> 463 db.returning, > >> 464 > >> db.Field<https://exp-kal.nudata.fi/examples/global/vars/Field>('returning',db.returning,required=True), > >> 465 migrate=settings.migrate) > > >> Any ideas whats wrong? > > >> Kenneth
