Project

General

Profile

Actions
Copy link

Bug #12643

closed

Smart variable/class param free text search throws "no such column: lookup_values.value" error

Added by Dominic Cleal almost 9 years ago. Updated over 6 years ago.

Status:
Closed
Priority:
Normal
Assignee:
Tomer Brisker
Category:
Search
Target version:
1.10.1
Difficulty:
Triaged:
Bugzilla link:
Pull request:
https://github.com/theforeman/foreman/pull/2958
Fixed in Releases:
Found in Releases:
Red Hat JIRA:

Description

When on the smart variables or smart class parameters index pages, entering any free text search fails with the following error:

SQLite3::SQLException: no such column: lookup_values.value: SELECT  "lookup_keys"."puppetclass_id" FROM "lookup_keys"  WHERE "lookup_keys"."type" IN ('VariableLookupKey') AND (("lookup_keys"."key" LIKE '%test%' OR "lookup_values"."value" LIKE '%test%' OR "puppetclasses"."name" LIKE '%test%')) ORDER BY "lookup_keys"."key" ASC LIMIT 40 OFFSET 0

It appears that the scoped search from lookup keys to values isn't actually joining the tables.

Related issues 2 (0 open — 2 closed)

Has duplicate Foreman - Bug #13034: SQL error when searching for smart class parameterDuplicate01/07/2016Actions
Has duplicate Foreman - Bug #13105: Search in Smart Class Parameter yields PGErrorDuplicate01/11/2016Actions
Actions
Copy link

Also available in: Atom PDF