Bug #18955

The search of "Hosts > Provisioning Templates" raised Error Page

Added by Kobi Hakimi over 1 year ago. Updated over 1 year ago.

Status:Duplicate
Priority:High
Assignee:-
Category:-
Target version:-
Difficulty: Team Backlog:
Triaged: Fixed in Releases:
Bugzilla link: Found in Releases:1.12.4
Pull request:

Description

Detected on Foreman Version: 1.12.4

Scenario:
1. Open the Foreman in "Hosts > Provisioning Templates"
2. Type some word in the search text box(see attached screenshot)

Actual Result:
Get the following Error(as you can see in the attached screenshot)
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"

Expected Result:
Get search result without any error.

Selection_072.png - Search text box of Provisioning Template page (14.7 KB) Preview Kobi Hakimi, 03/19/2017 09:33 AM

Selection_073.png - Actual Error page (24.3 KB) Preview Kobi Hakimi, 03/19/2017 09:33 AM

Selection_072 Selection_073

Related issues

Duplicates Foreman - Bug #15498: Search for templates in org/location results in "invalid ... Closed 06/22/2016

History

#1 Updated by Ori Rabin over 1 year ago

  • Duplicates Bug #15498: Search for templates in org/location results in "invalid reference to FROM-clause entry for table "hostgroups"" added

#2 Updated by Ori Rabin over 1 year ago

  • Status changed from New to Duplicate

Also available in: Atom PDF