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 > > --