Index: openacs-4/packages/acs-content-repository/sql/postgresql/upgrade/upgrade-5.3.0b1-5.3.0b2.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-content-repository/sql/postgresql/upgrade/upgrade-5.3.0b1-5.3.0b2.sql,v diff -u -r1.1.2.1 -r1.1.2.2 --- openacs-4/packages/acs-content-repository/sql/postgresql/upgrade/upgrade-5.3.0b1-5.3.0b2.sql 3 Jan 2007 21:00:29 -0000 1.1.2.1 +++ openacs-4/packages/acs-content-repository/sql/postgresql/upgrade/upgrade-5.3.0b1-5.3.0b2.sql 3 Jan 2007 21:06:24 -0000 1.1.2.2 @@ -6,4 +6,4 @@ -- @cvs-id $Id$ -- -update cr_revisions set content = '@text;noquote@' where revision_id = (select template_id from cr_type_template_map where content_type = 'content_revision' and use_context = 'public' and is_default = 't'); +update cr_revisions set content = '@text;noquote@' where revision_id = (select live_revision from cr_items ci, cr_type_template_map cm where cm.content_type = 'content_revision' and cm.use_context = 'public' and cm.is_default = 't' and ci.item_id=cm.template_id); \ No newline at end of file