Now I know where to look for the fix. :-)
On Jan 19, 12:58 pm, Jim Steil <j...@qlf.com> wrote:
> Yes, my tables are all similar to this:
>
> assetType = db.define_table('assetType',
> Field('assetTypeId', 'id'),
> Field('name', length=50, required=True, unique=True),
> format='%(name)s')
>
> -Jim
>
> On 1/19/2012 11:34 AM, Massimo Di Pierro wrote:
>
>
>
>
>
>
>
> > Do the tables have id fields called other than id?
>
> > On Jan 19, 10:45 am, Jim Steil<j...@qlf.com> wrote:
> >> Hi
>
> >> Just updated to the latest trunk this morning and now my smartgrids
> >> aren't working where the table being used has links.
>
> >> Here is what I'm getting:
>
> >> Traceback(most recent call last):
> >> File"C:\dev\web2py\gluon\restricted.py",line204,inrestricted
> >> execccodeinenvironment
> >>
> >> File"C:/dev/web2py/applications/infocenter/controllers/administration.py"<http://127.0.0.1:8000/admin/default/edit/infocenter/controllers/admin...>,line1816,in<module>
> >> File"C:\dev\web2py\gluon\globals.py",line172,in<lambda>
> >> self._caller=lambdaf:f()
> >> File"C:\dev\web2py\gluon\tools.py",line2530,inf
> >> returnaction(*a, **b)
> >>
> >> File"C:/dev/web2py/applications/infocenter/controllers/administration.py"<http://127.0.0.1:8000/admin/default/edit/infocenter/controllers/admin...>,line457,inassetTypes
> >> paginate=15,maxtextlength=45)
> >> File"C:\dev\web2py\gluon\sqlhtml.py",line1971,insmartgrid
> >> user_signature=user_signature,**kwargs)
> >> File"C:\dev\web2py\gluon\sqlhtml.py",line1819,ingrid
> >> iflink(row):
> >> File"C:\dev\web2py\gluon\sqlhtml.py",line1968,in<lambda>
> >> args=request.args[:nargs]+[args0,row.id])))
> >> File"C:\dev\web2py\gluon\dal.py",line4996,in__getattr__
> >> return self[key]
> >> File"C:\dev\web2py\gluon\dal.py",line4987,in__getitem__
> >> returndict.__getitem__(self,key)
> >> KeyError:'id'
>
> >> If the table doesn't have any fields referencing other tables, then it
> >> works fine.
>
> >> Is it just me?
>
> >> -Jim
