Index: openacs-4/packages/edit-this-page/sql/postgresql/upgrade/upgrade-1.1d-1.2b.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/edit-this-page/sql/postgresql/upgrade/Attic/upgrade-1.1d-1.2b.sql,v
diff -u -r1.1.2.5 -r1.1.2.6
--- openacs-4/packages/edit-this-page/sql/postgresql/upgrade/upgrade-1.1d-1.2b.sql	5 Feb 2003 02:57:54 -0000	1.1.2.5
+++ openacs-4/packages/edit-this-page/sql/postgresql/upgrade/upgrade-1.1d-1.2b.sql	5 Feb 2003 03:20:58 -0000	1.1.2.6
@@ -17,7 +17,7 @@
 -- this is untested DAVEB
 update acs_objects set object_type='etp_page_revision'
     where exists
-	(select 1 from cr_revisions cr, cr_items cr
+	(select 1 from cr_revisions cr, cr_items ci
 	 where cr.item_id=ci.item_id
 	 and ci.content_type='etp_page_revision'
 	 and cr.revision_id=object_id);