Project

General

Profile

Actions

Bug #968

closed

cannot search a puppetclass by name

Added by Gustavo Soares almost 13 years ago. Updated over 12 years ago.

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

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'

Actions

Also available in: Atom PDF