Index: openacs-4/packages/acs-content-repository/sql/oracle/content-create.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-content-repository/sql/oracle/content-create.sql,v diff -u -N -r1.29 -r1.29.4.1 --- openacs-4/packages/acs-content-repository/sql/oracle/content-create.sql 11 Apr 2011 01:08:27 -0000 1.29 +++ openacs-4/packages/acs-content-repository/sql/oracle/content-create.sql 28 Aug 2013 22:47:12 -0000 1.29.4.1 @@ -766,7 +766,8 @@ ) select :old.filename, i.storage_area_key from cr_items i where i.item_id = :old.item_id - and i.storage_type = 'file'; + and i.storage_type = 'file' + and r.content is not null; end cr_cleanup_cr_files_del_trg; /