Index: openacs-4/packages/forums/www/moderate/move-thread-postgresql.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/forums/www/moderate/move-thread-postgresql.xql,v diff -u -r1.3 -r1.3.2.1 --- openacs-4/packages/forums/www/moderate/move-thread-postgresql.xql 13 Nov 2017 15:22:26 -0000 1.3 +++ openacs-4/packages/forums/www/moderate/move-thread-postgresql.xql 23 Oct 2020 17:03:05 -0000 1.3.2.1 @@ -35,9 +35,9 @@ update forums_messages set last_child_post = (select max(last_child_post) from forums_messages - where forum_id = :forum_id and tree_sortkey between tree_left((select tree_sortkey from forums_messages where message_id = $father_message_id)) and tree_right((select tree_sortkey from forums_messages where message_id = $father_message_id)) + where forum_id = :forum_id and tree_sortkey between tree_left((select tree_sortkey from forums_messages where message_id = :father_message_id)) and tree_right((select tree_sortkey from forums_messages where message_id = :father_message_id)) ) - where message_id = $father_message_id + where message_id = :father_message_id