Index: openacs-4/packages/forums/lib/search/search-chunk-oracle.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/forums/lib/search/search-chunk-oracle.xql,v diff -u -r1.3 -r1.4 --- openacs-4/packages/forums/lib/search/search-chunk-oracle.xql 7 Aug 2017 23:48:11 -0000 1.3 +++ openacs-4/packages/forums/lib/search/search-chunk-oracle.xql 27 Jan 2018 17:01:38 -0000 1.4 @@ -38,39 +38,4 @@ </querytext> </fullquery> - <fullquery name="search_all_forums_intermedia"> - <querytext> - select forums_messages.*, - person.name(forums_messages.user_id) as user_name, - to_char(forums_messages.posting_date, 'YYYY-MM-DD HH24:MI:SS') as posting_date_ansi, - score(1) as the_score - from forums_messages, - forums_forums - where forums_messages.forum_id = forums_forums.forum_id - and forums_forums.package_id = :package_id - and forums_messages.state = 'approved' - and contains(forums_messages.content, :search_pattern , 1) > 0 - order by the_score desc, - forums_messages.posting_date desc - </querytext> - </fullquery> - - <fullquery name="search_one_forum_intermedia"> - <querytext> - select forums_messages.*, - person.name(forums_messages.user_id) as user_name, - to_char(forums_messages.posting_date, 'YYYY-MM-DD HH24:MI:SS') as posting_date_ansi, - score(1) as the_score - from forums_messages, - forums_forums - where forums_forums.forum_id = :forum_id - and forums_forums.package_id = :package_id - and forums_messages.forum_id = forums_forums.forum_id - and forums_messages.state = 'approved' - and contains(forums_messages.content, :search_pattern, 1) > 0 - order by the_score desc, - forums_messages.posting_date desc - </querytext> - </fullquery> - </queryset> Index: openacs-4/packages/forums/tcl/messages-procs.tcl =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/forums/tcl/messages-procs.tcl,v diff -u -r1.48 -r1.49 --- openacs-4/packages/forums/tcl/messages-procs.tcl 20 Jan 2018 23:24:43 -0000 1.48 +++ openacs-4/packages/forums/tcl/messages-procs.tcl 27 Jan 2018 17:01:38 -0000 1.49 @@ -201,7 +201,7 @@ set whether a message is HTML or not } { # Straight update to the DB - db_dml update_message_format + db_dml update_message_format {} } ad_proc -public forum::message::get {