Actions
Bug #12643
closed
Smart variable/class param free text search throws "no such column: lookup_values.value" error
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 0It appears that the scoped search from lookup keys to values isn't actually joining the tables.
Updated by Tomer Brisker almost 9 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
Updated by Anonymous almost 9 years ago
- Status changed from Ready For Testing to Closed
- % Done changed from 0 to 100
Applied in changeset 0e9b35eb264ebfd7630aca7eba72213c6d5a9fa1.
Updated by Dominic Cleal almost 9 years ago
- Translation missing: en.field_release set to 104
Updated by Dominic Cleal almost 9 years ago
- Has duplicate Bug #13034: SQL error when searching for smart class parameter added
Updated by Dominic Cleal almost 9 years ago
- Has duplicate Bug #13105: Search in Smart Class Parameter yields PGError added
Actions