Index: openacs-4/packages/file-storage/sql/oracle/upgrade/upgrade-5.1.0d3-5.1.0d4.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/file-storage/sql/oracle/upgrade/upgrade-5.1.0d3-5.1.0d4.sql,v diff -u -r1.1.2.2 -r1.1.2.3 --- openacs-4/packages/file-storage/sql/oracle/upgrade/upgrade-5.1.0d3-5.1.0d4.sql 25 May 2004 17:39:56 -0000 1.1.2.2 +++ openacs-4/packages/file-storage/sql/oracle/upgrade/upgrade-5.1.0d3-5.1.0d4.sql 15 Jun 2004 18:37:58 -0000 1.1.2.3 @@ -40,7 +40,7 @@ when cr_items.content_type = 'content_folder' then 0 else 1 end as sort_key - from cr_items, cr_extlinks, cr_folders, cr_revisions, acs_objects + from cr_items, cr_extlinks, cr_folders, cr_revisions, acs_objects, cr_mime_types where cr_items.item_id = cr_extlinks.extlink_id(+) and cr_items.item_id = cr_folders.folder_id(+) and cr_items.item_id = acs_objects.object_id