Index: openacs-4/packages/news/news.info
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/news/news.info,v
diff -u -N -r1.32.2.5 -r1.32.2.6
--- openacs-4/packages/news/news.info	1 Dec 2015 13:56:11 -0000	1.32.2.5
+++ openacs-4/packages/news/news.info	11 Aug 2016 12:56:05 -0000	1.32.2.6
@@ -7,7 +7,7 @@
     <initial-install-p>f</initial-install-p>
     <singleton-p>f</singleton-p>
     
-    <version name="5.9.0" url="http://openacs.org/repository/download/apm/news-5.9.0.apm">
+    <version name="5.9.1d1" url="http://openacs.org/repository/download/apm/news-5.9.1d1.apm">
         <owner url="http://opeancs.org">OpenACS</owner>
         <summary>Used for announcements and news items.</summary>
         <release-date>2015-10-04</release-date>
@@ -16,7 +16,7 @@
         <maturity>2</maturity>
         <package_instance_name>#news.News#</package_instance_name>
 
-        <provides url="news" version="5.9.0"/>
+        <provides url="news" version="5.9.1d1"/>
         <requires url="acs-content-repository" version="5.9.0"/>
         <requires url="acs-datetime" version="5.9.0"/>
         <requires url="acs-kernel" version="5.9.0"/>
Index: openacs-4/packages/news/sql/postgresql/upgrade/upgrade-5.9.0-5.9.1d1.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/news/sql/postgresql/upgrade/upgrade-5.9.0-5.9.1d1.sql,v
diff -u -N
--- /dev/null	1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/news/sql/postgresql/upgrade/upgrade-5.9.0-5.9.1d1.sql	11 Aug 2016 12:56:05 -0000	1.1.2.1
@@ -0,0 +1,15 @@
+--
+-- Cleanup cr_revisions belonging to the news package, for which there
+-- are no news_id in cr_news. These entries were created since ever in
+-- the news package. The bug adding spurious revisions was fixed with
+-- the OpenACS 5.9.0 release, this upgrade scripts removes leftovers.
+--
+select revision_id, content_revision__delete(revision_id) from 
+  (select revision_id from cr_revisions where item_id in (
+     -- return item_ids for news entries
+     select distinct item_id
+     from cr_revisions cr, acs_objects o
+     where o.object_id = cr.revision_id and o.object_type = 'news'
+   ) except select news_id from cr_news) dead_revisions;
+
+
Index: openacs-4/packages/news/sql/postgresql/upgrade/upgrade-5.9.0d2-5.9.0d3.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/news/sql/postgresql/upgrade/upgrade-5.9.0d2-5.9.0d3.sql,v
diff -u -N
--- /dev/null	1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/news/sql/postgresql/upgrade/upgrade-5.9.0d2-5.9.0d3.sql	11 Aug 2016 12:56:05 -0000	1.1.2.1
@@ -0,0 +1,11 @@
+select define_function_args('news__new','item_id;null,locale;null,publish_date;null,text;null,nls_language;null,title;null,mime_type;text/plain,package_id;null,archive_date;null,approval_user;null,approval_date;null,approval_ip;null,relation_tag;null,creation_ip;null,creation_user;null,is_live_p;f,lead');
+select define_function_args('news__delete','item_id');
+select define_function_args('news__make_permanent','item_id');
+select define_function_args('news__archive','item_id,archive_date;current_timestamp');
+select define_function_args('news__set_approve','revision_id,approve_p;t,publish_date;null,archive_date;null,approval_user;null,approval_date;current_timestamp,approval_ip;null,live_revision_p;t');
+select define_function_args('news__status','publish_date,archive_date');
+select define_function_args('news__name','news_id');
+select define_function_args('news__revision_new','item_id,publish_date;null,text;null,title,description,mime_type;text/plain,package_id;null,archive_date;null,approval_user;null,approval_date;null,approval_ip;null,creation_date;current_timestamp,creation_ip;null,creation_user;null,make_active_revision_p;f,lead');
+select define_function_args('news__revision_set_active','revision_id');
+select define_function_args('news__clone','old_package_id,new_package_id');
+select define_function_args('news__revision_delete','revision_id');