Not sure what the problem is but it it fails because of this: affl = db(db.Colleges.id.belongs(cl)) db.Reservations.Affiliation.requires = IS_EMPTY_OR(IS_IN_DB(affl, db.Colleges.id, '%(Name)s',orderby=db.Colleges.Name))
could it be affl is empty? On Tuesday, 29 October 2013 14:24:38 UTC-5, David Manns wrote: > > I have attached the reservations section from my model. Also the relevant > section of the controller script - a number of validators are set up at run > time. The failure case is the crud.update() in the middle of the function, > modifying an existing reservation. There are no custom widgets involved. > > Note that the exact same application running on the same (production) > database on GAE using 2.4.6 works fine. The same appliction running on > 2.7.4 in my development environment also works fine, though the database > there is an older snapshot of the production database, which is what leads > me to think the problem is with GAE specific logic in the DAL? > > Thanks! > > David > > On Tuesday, October 29, 2013 2:58:50 PM UTC-4, Massimo Di Pierro wrote: >> >> Can you show us the db.Reservations definition and in particular its >> widgets and validators. >> there seems to be an invalid query in a IS_IN_DB somewhere. >> >> On Tuesday, 29 October 2013 08:28:06 UTC-5, David Manns wrote: >>> >>> I have been running my application on GAE using Python 2.7 and web2py >>> 2.4.6. >>> >>> Recently made minor application change and deployed with web2py 2.7.4, >>> the current version. I am getting an error in at least one part of the >>> application. The GAE log is attached. >>> >>> Re-deployed with the same application but web2py 2.4.6 and all is >>> working. >>> >>> Application uses the datastore (nosql) >>> >>> Failure occurs in this statement: >>> >>> form = crud.update(db.Reservations, request.vars.resvid, >>> deletable = True, onvalidation=setmodified, >>> ondelete=delreservation, >>> onaccept=modreservation) >>> >>> -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to web2py+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/groups/opt_out.