KeyError : 'name' when inserting/updating via sqlform.grid

[Mandar Vaze / मंदार वझे]

I have posted this query sometime ago via google-group's web interface - but it did not appear in the list - may be it is lost or held in moderation queue (This is my first post) So I am sending this again via normal gmail interface.

If this is duplicate - please ignore.

================

I'm using web2py version : Version 2.0.0 (2012-07-26 06:06:10) dev

I have tables defined as follows : 

name = db.Table(db, 'name',                                                  

        Field('name', 'string', length=128, notnull=True, unique=True))                                                                             

name_desc = db.Table(db, 'base',

        name,

        Field('description', 'text', default=''))                               

db.define_table('mother', 

                name_desc,        

                format='%(name)s')    

db.define_table('father', 

                name_desc,        

                format='%(name)s')    

db.define_table('child',                                                          

        name_desc,                                                              

        Field('mother', db.mother),                                                   

        Field('father', db.father),                                                                                          

        format='%(name)s')

I am able to successfully insert data in "mother" table via script (e.g. db.mother.insert(name="Alice"))

But when I use appadmin to insert new record into mother table, I get the following error :

I have a sqlform.grid somewhere in the app, I get same error there too ( I think appadmin also uses sqlform.grid internally)

Traceback (most recent call last):

  File "/home/mandar/web2py/gluon/restricted.py", line 205, in restricted

    exec ccode in environment

  File "/home/mandar/web2py/applications/test1/controllers/appadmin.py", line 432, in <module>

  File "/home/mandar/web2py/gluon/globals.py", line 182, in <lambda>

    self._caller = lambda f: f()

  File "/home/mandar/web2py/applications/test1/controllers/appadmin.py", line 127, in insert

    if form.accepts(request.vars, session):

  File "/home/mandar/web2py/gluon/sqlhtml.py", line 1146, in accepts

    hideerror=hideerror,

  File "/home/mandar/web2py/gluon/html.py", line 1870, in accepts

    status = self._traverse(status,hideerror)

  File "/home/mandar/web2py/gluon/html.py", line 793, in _traverse

    newstatus = c._traverse(status,hideerror) and newstatus

  File "/home/mandar/web2py/gluon/html.py", line 793, in _traverse

    newstatus = c._traverse(status,hideerror) and newstatus

  File "/home/mandar/web2py/gluon/html.py", line 793, in _traverse

    newstatus = c._traverse(status,hideerror) and newstatus

  File "/home/mandar/web2py/gluon/html.py", line 793, in _traverse

    newstatus = c._traverse(status,hideerror) and newstatus

  File "/home/mandar/web2py/gluon/html.py", line 800, in _traverse

    newstatus = self._validate()

  File "/home/mandar/web2py/gluon/html.py", line 1625, in _validate

    (value, errors) = validator(value)

  File "/home/mandar/web2py/gluon/validators.py", line 554, in __call__

    table = self.dbset.db[tablename]

  File "/home/mandar/web2py/gluon/dal.py", line 6877, in __getitem__

    return dict.__getitem__(self, str(key))

KeyError: 'name'

Similarly, after populating mother/father and child tables via script when I try to update "child" record - In the dropdown I see mother's names instead of ID (as expected) but when I select different "mother" and submit I get same error (traceback may be slightly different - but same KeyError:'name' )

What is wrong with the table definitions ?

Thanks,

-Mandar

P.S: This may be similar to https://groups.google.com/d/msg/web2py/XR4T92l2rJ4/dtTRnO0e7dcJ

[Mandar Vaze]

I figured out that problem is due to the way I have defined Table Inheritance for mother/father/child.

If I define fields name and description directly in the mother/father/child tables, inserts/updates work OK.

Now the question is : 

What is wrong with the way I've defined the tables ? Here is the code for your reference :

name = db.Table(db, 'name',                                                  

        Field('name', 'string', length=128, notnull=True, unique=True))                                                                            

name_desc = db.Table(db, 'base',

        name,

        Field('description', 'text', default=''))                               

db.define_table('mother', 

                name_desc,        

                format='%(name)s')

    

I've also checked that at database (mysql) level both name and description fields are defined for the tables - May be that is why insert/update work via the script.

Why does this fail via web interface - sqlform.grid ?

Thanks,

-Mandar

[Mandar Vaze]

Duplicate of http://code.google.com/p/web2py/issues/detail?id=648

The error goes away if "unique=True" is removed.

-Mandar