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.7 -r1.32.2.8
--- openacs-4/packages/news/news.info 15 Feb 2017 11:28:50 -0000 1.32.2.7
+++ openacs-4/packages/news/news.info 16 Feb 2017 12:42:52 -0000 1.32.2.8
@@ -7,7 +7,7 @@
f
f
-
+
OpenACS
Used for announcements and news items.
2016-08-11
@@ -16,7 +16,7 @@
2
#news.News#
-
+
Index: openacs-4/packages/news/sql/postgresql/news-package-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/news/sql/postgresql/news-package-create.sql,v
diff -u -N -r1.6.2.1 -r1.6.2.2
--- openacs-4/packages/news/sql/postgresql/news-package-create.sql 25 Sep 2015 08:25:57 -0000 1.6.2.1
+++ openacs-4/packages/news/sql/postgresql/news-package-create.sql 16 Feb 2017 12:42:52 -0000 1.6.2.2
@@ -390,7 +390,9 @@
null, -- revision_id
p_creation_date, -- creation_date
p_creation_user, -- creation_user
- p_creation_ip -- creation_ip
+ p_creation_ip, -- creation_ip
+ null, -- content_length
+ p_package_id -- package_id
);
-- create new news entry with new revision
insert into cr_news
@@ -415,7 +417,6 @@
end if;
return v_revision_id;
END;
-
$$ LANGUAGE plpgsql;
Index: openacs-4/packages/news/sql/postgresql/upgrade/upgrade-5.9.1b1-5.9.1b2.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/news/sql/postgresql/upgrade/upgrade-5.9.1b1-5.9.1b2.sql,v
diff -u -N
--- /dev/null 1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/news/sql/postgresql/upgrade/upgrade-5.9.1b1-5.9.1b2.sql 16 Feb 2017 12:42:52 -0000 1.1.2.1
@@ -0,0 +1,69 @@
+--
+-- Don't call deprecated version of content_revision__new
+--
+
+--
+-- procedure news__revision_new/16
+--
+CREATE OR REPLACE FUNCTION news__revision_new(
+ p_item_id integer,
+ p_publish_date timestamptz, -- default null
+ p_text text, -- default null
+ p_title varchar,
+ p_description text,
+ p_mime_type varchar, -- default 'text/plain'
+ p_package_id integer, -- default null
+ p_archive_date timestamptz, -- default null
+ p_approval_user integer, -- default null
+ p_approval_date timestamptz, -- default null
+ p_approval_ip varchar, -- default null
+ p_creation_date timestamptz, -- default current_timestamp
+ p_creation_ip varchar, -- default null
+ p_creation_user integer, -- default null
+ p_make_active_revision_p boolean, -- default 'f'
+ p_lead varchar
+
+) RETURNS integer AS $$
+DECLARE
+ v_revision_id integer;
+BEGIN
+ -- create revision
+ v_revision_id := content_revision__new(
+ p_title, -- title
+ p_description, -- description
+ p_publish_date, -- publish_date
+ p_mime_type, -- mime_type
+ null, -- nls_language
+ p_text, -- text
+ p_item_id, -- item_id
+ null, -- revision_id
+ p_creation_date, -- creation_date
+ p_creation_user, -- creation_user
+ p_creation_ip, -- creation_ip
+ null, -- content_length
+ p_package_id -- package_id
+ );
+ -- create new news entry with new revision
+ insert into cr_news
+ (news_id,
+ lead,
+ package_id,
+ archive_date,
+ approval_user,
+ approval_date,
+ approval_ip)
+ values
+ (v_revision_id,
+ p_lead,
+ p_package_id,
+ p_archive_date,
+ p_approval_user,
+ p_approval_date,
+ p_approval_ip);
+ -- make active revision if indicated
+ if p_make_active_revision_p = 't' then
+ PERFORM news__revision_set_active(v_revision_id);
+ end if;
+ return v_revision_id;
+END;
+$$ LANGUAGE plpgsql;