Index: openacs-4/packages/download/www/one-revision-postgresql.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/download/www/one-revision-postgresql.xql,v diff -u -N -r1.3 -r1.4 --- openacs-4/packages/download/www/one-revision-postgresql.xql 16 May 2001 09:41:05 -0000 1.3 +++ openacs-4/packages/download/www/one-revision-postgresql.xql 16 Oct 2017 07:20:08 -0000 1.4 @@ -20,19 +20,19 @@ dar.file_size / 1024 as file_size, (select count(*) from download_downloads where revision_id = dar.revision_id) as downloads, dar.approved_p, - u.last_name || ', ' || u.first_names as creation_user_name, + p.last_name || ', ' || p.first_names as creation_user_name, dar.creation_user, dar.creation_date $metadata_selects from download_archives_obj da, download_archive_types dat, download_arch_revisions_obj dar, - cc_users u + persons p where da.repository_id = :repository_id and dat.archive_type_id = da.archive_type_id and da.archive_id = dar.archive_id and dar.revision_id = :revision_id and - dar.creation_user = u.user_id + dar.creation_user = p.user_id