What does the source definition for your NonProfit model look like in
development.sphinx.conf? Make sure you remove your database password.
--
Pat
On 04/10/2010, at 4:41 PM, thunderz14enator wrote:
> location(params[:locations]) returns the value of the checkbox which
> is an ID of the data
>
> I did rake ts:stop and rebuld the sphinx also
> and one thing that i ran this command in my rails console also
>
> irb(main):004:0> @nonprofits = NonProfit.search "",:with =>
> {:county_id => 2}
> => []
> irb(main):005:0>
>
> though i have the fields related to county id in my database
>
> ----
>
>
> On Oct 1, 7:11 pm, Pat Allan <[email protected]> wrote:
>> Can you give us an example of what location(params[:locations]) returns?
>>
>> Also, can you run ts:stop, and then confirm there are no other searchd
>> instances running, and then run ts:rebuild? Sometimes nil results are
>> obtained because there's a different Sphinx instance running that's looking
>> at other index files, hence the mismatch.
>>
>> Cheers
>>
>> --
>> Pat
>>
>> On 01/10/2010, at 6:42 PM, thunderz14enator wrote:
>>
>>> Hi,
>>
>>> I have a secnario where i m searching the result on the basis of
>>> checkbox,when i check the particual check box it passes an id called
>>> as "county_id", no i have county_id in my database and when i m trying
>>> to search the data according to "county_id", its gives me a nil
>>> result ,though i have data with that particular county id ..
>>
>>> the steps i follwoed are
>>
>>> 1 created a filed in my table naming county id.
>>
>>> 2 in my model i added these lines
>>
>>> define_index do
>>> indexes nonprofit_name
>>> indexes city
>>> has county_id
>>> # has city
>>> set_property :delta => true
>>> set_property :enable_star => true
>>> set_property :min_prefix_len => 1
>>> end
>>
>>> 3 in my controller
>>
>>> def nonprofit_sort
>>> if !params[:locations].blank? && !params[:search].blank?
>>> @nonprofits = NonProfit.search params[:search],:with =>
>>> {:county_id=> location(params[:locations])},:star => true
>>
>>> elsif !params[:locations].blank?
>>
>>> @nonprofits = NonProfit.search params[:search],:with =>
>>> {:county_id => location(params[:locations])},:star => truep "finished
>>> search"
>>> elsif !params[:search].blank?
>>
>>> @nonprofits = NonProfit.search params[:search],:star => true
>>> else
>>> @nonprofits= NonProfit.search params[:search],:star => true
>>> end
>>> end
>>
>>> 4. Rebuilded the index
>>
>>> I m totally clueless about getting the nill result
>>
>>> --
>>> You received this message because you are subscribed to the Google Groups
>>> "Thinking Sphinx" group.
>>> To post to this group, send email to [email protected].
>>> To unsubscribe from this group, send email to
>>> [email protected].
>>> For more options, visit this group
>>> athttp://groups.google.com/group/thinking-sphinx?hl=en.
>
> --
> You received this message because you are subscribed to the Google Groups
> "Thinking Sphinx" group.
> To post to this group, send email to [email protected].
> To unsubscribe from this group, send email to
> [email protected].
> For more options, visit this group at
> http://groups.google.com/group/thinking-sphinx?hl=en.
>
--
You received this message because you are subscribed to the Google Groups
"Thinking Sphinx" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/thinking-sphinx?hl=en.
