Project

General

Profile

Actions

Bug #18955

closed

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

Added by Kobi Hakimi about 7 years ago. Updated about 7 years ago.

Status:
Duplicate
Priority:
High
Assignee:
-
Category:
-
Target version:
-
Difficulty:
Triaged:
Fixed in Releases:
Found in Releases:

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.


Files

Selection_072.png View Selection_072.png 14.7 KB Search text box of Provisioning Template page Kobi Hakimi, 03/19/2017 09:33 AM
Selection_073.png View Selection_073.png 24.3 KB Actual Error page Kobi Hakimi, 03/19/2017 09:33 AM

Related issues 1 (0 open1 closed)

Is duplicate of Foreman - Bug #15498: Search for templates in org/location results in "invalid reference to FROM-clause entry for table "hostgroups""ClosedMarek Hulán06/22/2016Actions
Actions #1

Updated by Ori Rabin about 7 years ago

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

Updated by Ori Rabin about 7 years ago

  • Status changed from New to Duplicate
Actions

Also available in: Atom PDF