Bug 1316649

Summary: search in content hosts throws PG::Error: ERROR: syntax error at or near "OR"
Product: Red Hat Satellite Reporter: Tom McKay <tomckay>
Component: WebUIAssignee: Justin Sherrill <jsherril>
Status: CLOSED ERRATA QA Contact: Jitendra Yejare <jyejare>
Severity: high Docs Contact:
Priority: unspecified    
Version: 6.2.0CC: bbuckingham, bkearney, jsherril, jyejare, sthirugn, tomckay
Target Milestone: UnspecifiedKeywords: Triaged
Target Release: Unused   
Hardware: Unspecified   
OS: Unspecified   
URL: http://projects.theforeman.org/issues/14144
Whiteboard:
Fixed In Version: Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2016-07-27 09:05:47 UTC Type: ---
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: --- RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: --- Target Upstream Version:
Embargoed:
Attachments:
Description Flags
[Verified] Screenshot Attached
none
[Verified] Screenshot Attached none

Description Tom McKay 2016-03-10 16:40:40 UTC
Attempting to search with a value of "virtual" throws an error. Using autocomplete search works, it's just he free form text search that errors.

Comment 1 Tom McKay 2016-03-10 16:40:42 UTC
Created from redmine issue http://projects.theforeman.org/issues/14144

Comment 3 Bryan Kearney 2016-03-10 19:09:31 UTC
Upstream bug component is WebUI

Comment 4 Bryan Kearney 2016-03-10 21:09:32 UTC
Moving to POST since upstream bug http://projects.theforeman.org/issues/14144 has been closed
-------------
Justin Sherrill
Applied in changeset commit:katello|ab0b78492bdb758cf9d11eb893ba59c9e9759033.

Comment 6 Jitendra Yejare 2016-04-01 10:05:09 UTC
@Tom: May I know the repro steps for this bug.

Comment 7 Jitendra Yejare 2016-04-01 14:07:26 UTC
Created attachment 1142574 [details]
[Verified] Screenshot Attached

Comment 8 Jitendra Yejare 2016-04-01 14:07:54 UTC
Created attachment 1142575 [details]
[Verified] Screenshot Attached

Comment 9 Jitendra Yejare 2016-04-01 14:08:09 UTC
Verified this bug in Sat 6.2 snap 6.

I see that the scoped searching the content-host/host actually doesnt throws an error mentioned in description.

The issue is no more reproducible and hence moving to verified.

Verified screenshot attached.

Comment 11 errata-xmlrpc 2016-07-27 09:05:47 UTC
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/RHBA-2016:1500