Index: openacs-4/packages/forums/sql/oracle/forums-messages-package-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/forums/sql/oracle/forums-messages-package-create.sql,v
diff -u -r1.10.2.1 -r1.10.2.2
--- openacs-4/packages/forums/sql/oracle/forums-messages-package-create.sql	2 Jan 2006 00:24:30 -0000	1.10.2.1
+++ openacs-4/packages/forums/sql/oracle/forums-messages-package-create.sql	19 Mar 2006 18:53:30 -0000	1.10.2.2
@@ -150,8 +150,8 @@
             update forums_messages
             set approved_reply_count = approved_reply_count + 1,
               reply_count = reply_count + 1,
-              last_poster = user_id,
-              last_child_post = sysdate
+              last_poster = forums_message.new.user_id,
+              last_child_post = forums_message.new.posting_date
             where forum_id = forums_message.new.forum_id
               and tree_sortkey = tree.ancestor_key(v_sortkey, 1);
           else
Index: openacs-4/packages/forums/sql/oracle/upgrade/upgrade-1.2d1-1.2d2.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/forums/sql/oracle/upgrade/upgrade-1.2d1-1.2d2.sql,v
diff -u -r1.1.2.2 -r1.1.2.3
--- openacs-4/packages/forums/sql/oracle/upgrade/upgrade-1.2d1-1.2d2.sql	16 Mar 2006 12:23:23 -0000	1.1.2.2
+++ openacs-4/packages/forums/sql/oracle/upgrade/upgrade-1.2d1-1.2d2.sql	19 Mar 2006 18:53:31 -0000	1.1.2.3
@@ -174,8 +174,8 @@
             update forums_messages
             set approved_reply_count = approved_reply_count + 1,
               reply_count = reply_count + 1,
-              last_poster = user_id,
-              last_child_post = sysdate
+              last_poster = forums_message.new.user_id,
+              last_child_post = forums_message.new.posting_date
             where forum_id = forums_message.new.forum_id
               and tree_sortkey = tree.ancestor_key(v_sortkey, 1);
           else