Project

General

Profile

Bug #968

cannot search a puppetclass by name

Added by Gustavo Soares almost 8 years ago. Updated over 7 years ago.

Status:
Closed
Priority:
Normal
Assignee:
Category:
Search
Target version:
Difficulty:
Triaged:
No
Bugzilla link:
Pull request:
Team Backlog:
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'

Associated revisions

Revision 7d46a25e (diff)
Added by Ohad Levy almost 8 years ago

fixes #968 - cannot search a puppetclass by name

History

#1 Updated by Ohad Levy almost 8 years ago

  • Category set to Search
  • Assignee set to Amos Benari
  • Target version set to 0.4

#2 Updated by Ohad Levy almost 8 years ago

  • Priority changed from High to Normal

#3 Updated by Ohad Levy almost 8 years ago

  • Assignee changed from Amos Benari to Ohad Levy

#4 Updated by Ohad Levy almost 8 years ago

  • Status changed from New to Closed
  • % Done changed from 0 to 100

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

Also available in: Atom PDF