Index: openacs-4/packages/bug-tracker/bug-tracker.info
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/bug-tracker/bug-tracker.info,v
diff -u -N -r1.35 -r1.36
--- openacs-4/packages/bug-tracker/bug-tracker.info 26 Jun 2018 19:31:20 -0000 1.35
+++ openacs-4/packages/bug-tracker/bug-tracker.info 1 Jul 2019 08:58:43 -0000 1.36
@@ -9,7 +9,7 @@
f
t
-
+
Lars Pind
Tracks bugs and features, versions and maintainers, in software projects.
2011-06-12
@@ -18,7 +18,7 @@
Contains the best of SDM, Bugzilla, FogBUGZ, and bughost.com.
0
-
+
Index: openacs-4/packages/bug-tracker/sql/postgresql/bug-tracker-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/bug-tracker/sql/postgresql/bug-tracker-create.sql,v
diff -u -N -r1.20 -r1.21
--- openacs-4/packages/bug-tracker/sql/postgresql/bug-tracker-create.sql 17 Aug 2016 11:25:26 -0000 1.20
+++ openacs-4/packages/bug-tracker/sql/postgresql/bug-tracker-create.sql 1 Jul 2019 08:58:43 -0000 1.21
@@ -611,7 +611,9 @@
p_bug_revision_id, -- 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
+ null -- package_id
);
-- insert into the bug-specific revision table
Index: openacs-4/packages/bug-tracker/sql/postgresql/upgrade-1.6d5-1.6d6.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/bug-tracker/sql/postgresql/upgrade-1.6d5-1.6d6.sql,v
diff -u -N
--- /dev/null 1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/bug-tracker/sql/postgresql/upgrade-1.6d5-1.6d6.sql 1 Jul 2019 08:58:43 -0000 1.1
@@ -0,0 +1,70 @@
+--
+-- Replace deprecated call to content_revision__new/11 by call to content_revision__new/13
+--
+
+--
+-- procedure bt_bug_revision__new/12
+--
+CREATE OR REPLACE FUNCTION bt_bug_revision__new(
+ p_bug_revision_id integer,
+ p_bug_id integer,
+ p_component_id integer,
+ p_found_in_version integer,
+ p_fix_for_version integer,
+ p_fixed_in_version integer,
+ p_resolution varchar,
+ p_user_agent varchar,
+ p_summary varchar,
+ p_creation_date timestamptz,
+ p_creation_user integer,
+ p_creation_ip varchar
+) RETURNS int AS $$
+DECLARE
+
+ v_revision_id integer;
+BEGIN
+ -- create the initial revision
+ v_revision_id := content_revision__new(
+ p_summary, -- title
+ null, -- description
+ current_timestamp, -- publish_date
+ null, -- mime_type
+ null, -- nls_language
+ null, -- new_data
+ p_bug_id, -- item_id
+ p_bug_revision_id, -- revision_id
+ p_creation_date, -- creation_date
+ p_creation_user, -- creation_user
+ p_creation_ip, -- creation_ip
+ null, -- content_length
+ null -- package_id
+ );
+
+ -- insert into the bug-specific revision table
+ insert into bt_bug_revisions
+ (bug_revision_id, component_id, resolution, user_agent, found_in_version, fix_for_version, fixed_in_version)
+ values
+ (v_revision_id, p_component_id, p_resolution, p_user_agent, p_found_in_version, p_fix_for_version, p_fixed_in_version);
+
+ -- make this revision live
+ PERFORM content_item__set_live_revision(v_revision_id);
+
+ -- update the cache
+ update bt_bugs
+ set live_revision_id = v_revision_id,
+ summary = p_summary,
+ component_id = p_component_id,
+ resolution = p_resolution,
+ user_agent = p_user_agent,
+ found_in_version = p_found_in_version,
+ fix_for_version = p_fix_for_version,
+ fixed_in_version = p_fixed_in_version
+ where bug_id = p_bug_id;
+
+ -- update the title in acs_objects
+ update acs_objects set title = bt_bug__name(p_bug_id) where object_id = p_bug_id;
+
+ return v_revision_id;
+END;
+
+$$ LANGUAGE plpgsql;