Dear all,
I just updated web2py and after turning on the lazy_table I got:
Traceback (most recent call last):
File "/home/paolo/Dropbox/git/web2py/gluon/restricted.py", line 209, in
restricted
exec ccode in environment
File
"/home/paolo/Dropbox/git/web2py/applications/bikend/views/load/reviewsFilter.html",
line 57, in <module>
var str = '{{=T('Route ')}}<small>NAME </small><b class="caret">
</b>'.replace(/NAME/gi, $(this).text());
File "/home/paolo/Dropbox/git/web2py/gluon/dal.py", line 8810, in __call__
return self.method(self.row,*args,**kwargs)
File "/home/paolo/Dropbox/git/web2py/applications/bikend/models/db.py"
<http://127.0.0.1:8000/admin/default/edit/bikend/models/db.py>, line 427, in
<lambda>
db.reviews.pos = Field.Lazy(lambda row: db((db.reviews_like.review_id ==
row.reviews.id) & (db.reviews_like.helpful == True)).count() )
File "/home/paolo/Dropbox/git/web2py/gluon/dal.py", line 8675, in count
return db._adapter.count(self.query,distinct)
File "/home/paolo/Dropbox/git/web2py/gluon/dal.py", line 1542, in count
self.execute(self._count(query, distinct))
File "/home/paolo/Dropbox/git/web2py/gluon/dal.py", line 1598, in execute
return self.log_execute(*a, **b)
File "/home/paolo/Dropbox/git/web2py/gluon/dal.py", line 1592, in log_execute
ret = self.cursor.execute(*a, **b)
ProgrammingError: Cannot operate on a closed database.
The table involved in the error is defined as follows:
db.define_table('reviews_like',
Field('review_id', 'reference reviews'),
Field('helpful', 'boolean',
widget = BuildRadioButtonWidget),
Field('created_on', 'datetime', default=request.now,
writable = False, readable = False),
Field('user_id', db.auth_user, default=auth.user_id,
writable = False, readable = False)
)
db.define_table('reviews',
Field('route_id', 'reference route', default=db.route.id),
Field('rating', 'integer',requires=IS_IN_SET(range(1,6))),
Field('title', 'string',
requires=(IS_NOT_EMPTY(error_message=T('Enter a
title')),IS_LENGTH(250,error_message=T('Warning, title too long')),
IS_LENGTH(minsize=3, error_message=T('Warning, title too short')))),
Field('description', 'text',
requires=(IS_NOT_EMPTY(error_message=T('Please, enter a
description')),IS_LENGTH(250,error_message=T('Warning, description too
long')), IS_LENGTH(minsize=75, error_message=T('Warning, the description is
too short, reviews must be at least 75 characters long.')))),
auth.signature,
)
db.reviews.route_id.readable = False
db.reviews.route_id.writable = False
db.reviews.rating.widget = starWidget
db.reviews.pos = Field.Lazy(lambda row: db((db.reviews_like.review_id ==
row.reviews.id) & (db.reviews_like.helpful == True)).count() )
db.reviews.neg = Field.Lazy(lambda row: db((db.reviews_like.review_id ==
row.reviews.id) & (db.reviews_like.helpful == False)).count() )
what is wrong ?
Cheers
Paolo
--
