schema/spacewalk/oracle/packages/rhn_channel.pkb | 6 +++---
1 file changed, 3 insertions(+), 3 deletions(-)
New commits:
commit ff2714abbe25734d6259e1f9d14a7e67667cb808
Author: Milan Zazrivec <mzazrivec(a)redhat.com>
Date: Tue Jul 27 12:31:34 2010 +0200
618219 - use last_channel_org_id in update_family_counts
This is to avoid schema population error: PLS-00201: identifier
'CHANNEL.ORG_ID' must be declared
diff --git a/schema/spacewalk/oracle/packages/rhn_channel.pkb
b/schema/spacewalk/oracle/packages/rhn_channel.pkb
index 75b72ee..944ae06 100644
--- a/schema/spacewalk/oracle/packages/rhn_channel.pkb
+++ b/schema/spacewalk/oracle/packages/rhn_channel.pkb
@@ -446,7 +446,7 @@ IS
end loop channel;
if update_family_countsYN > 0 and last_channel_family_id != -1 then
-- update the last family fetched
- update_family_counts(last_channel_family_id, channel.org_id);
+ update_family_counts(last_channel_family_id, last_channel_org_id);
end if;
END clear_subscriptions;
commit 9a3dc0641c5299f605290867d7263c9b946398c9
Author: Milan Zazrivec <mzazrivec(a)redhat.com>
Date: Tue Jul 27 12:17:22 2010 +0200
618219 - if expects an expression
This is to avoid population errors: PLS-00382: expression is of wrong type
diff --git a/schema/spacewalk/oracle/packages/rhn_channel.pkb
b/schema/spacewalk/oracle/packages/rhn_channel.pkb
index b4046bf..75b72ee 100644
--- a/schema/spacewalk/oracle/packages/rhn_channel.pkb
+++ b/schema/spacewalk/oracle/packages/rhn_channel.pkb
@@ -435,7 +435,7 @@ IS
for channel in server_channels(server_id_in)
loop
unsubscribe_server(server_id_in, channel.channel_id, 1, 1,
deleting_server, 0);
- if update_family_countsYN
+ if update_family_countsYN > 0
and channel.channel_family_id != last_channel_family_id then
-- update family counts only once
-- after all channels with same family has been fetched
@@ -444,7 +444,7 @@ IS
last_channel_org_id := channel.org_id;
end if;
end loop channel;
- if update_family_countsYN and last_channel_family_id != -1 then
+ if update_family_countsYN > 0 and last_channel_family_id != -1 then
-- update the last family fetched
update_family_counts(last_channel_family_id, channel.org_id);
end if;
Show replies by thread