Project

General

Profile

Actions

Bug #12643

closed

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

Added by Dominic Cleal over 8 years ago. Updated over 5 years ago.

Status:
Closed
Priority:
Normal
Assignee:
Category:
Search
Target version:
Difficulty:
Triaged:
Fixed in Releases:
Found in Releases:

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 open2 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 #1

Updated by Tomer Brisker over 8 years ago

  • Status changed from New to Ready For Testing
  • Assignee set to Tomer Brisker
  • Pull request https://github.com/theforeman/foreman/pull/2958 added
Actions #2

Updated by Anonymous over 8 years ago

  • Status changed from Ready For Testing to Closed
  • % Done changed from 0 to 100
Actions #3

Updated by Dominic Cleal over 8 years ago

  • translation missing: en.field_release set to 104
Actions #4

Updated by Dominic Cleal about 8 years ago

  • Has duplicate Bug #13034: SQL error when searching for smart class parameter added
Actions #5

Updated by Dominic Cleal about 8 years ago

  • Has duplicate Bug #13105: Search in Smart Class Parameter yields PGError added
Actions

Also available in: Atom PDF