web/modules/rhn/RHN/DB/DataSource/xml/Errata_queries.xml | 4 ++++ 1 file changed, 4 insertions(+)
New commits: commit 1636e1a9cf90da8b946a25782313f2cd48c8b4e6 Author: Justin Sherrill jsherril@redhat.com Date: Fri Sep 10 14:32:51 2010 -0400
591899 - fixing error where cloning an already cloned channel would still result in errata showing up on the clone tab when managing it
diff --git a/web/modules/rhn/RHN/DB/DataSource/xml/Errata_queries.xml b/web/modules/rhn/RHN/DB/DataSource/xml/Errata_queries.xml index 9a5c9a9..4a8621c 100644 --- a/web/modules/rhn/RHN/DB/DataSource/xml/Errata_queries.xml +++ b/web/modules/rhn/RHN/DB/DataSource/xml/Errata_queries.xml @@ -191,6 +191,10 @@ SELECT DISTINCT E.id, E.update_date, E.advisory_name, E.advisory_type, E.synopsi WHERE CE2.channel_id = :cid_2 AND EC.original_id = CE.errata_id AND EC.id = CE2.errata_id) + AND NOT EXISTS (select 1 + from rhnChannelErrata CE3 + where CE3.channel_id = :cid_2 + AND CE3.errata_id = E.id) ORDER BY E.update_date, E.id </query> <elaborator name="errata_overview" />
spacewalk-commits@lists.fedorahosted.org