------------- EXCEPTION: RM::Exception::Database ------------- MSG: Unable to execute query: /* via the Rating Object, for each thing in a batch of things residing in the current container get the number of approved reviews (that were lodged in that container) */ SELECT Review.thing_id AS thing_id, Review.id AS review_id, AVG(RatingValue.rating) AS average_rating FROM rf_Review AS Review, rf_RatingValue AS RatingValue, rf_Rating AS Rating, rf_Member AS Member WHERE Review.thing_id IN ( ?,?,?,?,?,?,? ) /* reviews for the things */ AND Review.thing_type = 'supplier' AND Review.author_id = Member.id /* reviewer MUST exist */ AND Review.is_approved = 'Yes' /* only approved reviews */ AND Rating.id = Review.rating_id AND RatingValue.rating_id = Review.rating_id AND RatingValue.ratingtype_id IN ( ?,?,? ) AND RatingValue.rating > 0 GROUP BY thing_id, review_id HAVING average_rating > 0 /* with non-null filtered rating */ Reason: Lost connection to MySQL server during query. STACK: Error::throw STACK: RM::Base::throw /home/humility/public_html/cgi-bin/produce/_lib/RM/Base.pm:452 STACK: RM::DB::Base::do_query /home/humility/public_html/cgi-bin/produce/_lib/RM/DB/Base.pm:347 STACK: Foundry::Thing::Rating::total_reviews /home/humility/public_html/cgi-bin/produce/_lib/RM/DB/Base.pm:255 STACK: Foundry::Find::show_things /home/humility/public_html/cgi-bin/produce/reviews/do/admin/Foundry/Format/ListThings.pm:618 STACK: Foundry::Find::_init /home/humility/public_html/cgi-bin/produce/reviews/do/admin/Foundry/Find.pm:319 STACK: Foundry::Find::handler /home/humility/public_html/cgi-bin/produce/reviews/do/admin/Foundry/Find.pm:43 STACK: Foundry::_init /home/humility/public_html/cgi-bin/produce/reviews/do/admin/Foundry.pm:164 STACK: Foundry::handle /home/humility/public_html/cgi-bin/produce/reviews/do/admin/Foundry.pm:47 --------------------------------------------------------------