Index: openacs-4/packages/file-storage/www/view/index.vuh
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/file-storage/www/view/index.vuh,v
diff -u -N -r1.10.2.2 -r1.10.2.3
--- openacs-4/packages/file-storage/www/view/index.vuh	5 Oct 2021 10:06:46 -0000	1.10.2.2
+++ openacs-4/packages/file-storage/www/view/index.vuh	5 Oct 2021 10:09:33 -0000	1.10.2.3
@@ -42,7 +42,19 @@
         # THIS CODE ONLY TAKES TWO FOLDERS INTO ACCOUNT. THIS NEEDS TO BE FIXED LATER
         set item_url_folder [lindex $splitted_url end-1]
         set item_url_parent_folder [lindex $splitted_url end-2]
-        set file_id [db_string upgraded_item_id {} -default 0]
+        set file_id [db_string upgraded_item_id {
+            select min(i.item_id)
+	    from cr_revisions r, cr_items i
+	    where r.item_id = i.item_id
+	    and r.title = :item_url_title
+	    and i.parent_id in (select item_id
+			       from cr_items
+			       where name = :item_url_folder
+			       and parent_id in (select item_id
+						from cr_items
+						where name = :item_url_parent_folder))
+	    order by revision_id desc
+        } -default 0]
     }
 
     if {$file_id == 0} {