plugin_inscripcion_temp_id = request.args[0] Well, somehow request.args[0] is taking on the value "cache" rather than being an integer ID as you expect. Again, can't say how that is happening without seeing the code that generates the URL that calls the planilla function.
Note, you can do request.args(0, cast=int, otherwise=[alternative action])and it will attempt to cast the value of the arg to an integer. If it fails, it defaults to raising a 404 error, but you can also specify "otherwise" as a URL for redirect or as a callable to take any other action. This won't solve your immediate problem, but it is a way to more gracefully handle unexpected URL args. Anthony On Monday, December 10, 2012 8:12:02 AM UTC-5, www.diazluis.com wrote: > > > > def planilla(): > > id_user = (auth.user and auth.user.id) or None > > plugin_inscripcion_temp_id = request.args[0] > > plugin_inscripcion_temp = > db.plugin_inscripcion_temp(id=plugin_inscripcion_temp_id, user=id_user) > > if plugin_inscripcion_temp is None: > session.flash = 'Error proceso no encontrado' > redirect (request.env.http_referer) > > if plugin_inscripcion_temp.periodo_academico is None: > session.flash = 'El estudiante no ha definido los datos de la > inscripcion' > redirect (request.env.http_referer) > > perfil = db.perfil(user=plugin_inscripcion_temp.user) > > > return dict(plugin_inscripcion_temp=plugin_inscripcion_temp, > perfil=perfil) > > > > El viernes, 7 de diciembre de 2012 09:26:09 UTC-4:30, Anthony escribió: >> >> I don't think the cache system is causing the problem. In this line: >> >> plugin_inscripcion_temp = db.plugin_inscripcion_temp(id= >> plugin_inscripcion_temp_id, user=id_user) >> >> the value of either plugin_inscripcion_temp or id_user is 'cache' (i.e., >> a string literal, not the web2py cache object) rather than an integer. It's >> hard to say why that is the case without seeing more code. >> >> Anthony >> >> On Friday, December 7, 2012 8:31:07 AM UTC-5, www.diazluis.com wrote: >>> >>> greetings to all. >>> Thanks for your time. >>> >>> lately I've been spending >>> have my app cache error >>> but I do not use the cache >>> >>> my app using sqlite database, and run on your own server. >>> >>> I use debian 6 >>> web2py v. 2.2.1 >>> >>> the error I have is: >>> >>> 19 plugin_inscripcion_temp.py ValueError: invalid literal for int() >>> with base 10: 'cache' + details >>> >>> Traceback (most recent call last): >>> File "/home/www-data/web2py/gluon/restricted.py", line 209, in >>> restricted >>> exec ccode in environment >>> File >>> "/home/www-data/web2py/applications/sinca/controllers/plugin_inscripcion_temp.py", >>> >>> line 264, in <module> >>> File "/home/www-data/web2py/gluon/globals.py", line 186, in <lambda> >>> self._caller = lambda f: f() >>> File >>> "/home/www-data/web2py/applications/sinca/controllers/plugin_inscripcion_temp.py", >>> >>> line 102, in planilla >>> plugin_inscripcion_temp = >>> db.plugin_inscripcion_temp(id=plugin_inscripcion_temp_id, user=id_user) >>> File "/home/www-data/web2py/gluon/dal.py", line 7646, in __call__ >>> return >>> self._db(query).select(limitby=(0,1),for_update=for_update).first() >>> File "/home/www-data/web2py/gluon/dal.py", line 8766, in select >>> return adapter.select(self.query,fields,attributes) >>> File "/home/www-data/web2py/gluon/dal.py", line 2094, in select >>> return super(SQLiteAdapter, self).select(query, fields, attributes) >>> File "/home/www-data/web2py/gluon/dal.py", line 1581, in select >>> sql = self._select(query, fields, attributes) >>> File "/home/www-data/web2py/gluon/dal.py", line 1444, in _select >>> sql_w = ' WHERE ' + self.expand(query) >>> File "/home/www-data/web2py/gluon/dal.py", line 1277, in expand >>> return op(first, second) >>> File "/home/www-data/web2py/gluon/dal.py", line 1160, in AND >>> return '(%s AND %s)' % (self.expand(first), self.expand(second)) >>> File "/home/www-data/web2py/gluon/dal.py", line 1277, in expand >>> return op(first, second) >>> File "/home/www-data/web2py/gluon/dal.py", line 1205, in EQ >>> self.expand(second, first.type)) >>> File "/home/www-data/web2py/gluon/dal.py", line 1287, in expand >>> return str(self.represent(expression,field_type)) >>> File "/home/www-data/web2py/gluon/dal.py", line 1708, in represent >>> return str(int(obj)) >>> ValueError: invalid literal for int() with base 10: 'cache' >>> >>> ########## END >>> >>> cleared, the app works! .. >>> but every morning when I arrive, I find a list of such errors. >>> >>> Currently the app is processing the registration (filled profile) from >>> 2900 users. >>> sorry if I am not clear .. my language is Spanish >>> >>> --
