#62 ✓resolved
Scott Jacobsen

Invalid sql produced on single character keywords

Reported by Scott Jacobsen | March 4th, 2009 @ 07:21 PM

With the following parameters:

{"commit"=>"Search",
 "search"=>{"conditions"=>{"group"=>{"or_city_keywords"=>"b",
 "or_street_name_keywords"=>"b",
 "household_name_keywords"=>"b"},
 "user_id"=>1},
 "priority_order_by"=>"",
 "order_as"=>"",
 "per_page"=>"25",
 "priority_order_as"=>"",
 "order_by"=>""}}

Produces this sql:

SELECT count(mytable.id) AS count_id FROM mytable WHERE (() AND mytable.user_id = 1)

Comments and changes to this ticket

  • Ben Johnson

    Ben Johnson March 6th, 2009 @ 05:49 AM

    • State changed from “new” to “resolved”

    I see what's going on. I pushed out a fix, update from the repo and you should be good to go. Thanks for letting me know about this.

Please Sign in or create a free account to add a new ticket.

With your very own profile, you can contribute to projects, track your activity, watch tickets, receive and update tickets through your email and much more.

New-ticket Create new ticket

Create your profile

Help contribute to this project by taking a few moments to create your personal profile. Create your profile ยป

Provides common named scopes and object based searching.

People watching this ticket

Pages