Red Hat Bugzilla – Bug 1179462
Search does not work on Content host errata tab
Last modified: 2017-02-23 15:40:39 EST
Description of problem: Search does not work on Content host errata tab Version-Release number of selected component (if applicable): * apr-util-ldap-1.3.9-3.el6_0.1.x86_64 * candlepin-0.9.37-1.el6.noarch * candlepin-common-1.0.17-1.el6.noarch * candlepin-selinux-0.9.37-1.el6.noarch * candlepin-tomcat6-0.9.37-1.el6.noarch * elasticsearch-0.90.10-7.el6.noarch * foreman-1.8.0-0.develop.201501051457git6529247.el6.noarch * foreman-compute-1.8.0-0.develop.201501051457git6529247.el6.noarch * foreman-gce-1.8.0-0.develop.201501051457git6529247.el6.noarch * foreman-libvirt-1.8.0-0.develop.201501051457git6529247.el6.noarch * foreman-ovirt-1.8.0-0.develop.201501051457git6529247.el6.noarch * foreman-postgresql-1.8.0-0.develop.201501051457git6529247.el6.noarch * foreman-proxy-1.8.0-0.develop.201412301259gite2ce2a0.el6.noarch * foreman-release-1.8.0-0.develop.201501051457git6529247.el6.noarch * foreman-selinux-1.8.0-0.develop.201412151103gite2863e4.el6.noarch * foreman-vmware-1.8.0-0.develop.201501051457git6529247.el6.noarch * katello-2.1.0-1.201411061509gitb0b8f43.el6.noarch * katello-certs-tools-2.0.1-1.el6.noarch * katello-default-ca-1.0-1.noarch * katello-installer-2.2.0-1.201412192027git113612b.el6.noarch * katello-installer-base-2.2.0-1.201412192027git113612b.el6.noarch * katello-repos-2.1.1-1.el6.noarch * katello-server-ca-1.0-1.noarch * openldap-2.4.23-32.el6_4.1.x86_64 * openldap-devel-2.4.23-32.el6_4.1.x86_64 * pulp-docker-plugins-0.2.1-0.2.beta.el6.noarch * pulp-katello-0.3-3.el6.noarch * pulp-nodes-common-2.5.1-1.el6.noarch * pulp-nodes-parent-2.5.1-1.el6.noarch * pulp-puppet-plugins-2.5.1-1.el6.noarch * pulp-puppet-tools-2.5.1-1.el6.noarch * pulp-rpm-plugins-2.5.1-1.el6.noarch * pulp-selinux-2.5.1-1.el6.noarch * pulp-server-2.5.1-1.el6.noarch * python-ldap-2.3.10-1.el6.x86_64 * ruby193-rubygem-ldap_fluff-0.3.3-1.el6.noarch * ruby193-rubygem-net-ldap-0.10.0-1.el6.noarch * ruby193-rubygem-runcible-1.3.0-1.el6.noarch How reproducible: Always Steps to Reproduce: 1. Navigate to Web UI -> content host -> Errata tab -> Search 2. I tried searching the following, none of them worked: - rsyslog bug fix update (Note: there is an errata with this title) - title= rsyslog bug fix update - title: rsyslog bug fix update - RHSA-2014:2024 (Note: there is an errata with this id) - Id= RHSA-2014:2024 - Id: RHSA-2014:2024 Actual results: None of the above mentioned search showed results Expected results: The right errata item should be displayed Additional info:
Since this issue was entered in Red Hat Bugzilla, the release flag has been set to ? to ensure that it is properly evaluated for this release.
This works for me if I follow the guided search and search for id = RHSA-2014:1984. However there is a definite bug here, a 500 when searching for just the errata ID: caused by: (PG::InvalidColumnReference) ERROR: for SELECT DISTINCT, ORDER BY expressions must appear in select list LINE 1: ...kages"."name" ILIKE '%RHSA-2014:1984%')) ORDER BY issued DES...
(In reply to Walden Raines from comment #3) Well I don't see guided search working in Content Host -> Errata tab
Connecting redmine issue http://projects.theforeman.org/issues/8326 from this bug
Moving to POST since upstream bug http://projects.theforeman.org/issues/8326 has been closed ------------- Justin Sherrill Applied in changeset commit:katello|6055ee58cb7fc531ace956939c8e059275eaaec2.
Failed. Satellite-6.1.0-RHEL-6-20150224.0
(In reply to sthirugn from comment #9) > Failed. > > Satellite-6.1.0-RHEL-6-20150224.0 I tried the following. These existed in my repo: package = dhcp-4.1.1-43.P1.el6_6.1.x86_64 package_name = dhcp
Created redmine issue http://projects.theforeman.org/issues/9786 from this bug
This should be in POST as the relevant issue is closed: Applied in changeset katello|c063ff97c7882b57bd6330a8e28ae19c2391594e.
*** Bug 1213815 has been marked as a duplicate of this bug. ***
Verified. Version Tested: Satellite-6.1.0-RHEL-6-20150424.0 The following worked fine: cve = "CVE-2005-1080" cve ~ "CVE-2005-1080" id = "RHBA-2015:0871" id ~ "RHBA-2015:0871" issued > "Apr 20,2015" issued < "Apr 20,2015" package = kernel-2.6.32-504.16.2.el6.x86_64 package_name = kernel severity = Critical severity = Important severity = Moderate title ~ dbus title = "dbus bugfix update" type = bugfix type = enhancement type = security updated > "Apr 20,2015" updated < "Apr 20,2015" These did not work and will be tracked in separate bugs: bug ~ "1212986" - https://bugzilla.redhat.com/show_bug.cgi?id=1215758 bug = "1212986" - https://bugzilla.redhat.com/show_bug.cgi?id=1215758 issued = "Apr 20,2015" - https://bugzilla.redhat.com/show_bug.cgi?id=1215756
This bug is slated to be released with Satellite 6.1.
Since the problem described in this bug report should be resolved in a recent advisory, it has been closed with a resolution of ERRATA. For information on the advisory, and where to find the updated files, follow the link below. If the solution does not work for you, open a new bug report. https://access.redhat.com/errata/RHSA-2015:1592