Hi Massimo, the error is: Cannot operate on a closed database.
ticket:
Traceback (most recent call last):
File "/home/paolo/Dropbox/git/pp/web2py/gluon/restricted.py", line
209, in restricted
exec ccode in environment
File
"/home/paolo/Dropbox/git/pp/web2py/applications/test_vf/views/default/test.html",
line 3, in <module>
{{pass}}
File "/home/paolo/Dropbox/git/pp/web2py/gluon/dal.py", line 8825, in __call__
return self.method(self.row,*args,**kwargs)
File "/home/paolo/Dropbox/git/pp/web2py/applications/test_vf/models/db.py",
line 129, in <lambda>
db.reviews_s.pos = Field.Lazy(lambda row:
db((db.reviews_like_s.review_id == row.reviews_s.id) &
(db.reviews_like_s.helpful == True)).count() )
File "/home/paolo/Dropbox/git/pp/web2py/gluon/dal.py", line 8690, in count
return db._adapter.count(self.query,distinct)
File "/home/paolo/Dropbox/git/pp/web2py/gluon/dal.py", line 1597, in count
self.execute(self._count(query, distinct))
File "/home/paolo/Dropbox/git/pp/web2py/gluon/dal.py", line 1653, in execute
return self.log_execute(*a, **b)
File "/home/paolo/Dropbox/git/pp/web2py/gluon/dal.py", line 1647, in
log_execute
ret = self.cursor.execute(*a, **b)
ProgrammingError: Cannot operate on a closed database.
I put the code of the simple app in a new app with the latest web2py,
the first time I accessed the page all worked well but
when I reloaded it, I got the error. Hope this can help you.
Best,
Paolo
2012/8/31 Massimo Di Pierro <massimo.dipie...@gmail.com>:
> What's the error? Works for me.
>
>
> On Friday, 31 August 2012 16:00:24 UTC-5, Paolo wrote:
>>
>> Hi Massimo,
>> I made a simple app, accordingly this example the error seems related
>> to the cache, because without the cache all works fine.
>>
>> The model:
>> db.define_table('reviews_like_s',
>> Field('review_id', 'reference reviews'),
>> Field('helpful', 'boolean'))
>>
>> db.define_table('reviews_s',
>> Field('title'))
>> db.reviews_s.pos = Field.Lazy(lambda row:
>> db((db.reviews_like_s.review_id == row.reviews_s.id) &
>> (db.reviews_like_s.helpful == True)).count() )
>> db.reviews_s.neg = Field.Lazy(lambda row:
>> db((db.reviews_like_s.review_id == row.reviews_s.id) &
>> (db.reviews_like_s.helpful == False)).count() )
>>
>>
>> Function:
>> def test():
>> id = db.reviews_s.insert(title='xxx')
>> db.reviews_like_s.insert(review_id=id, helpful=True)
>> rows = db(db.reviews_s.id > 0).select( cache=(cache.ram,3600) )
>> return dict(reviews=rows)
>>
>> The view:
>> {{for review in reviews:}}
>> <p>{{=review.pos()}}</p>
>> {{pass}}
>>
>> On my side the first time works well, the second rises the error.
>>
>> Best,
>> Paolo
>>
>>
>> 2012/8/30 paolo....@gmail.com <paolo....@gmail.com>:
>> > Hi Massimo,
>> > no, I do not have multiple models, I have defined the string
>> > connection only once in db.py, that's all.
>> > I have a few try...except but in other places, I do not thing they are
>> > connected.
>> > I will try to make a simple app ables to reproduce the problem as soon
>> > as possible.
>> >
>> > Paolo
>> >
>> > 2012/8/30 Massimo Di Pierro <massimo....@gmail.com>:
>> >> Can you make a simple app to reproduce this?
>> >>
>> >> Do you have try .... except anywhere? Do you have multiple models wich
>> >> define the same db = DAL(...) connection?
>> >>
>> >>
>> >> On Thursday, 30 August 2012 15:49:01 UTC-5, Paolo wrote:
>> >>>
>> >>> Hi Bruno, a simple db with sqlite without modules
>> >>>
>> >>> db = DAL('sqlite://storage.sqlite', lazy_tables=True )
>> >>>
>> >>> sorry, but I've just discovered that the same problem is happened even
>> >>> with lazy_tables=False
>> >>> Paolo
>> >>>
>> >>> 2012/8/30 Bruno Rocha <rocha...@gmail.com>:
>> >>> > How are you defining the db connection? are you using models or
>> >>> > modules?
>> >>> > which db?
>> >>> >
>> >>> > --
>> >>> >
>> >>> >
>> >>> >
>> >>>
>> >>>
>> >>>
>> >>> --
>> >>> Paolo
>> >>
>> >> --
>> >>
>> >>
>> >>
>> >
>> >
>> >
>> > --
>> > Paolo
>>
>>
>>
>> --
>> Paolo
>
> --
>
>
>
--
Paolo
--
