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

Updated by Ohad Levy almost 13 years ago

  • Category set to Search
  • Assignee set to Amos Benari
  • Target version set to 0.4
Actions #2

Updated by Ohad Levy almost 13 years ago

  • Priority changed from High to Normal
Actions #3

Updated by Ohad Levy almost 13 years ago

  • Assignee changed from Amos Benari to Ohad Levy
Actions #4

Updated by Ohad Levy almost 13 years ago

  • Status changed from New to Closed
  • % Done changed from 0 to 100
Actions #5

Updated by Gustavo Soares over 12 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

Actions

Also available in: Atom PDF