Bug #968
closedcannot search a puppetclass by name
Description
I've just updated my environment to version 0.3
Is am having trouble searching by puppetclass name under Settings > Puppetclass
I am getting:
Processing PuppetclassesController#index (for x.x.x.x at 2011-06-08 14:55:18) [GET]
Parameters: {"search"=>"role_"}
ActiveRecord::StatementInvalid (Mysql::Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') ORDER BY LOWER LIMIT 0, 20' at line 1: SELECT DISTINCT `puppetclasses`.id FROM `puppetclasses` LEFT OUTER JOIN `environments_puppetclasses` ON `environments_puppetclasses`.puppetclass_id = `puppetclasses`.id LEFT OUTER JOIN `environments` ON `environments`.id = `environments_puppetclasses`.environment_id LEFT OUTER JOIN `hostgroups_puppetclasses` ON `hostgroups_puppetclasses`.puppetclass_id = `puppetclasses`.id LEFT OUTER JOIN `hostgroups` ON `hostgroups`.id = `hostgroups_puppetclasses`.hostgroup_id WHERE (`puppetclasses`.`name` LIKE '%role_%' OR `environments`.`name` LIKE '%role_%' OR `hostgroups`.`name` LIKE '%role_%' OR ) ORDER BY LOWER LIMIT 0, 20):
app/controllers/puppetclasses_controller.rb:18:in `index'
app/controllers/puppetclasses_controller.rb:16:in `index'
Updated by Ohad Levy over 13 years ago
- Category set to Search
- Assignee set to Amos Benari
- Target version set to 0.4
Updated by Ohad Levy over 13 years ago
- Assignee changed from Amos Benari to Ohad Levy
Updated by Ohad Levy over 13 years ago
- Status changed from New to Closed
- % Done changed from 0 to 100
Applied in changeset 7d46a25efe698cd083c8a5fe9c4e6444c698c5ec.
Updated by Gustavo Soares over 13 years ago
sorry for the late reply...
I've applied the patch to the downloaded 0.3 version and it seems that the search by name in puppetclass is not working.
Am I missing something?
Cheers