Index: openacs-4/packages/evaluation/www/admin/grades/grades-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/evaluation/www/admin/grades/grades-postgresql.xql,v
diff -u -r1.5 -r1.6
--- openacs-4/packages/evaluation/www/admin/grades/grades-postgresql.xql	17 Aug 2004 17:44:02 -0000	1.5
+++ openacs-4/packages/evaluation/www/admin/grades/grades-postgresql.xql	18 Aug 2004 17:07:10 -0000	1.6
@@ -23,10 +23,11 @@
 <fullquery name="get_total_weight">      
       <querytext>
 
-		select coalesce(sum(weight),0) as total_weight
-		from evaluation_gradesi
-		where content_revision__is_live(grade_id) = true
-		  and context_id = :package_id
+	select coalesce(sum(eg.weight),0) as total_weight
+	from evaluation_gradesi eg, acs_objects ao
+	where content_revision__is_live(eg.grade_id) = true
+	  and ao.context_id = :package_id
+ 	  and eg.item_id = ao.object_id
 
       </querytext>
 </fullquery>