oh yes it's working without cache.
vince
On Nov 6, 2:19 am, mdipierro <mdipie...@cs.depaul.edu> wrote:
> There is good code here. Can you help me debug this?
> can you try remove cache=(...) in validators?
> Feel free to email me personally and we'll post the fix when done.
>
> Massimo
>
> On Nov 5, 11:25 am, vince <lapcc...@gmail.com> wrote:
>
> > field1 =
> > ["sel","code","name","nickname","ename","sex","staywith","mgroup","mcommittee","origin"]
>
> > db.members.image.autodelete=True
> > db.members.sex.requires=IS_IN_DB
> > (db,'sex_list.name',orderby='sex_list.id',cache=(cache.ram,60))
> > db.members.ceremony.requires=IS_IN_DB
> > (db,'cere_list.name',orderby='cere_list.id',cache=(cache.ram,60))
> > db.members.m_status.requires=IS_IN_DB
> > (db,'mstatus_list.name',orderby='mstatus_list.id',cache=(cache.ram,
> > 60))
> > db.members.educ.requires=IS_IN_DB
> > (db,'educ_list.name',orderby='educ_list.id',cache=(cache.ram,60))
> > db.members.church.requires=IS_IN_DB
> > (db,'church_list.name',orderby='church_list.id',cache=(cache.ram,60))
> > db.members.relation1.requires=IS_IN_DB
> > (db,'relation_list.name',orderby='relation_list.id',cache=(cache.ram,
> > 60))
> > db.members.relation2.requires=IS_IN_DB
> > (db,'relation_list.name',orderby='relation_list.id',cache=(cache.ram,
> > 60))
> > db.members.relation3.requires=IS_IN_DB
> > (db,'relation_list.name',orderby='relation_list.id',cache=(cache.ram,
> > 60))
> > db.members.relation4.requires=IS_IN_DB
> > (db,'relation_list.name',orderby='relation_list.id',cache=(cache.ram,
> > 60))
> > db.members.relation5.requires=IS_IN_DB
> > (db,'relation_list.name',orderby='relation_list.id',cache=(cache.ram,
> > 60))
> > db.members.relation6.requires=IS_IN_DB
> > (db,'relation_list.name',orderby='relation_list.id',cache=(cache.ram,
> > 60))
> > db.members.relation7.requires=IS_IN_DB
> > (db,'relation_list.name',orderby='relation_list.id',cache=(cache.ram,
> > 60))
> > db.members.relation8.requires=IS_IN_DB
> > (db,'relation_list.name',orderby='relation_list.id',cache=(cache.ram,
> > 60))
> > db.members.relation9.requires=IS_IN_DB
> > (db,'relation_list.name',orderby='relation_list.id',cache=(cache.ram,
> > 60))
>
> > actually i have not touch this application over year and its still
> > working fine at the moment, i just need to make some changes recently
> > and may as well update web2py to latest version but then it stop
> > working. i have no idea if it's web2py's problem or i did some non-
> > compliant stuff. anyway how can i trace out the problem?
>
> > vince
>
> > On Nov 6, 12:25 am, mdipierro <mdipie...@cs.depaul.edu> wrote:
>
> > > Can you show us how you set validators for db.members
>
> > > I do not think this is a web2py bug (may be wrong) but perhaps
> > > something was wrong before and web2py was not catching.
>
> > > Massimo
>
> > > On Nov 5, 9:46 am, vince <lapcc...@gmail.com> wrote:
>
> > > > my application was working fine with 1.59 and i just upgrade to 1.71.2
> > > > and with the following error. i am using sqlite, any ideas?
> > > > everything works fine if i switch back to 1.59
>
> > > > Traceback (most recent call last):
> > > > File "/Library/WebServer/Documents/web2py/gluon/restricted.py", line
> > > > 184, in restricted
> > > > exec ccode in environment
> > > > File "/Library/WebServer/Documents/web2py/applications/cy/
> > > > controllers/members.py", line 2365, in <module>
> > > > File "/Library/WebServer/Documents/web2py/gluon/globals.py", line
> > > > 103, in <lambda>
> > > > self._caller = lambda f: f()
> > > > File "/Library/WebServer/Documents/web2py/applications/cy/
> > > > controllers/members.py", line 72, in show
> > > > form1=SQLFORM
> > > > (db.members,thisrecord,fields=field1,deletable=False,showid=False,labels=header1,submit_button=T
> > > > ('Submit'))
> > > > File "/Library/WebServer/Documents/web2py/gluon/sqlhtml.py", line
> > > > 613, in __init__
> > > > inp = self.widgets.options.widget(field, default)
> > > > File "/Library/WebServer/Documents/web2py/gluon/sqlhtml.py", line
> > > > 199, in widget
> > > > options = requires0.options()
> > > > File "/Library/WebServer/Documents/web2py/gluon/validators.py", line
> > > > 346, in options
> > > > self.build_set()
> > > > File "/Library/WebServer/Documents/web2py/gluon/validators.py", line
> > > > 333, in build_set
> > > > records = self.dbset.select(*self.fields, **dd)
> > > > File "/Library/WebServer/Documents/web2py/gluon/sql.py", line 2883,
> > > > in select
> > > > return self.parse(db,rows,self.colnames)
> > > > File "/Library/WebServer/Documents/web2py/gluon/sql.py", line 2891,
> > > > in parse
> > > > value = row[j]
> > > > File "/Library/WebServer/Documents/web2py/gluon/sql.py", line 611,
> > > > in __getitem__
> > > > return dict.__getitem__(self, key)
> > > > KeyError: '0'
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"web2py-users" group.
To post to this group, send email to web2py@googlegroups.com
To unsubscribe from this group, send email to
web2py+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/web2py?hl=en
-~----------~----~----~----~------~----~------~--~---
