Index: openacs-4/packages/news/sql/postgresql/upgrade/upgrade-5.2.0d1-5.2.0d2.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/news/sql/postgresql/upgrade/upgrade-5.2.0d1-5.2.0d2.sql,v
diff -u -N -r1.1 -r1.1.2.1
--- openacs-4/packages/news/sql/postgresql/upgrade/upgrade-5.2.0d1-5.2.0d2.sql	24 Feb 2005 18:03:04 -0000	1.1
+++ openacs-4/packages/news/sql/postgresql/upgrade/upgrade-5.2.0d1-5.2.0d2.sql	7 Aug 2005 01:51:44 -0000	1.1.2.1
@@ -362,7 +362,7 @@
     ci.item_id as item_id,
     cn.package_id as package_id,
     revision_id,        
-    title as publish_title,
+    cr.title as publish_title,
     cn.lead as publish_lead,
     cr.content as publish_body,
     (case when cr.mime_type = 'text/html' then 't' else 'f' end) as html_p,
