Red Hat Bugzilla – Bug 505362
Errata search, advanced errata search by package name is not returning results
Last modified: 2009-09-10 15:32:43 EDT
Description of problem:
6/5.1 rhel 5
1. confirm that there are errata that contain the pkg kernel
2. errata, advanced search, by package name, search for kernel
no results found..
erratum listed that have the pkg kernel
This is fixed with the below commit.
Author: John Matthews <firstname.lastname@example.org>
Date: Wed Jun 10 16:04:12 2009 -0400
The issue was that in 6/5.1 ISO I changed the query to flesh out Errata to filter based on org_id, I didn't handle org_id being NULL For Red Hat channels, so I dropped all of those results from the query....this wasn't picked up during testing since I had clones of all the rhel channels I ended up testing with cloned errata.
@@ -155,12 +155,16 @@ PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
from rhnErrata e,
- rhnPackageName pn
+ rhnPackageName pn,
+ rhnAvailableChannels ac,
+ rhnChannelErrata ce
where e.id = ep.errata_id
and p.id = ep.package_id
and p.name_id = pn.id
and ep.package_id IN (:pids)
- and e.org_id IN (:org_ids)
+ and e.id = ce.errata_id
+ and ce.channel_id = ac.channel_id
+ and ac.org_id = :org_id
order by e.id]]>
<return-scalar column="id" type="long" />
<return-scalar column="advisory" type="string" />
An advisory has been issued which should help the problem
described in this bug report. This report is therefore being
closed with a resolution of ERRATA. For more information
on therefore solution and/or where to find the updated files,
please follow the link below. You may reopen this bug report
if the solution does not work for you.