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 @@
     <implements-subsite-p>f</implements-subsite-p>
     <inherit-templates-p>t</inherit-templates-p>
     
-    <version name="1.6d5" url="http://openacs.org/repository/download/apm/bug-tracker-1.6d5.apm">
+    <version name="1.6d6" url="http://openacs.org/repository/download/apm/bug-tracker-1.6d6.apm">
         <owner url="mailto:lars@collaboraid.biz">Lars Pind</owner>
         <summary>Tracks bugs and features, versions and maintainers, in software projects.</summary>
         <release-date>2011-06-12</release-date>
@@ -18,7 +18,7 @@
         Contains the best of SDM, Bugzilla, FogBUGZ, and bughost.com.</description>
         <maturity>0</maturity>
 
-        <provides url="bug-tracker" version="1.6d5"/>
+        <provides url="bug-tracker" version="1.6d6"/>
         <requires url="acs-content-repository" version="5.2.0d2"/>
         <requires url="acs-kernel" version="5.10.0"/>
 	<requires url="acs-templating" version="5.10.0d7"/>
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;