Bug 1390270

Summary: Error in provisioing templates page
Product: Red Hat Satellite Reporter: Martijn ten Heuvel <mtenheuv>
Component: Provisioning TemplatesAssignee: satellite6-bugs <satellite6-bugs>
Status: CLOSED DUPLICATE QA Contact:
Severity: low Docs Contact:
Priority: unspecified    
Version: 6.2.3CC: bbuckingham, egolov, mhulan
Target Milestone: Unspecified   
Target Release: Unused   
Hardware: x86_64   
OS: Linux   
Whiteboard:
Fixed In Version: Doc Type: If docs needed, set a value
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2016-10-31 18:21:40 UTC Type: Bug
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
Screenshot of error page.
none
snppet of production.log containing error. none

Description Martijn ten Heuvel 2016-10-31 15:22:42 UTC 
Created attachment 1215849 [details]
Screenshot of error page.

Description of problem:
When in provisioing templates page, the page has a search box. If you type some random string there, you get this error:

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

Which has no relation with the provisioing templates.

Version-Release number of selected component (if applicable):
Sat 6.2.3 latest (as per 31-10) and RHEL7.2

How reproducible:
Go to page, fill in something in the box.

Steps to Reproduce:
1. go to page https://$satellite/templates/provisioning_templates
2. fill in some random string.
3. click search

Actual results:
broken page.

Expected results:
an error of not found.
Comment 1 Martijn ten Heuvel 2016-10-31 15:35:35 UTC 
Created attachment 1215856 [details]
snppet of production.log containing error.

logfile production.log
Comment 2 Brad Buckingham 2016-10-31 18:21:40 UTC 

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