Index: openacs-4/packages/download/sql/postgresql/download-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/download/sql/postgresql/download-create.sql,v
diff -u -N -r1.6 -r1.6.4.1
--- openacs-4/packages/download/sql/postgresql/download-create.sql	17 May 2003 10:28:58 -0000	1.6
+++ openacs-4/packages/download/sql/postgresql/download-create.sql	2 Nov 2005 01:24:36 -0000	1.6.4.1
@@ -321,6 +321,7 @@
 			 i.item_id = o.object_id and
              r.revision_id = i.live_revision;
 
+
 create view download_archives_obj as
        select cri.parent_id as repository_id, 
 			  cri.name as archive_name, 
@@ -329,14 +330,15 @@
               da.archive_id, 
 			  da.archive_type_id, 
 			  da.archive_desc_id,
-              desc_item.title as summary, 
-			  desc_item.description as description, 
-			  desc_item.mime_type as description_type,
-              desc_item.creation_user, 
-			  desc_item.creation_date, 
-			  desc_item.creation_ip 
-       from download_archives da, cr_items cri, download_archive_descsi desc_item
-	   where da.archive_desc_id = desc_item.revision_id and 
+              crr.title as summary, 
+			  crr.description as description, 
+			  crr.mime_type as description_type,
+              o.creation_user, 
+			  o.creation_date, 
+			  o.creation_ip 
+       from download_archives da, cr_items cri, cr_revisions crr, acs_objects o
+	   where da.archive_desc_id = crr.revision_id and 
+                         da.archive_desc_id = o.object_id and
 			 da.archive_id = cri.item_id;
 
 create view download_arch_revisions_obj as
