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.30 -r1.30.2.1 --- openacs-4/packages/acs-content-repository/sql/oracle/content-create.sql 27 Oct 2014 16:39:06 -0000 1.30 +++ openacs-4/packages/acs-content-repository/sql/oracle/content-create.sql 3 Mar 2017 08:41:40 -0000 1.30.2.1 @@ -767,7 +767,7 @@ from cr_items i where i.item_id = :old.item_id and i.storage_type = 'file' - and r.content is not null; + and :old.filename is not null; end cr_cleanup_cr_files_del_trg; / Index: openacs-4/packages/acs-content-repository/sql/oracle/upgrade/upgrade-5.8.0a1-5.8.0a2.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-content-repository/sql/oracle/upgrade/upgrade-5.8.0a1-5.8.0a2.sql,v diff -u -N -r1.2 -r1.2.2.1 --- openacs-4/packages/acs-content-repository/sql/oracle/upgrade/upgrade-5.8.0a1-5.8.0a2.sql 27 Oct 2014 16:39:06 -0000 1.2 +++ openacs-4/packages/acs-content-repository/sql/oracle/upgrade/upgrade-5.8.0a1-5.8.0a2.sql 3 Mar 2017 08:41:40 -0000 1.2.2.1 @@ -12,7 +12,7 @@ from cr_items i where i.item_id = :old.item_id and i.storage_type = 'file' - and r.content is not null; + and :old.filename is not null; end cr_cleanup_cr_files_del_trg; /