[web2py] Upgrade to 2.0.x - AttributeError: 'Table' object has no attribute 'permissionid'

[Jim S]

Getting the following:

Traceback (most recent call last):
  File "C:\dev\web2py\gluon\restricted.py", line 209, in restricted
    exec ccode in environment
  File "C:/dev/web2py/applications/infocenter/models/db.py" 
<http://127.0.0.1:8000/admin/default/edit/infocenter/models/db.py>, line 152, 
in <module>
    format='%(name)s')
  File "C:\dev\web2py\gluon\dal.py", line 7047, in define_table
    table = self.lazy_define_table(tablename,*fields,**args)
  File "C:\dev\web2py\gluon\dal.py", line 7078, in lazy_define_table
    polymodel=polymodel)
  File "C:\dev\web2py\gluon\dal.py", line 920, in create_table
    fake_migrate=fake_migrate)
  File "C:\dev\web2py\gluon\dal.py", line 988, in migrate_table
    and not isinstance(table[key].type, SQLCustomType) \
  File "C:\dev\web2py\gluon\dal.py", line 7559, in __getitem__
    return ogetattr(self, str(key))
AttributeError: 'Table' object has no attribute 'permissionid'

Relevant define_table in db.py:

link = db.define_table('link', 
    Field('linkId', 'id', readable=False),
    Field('name', length=50, required=True, unique=True),
    Field('parentLinkId', 'reference link', required=True,
          label='Parent Link'),
    Field('controller', length=512, required=True),
    Field('method', length=512, required=True),
    Field('picture', length=512, required=False),
    Field('permissionId', db.auth_permission, label='Rqd Permission'),
    Field('groupId', db.auth_group, label='Rqd Group'),
    Field('description', 'text', required=True),
    format='%(name)s')


This is line 152.  If I change it to the following (added .id to definition 
of permissionId field reference) :

link = db.define_table('link', 
 Field('linkId', 'id', readable=False),
 Field('name', length=50, required=True, unique=True),
 Field('parentLinkId', 'reference link', required=True,
 label='Parent Link'),
 Field('controller', length=512, required=True),
 Field('method', length=512, required=True),
 Field('picture', length=512, required=False),
 Field('permissionId', db.auth_permission.id, label='Rqd Permission'),  
 Field('groupId', db.auth_group, label='Rqd Group'),
 Field('description', 'text', required=True),
 format='%(name)s')

Then I get the following traceback:

Traceback (most recent call last):
  File "C:\dev\web2py\gluon\restricted.py", line 209, in restricted
    exec ccode in environment
  File "C:/dev/web2py/applications/infocenter/models/db.py" 
<http://127.0.0.1:8000/admin/default/edit/infocenter/models/db.py>, line 152, 
in <module>
    format='%(name)s')
  File "C:\dev\web2py\gluon\dal.py", line 7047, in define_table
    table = self.lazy_define_table(tablename,*fields,**args)
  File "C:\dev\web2py\gluon\dal.py", line 7078, in lazy_define_table
    polymodel=polymodel)
  File "C:\dev\web2py\gluon\dal.py", line 721, in create_table
    elif field_type.startswith('reference'):
  File "C:\dev\web2py\gluon\dal.py", line 8122, in startswith
    raise SyntaxError, "startswith used with incompatible field type"
SyntaxError: startswith used with incompatible field type

Any ideas where to look for this one?

-Jim

--