Bug 1316649 - search in content hosts throws PG::Error: ERROR: syntax error at or near "OR"
Summary: search in content hosts throws PG::Error: ERROR: syntax error at or near "OR"
Keywords:
Status: CLOSED ERRATA
Alias: None
Product: Red Hat Satellite
Classification: Red Hat
Component: WebUI
Version: 6.2.0
Hardware: Unspecified
OS: Unspecified
unspecified
high
Target Milestone: Unspecified
Assignee: Justin Sherrill
QA Contact: Jitendra Yejare
URL: http://projects.theforeman.org/issues...
Whiteboard:
Depends On:
Blocks:
TreeView+ depends on / blocked
 
Reported: 2016-03-10 16:40 UTC by Tom McKay
Modified: 2019-09-25 21:29 UTC (History)
6 users (show)

Fixed In Version:
Doc Type: Bug Fix
Doc Text:
Clone Of:
Environment:
Last Closed: 2016-07-27 09:05:47 UTC
Target Upstream Version:
Embargoed:

Attachments (Terms of Use)
[Verified] Screenshot Attached (97.34 KB, image/png)
2016-04-01 14:07 UTC, Jitendra Yejare 		no flags Details
[Verified] Screenshot Attached (92.19 KB, image/png)
2016-04-01 14:07 UTC, Jitendra Yejare 		no flags Details
View All


Links
System ID Private Priority Status Summary Last Updated
Foreman Issue Tracker 14144 0 None None None 2016-04-22 16:01:03 UTC
Red Hat Product Errata RHBA-2016:1500 0 normal SHIPPED_LIVE Red Hat Satellite 6.2 Base Libraries 2016-07-27 12:24:38 UTC

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
Note You need to log in before you can comment on or make changes to this bug.