Duplicate of http://code.google.com/p/web2py/issues/detail?id=648
The error goes away if "unique=True" is removed.
-Mandar
On Thursday, August 9, 2012 9:13:36 PM UTC+5:30, Mandar Vaze wrote:
>
> 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
>
> On Wednesday, August 8, 2012 11:14:00 PM UTC+5:30, Mandar Vaze wrote:
>>
>> 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
>>
>
--
