Index: openacs-4/packages/acs-subsite/tcl/package-procs-oracle.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-subsite/tcl/package-procs-oracle.xql,v diff -u -r1.16 -r1.17 --- openacs-4/packages/acs-subsite/tcl/package-procs-oracle.xql 20 Nov 2017 15:19:27 -0000 1.16 +++ openacs-4/packages/acs-subsite/tcl/package-procs-oracle.xql 14 Jun 2018 15:05:17 -0000 1.17 @@ -75,17 +75,6 @@ - - - - select acs_object.name(:user_id) as author, - sysdate as creation_date - from dual - - - - - Index: openacs-4/packages/acs-subsite/tcl/package-procs-postgresql.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-subsite/tcl/package-procs-postgresql.xql,v diff -u -r1.22 -r1.23 --- openacs-4/packages/acs-subsite/tcl/package-procs-postgresql.xql 20 Nov 2017 15:19:27 -0000 1.22 +++ openacs-4/packages/acs-subsite/tcl/package-procs-postgresql.xql 14 Jun 2018 15:05:17 -0000 1.23 @@ -74,17 +74,6 @@ - - - - select acs_object__name(:user_id) as author, - current_timestamp as creation_date - - - - - - Index: openacs-4/packages/acs-subsite/tcl/package-procs.tcl =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-subsite/tcl/package-procs.tcl,v diff -u -r1.37 -r1.38 --- openacs-4/packages/acs-subsite/tcl/package-procs.tcl 17 May 2018 14:17:35 -0000 1.37 +++ openacs-4/packages/acs-subsite/tcl/package-procs.tcl 14 Jun 2018 15:05:17 -0000 1.38 @@ -519,16 +519,10 @@ @creation-date 12/29/2000 } { - if { [ad_conn isconnected] } { - set user_id [ad_conn user_id] - db_1row select_comments {} - } else { - db_1row select_author_unknown { - select 'Unknown' as author, - sysdate as creation_date - from dual - } - } + set author [expr {[ad_conn isconnected] ? + [acs_user::get_element -element name] : "Unknown"}] + set creation_date [db_string current_timestamp { + select current_timestamp from dual}] return " --/** THIS IS AN AUTO GENERATED PACKAGE. $author was the -- user who created it