Index: openacs-4/packages/forums/sql/oracle/upgrade/upgrade-1.0.6-1.0.7d.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/forums/sql/oracle/upgrade/upgrade-1.0.6-1.0.7d.sql,v
diff -u -r1.1.2.3 -r1.1.2.4
--- openacs-4/packages/forums/sql/oracle/upgrade/upgrade-1.0.6-1.0.7d.sql	4 Jan 2005 19:31:49 -0000	1.1.2.3
+++ openacs-4/packages/forums/sql/oracle/upgrade/upgrade-1.0.6-1.0.7d.sql	7 Jan 2005 16:48:30 -0000	1.1.2.4
@@ -292,11 +292,13 @@
         update forums_messages
         set approved_reply_count = approved_reply_count - 1,
           reply_count = reply_count - 1
-        where message_id = forums_message.root_message_id(v_cur.message_id);
+        where forum_id = v_cur.forum_id
+          and tree_sortkey = tree.ancestor_key(v_cur.tree_sortkey, 1);
       else
         update forums_messages
         set reply_count = reply_count - 1
-        where message_id = forums_message.root_message_id(v_cur.message_id);
+        where forum_id = v_cur.forum_id
+          and tree_sortkey = tree.ancestor_key(v_cur.tree_sortkey, 1);
       end if;
 
       acs_object.del(message_id);