Bug 1385882 - Host search page throws SQL error from simple searches
Summary: Host search page throws SQL error from simple searches
Keywords:
Status: CLOSED DUPLICATE of bug 1372757
Alias: None
Product: Red Hat Satellite
Classification: Red Hat
Component: Hosts
Version: 6.2.1
Hardware: x86_64
OS: Linux
unspecified
medium
Target Milestone: Unspecified
Assignee: satellite6-bugs
QA Contact:
URL:
Whiteboard:
Depends On:
Blocks:
TreeView+ depends on / blocked
 
Reported: 2016-10-17 20:47 UTC by Calvin Hartwell
Modified: 2020-03-11 15:18 UTC (History)
5 users (show)

Fixed In Version:
Doc Type: If docs needed, set a value
Doc Text:
Clone Of:
Environment:
Last Closed: 2016-12-06 13:35:07 UTC
Target Upstream Version:
Embargoed:


Attachments (Terms of Use)

Description Calvin Hartwell 2016-10-17 20:47:30 UTC
Description of problem:

The search field on the host page throws a SQL exception when typing in a simple string. If a correct string is entered, I.E name = somehostname the field works, but otherwise it doesn't. 

For example: https://sat6fqdn/hosts?utf8=%E2%9C%93&search=abc

Throws the exception: 

Oops, we're sorry but something went wrong ERROR: invalid reference to FROM-clause entry for table "smart_proxies" LINE 1: SELECT smart_proxies.id FROM "smart_proxies" "puppet_ca_prox... ^ HINT: Perhaps you meant to reference the table alias "puppet_ca_proxies_hosts".

Version-Release number of selected component (if applicable):

6.2.1

How reproducible:

100% reproducible 

Steps to Reproduce:
1. Go to hosts page
2. Put in search term
3. Throws exception

Actual results:

Search by throws an exception

Expected results:

Search should not throw an exception but should give an empty search result or warning. 

Additional info:

Is this even tested?!

Comment 2 Tomer Brisker 2016-12-06 13:35:07 UTC

*** This bug has been marked as a duplicate of bug 1372757 ***


Note You need to log in before you can comment on or make changes to this bug.