Ah, now *that* makes sense. If you're filtering on attributes across multiple
models, those attributes need to exist on all the model indexes.
So: given these are all boolean attributes, what you'll need to do is create
pseudo-attributes on the other models, with whatever default you prefer:
has '0', :as => :deleted, :type => :boolean
Change '0' to 'FALSE' if you're using PostgreSQL instead of MySQL, and repeat
as needed for each attribute and model.
Great to know we're making some progress.
Cheers
--
Pat
On 12/10/2010, at 9:34 AM, Ryan wrote:
> I think I figured out the problem, just not sure on a solution yet.
>
> If my search code looks like this:
>
> filters = Hash.new
> filters.merge!({ :deleted => false })
> filters.merge!({ :copyrighted => false })
> filters.merge!({ :personal => false })
> filters.merge!({ :group_private => false })
>
> @results = ThinkingSphinx.search search, :with =>
> filters, :retry_stale => true, :match_mode => :any, :per_page =>
> @per_page, :page => params[:page]
>
> Basically what I am seeing is that under Sphinx 0.9.9 I get back no
> results because not every model has all of those columns being
> filtered on. If I take out the filters and only use the deleted
> filter which every model does have then I do get back results. Under
> 0.9.8 I am able to use the above filters with no problem and get back
> the correct results from all the models whether they have the column
> or not.
>
> Any ideas? Should I not be using filters like this?
>
> Thanks
> Ryan
>
>
> On Oct 7, 1:22 am, Pat Allan <[email protected]> wrote:
>> I'm really pulling at straws now... but what happens if you remove the
>> address line in your sphinx.yml? Or change it to 127.0.0.1?
>>
>> --
>> Pat
>>
>> On 05/10/2010, at 8:52 AM, Ryan wrote:
>>
>>
>>
>>> Yeah, no other searchd running after ts:stop.
>>
>>> Running that via script/console gets me this output:
>>
>>>>> ThinkingSphinx::Configuration.instance.version
>>> => "0.9.9"
>>
>>> I've still been trying to get it to work on our staging with no luck
>>> on 0.9.9. Its strange since it works so good with 0.9.8.
>>
>>> On Oct 2, 2:35 am, Pat Allan <[email protected]> wrote:
>>>> Hi Ryan
>>
>>>> Can you run ts:stop, and then confirm that there are no other searchd
>>>> processes running via 'ps aux | grep searchd'?
>>
>>>> I know it's a little obvious, but doesn't hurt to double check.
>>
>>>> If that's all fine, what's the output of the following in script/console:
>>>> ThinkingSphinx::Configuration.instance.version
>>
>>>> Cheers
>>
>>>> --
>>>> Pat
>>
>>>> On 02/10/2010, at 3:15 AM, Ryan wrote:
>>
>>>>> All I ever see in searchd.log is messages about rotating index. In
>>>>> searchd.query.log I see the search messages from thinking sphinx even
>>>>> though I get back no results. When I use the search CLI I don't seem
>>>>> to see anything in any log file even though I do get results.
>>
>>>>> My sphinx.yml looks like this:
>>
>>>>> production:
>>>>> searchd_file_path: "/usr/local/site/staging/indexes/"
>>>>> address: 0.0.0.0
>>>>> log: '/usr/local/websites/staging/site/current/log/searchd.log'
>>>>> query_log: '/usr/local/websites/staging/site/current/log/
>>>>> searchd.query.log'
>>>>> pid_file: '/usr/local/websites/staging/site/current/log/
>>>>> searchd.production.pid'
>>>>> bin_path: '/usr/local/bin'
>>>>> mem_limit: 256M
>>
>>>>> I've also tried changing the address to listen as it looks like thats
>>>>> what 0.9.9 wants now but still no luck getting results under 0.9.9.
>>
>>>>> Thanks for you help,
>>>>> Ryan
>>
>>>>> On Oct 1, 6:53 am, Pat Allan <[email protected]> wrote:
>>>>>> Hi Ryan
>>
>>>>>> Is there anything in the searchd.log when you're querying via TS? Is
>>>>>> that any different to what you see with the search CLI tool?
>>
>>>>>> Also: what's the contents of your config/sphinx.yml file?
>>
>>>>>> --
>>>>>> Pat
>>
>>>>>> On 30/09/2010, at 4:57 AM, Ryan wrote:
>>
>>>>>>> Thanks for the reply Pat. Yeah we tried doing a rebuild with no
>>>>>>> luck. I've tried searching one model or many models and still no
>>>>>>> results. We are indexing about 20 different models currently.
>>
>>>>>>> Here is an example of one model's define_index that I tried searching
>>>>>>> on alone:
>>
>>>>>>> define_index do
>>>>>>> indexes school.name
>>>>>>> has id, :as => :school_id
>>
>>>>>>> set_property :enable_star => 1
>>>>>>> set_property :min_prefix_len => 3
>>>>>>> set_property :delta => true
>>>>>>> end
>>
>>>>>>> If I search it through the sphinx command line tool I get back results
>>>>>>> but when I use thinking sphinx I get back no results with 0.9.9. Soon
>>>>>>> as we switch back to 0.9.8 results show up again in thinking sphinx.
>>
>>>>>>> Thanks
>>>>>>> Ryan
>>
>>>>>>> On Sep 28, 4:26 pm, Pat Allan <[email protected]> wrote:
>>>>>>>> Hi Ryan
>>
>>>>>>>> I'm going to start with the basics, though I'm sure you've done this
>>>>>>>> already: have you run 'rake ts:rebuild' (or the separate equivalent
>>>>>>>> tasks: ts:stop, ts:in, ts:start)?
>>
>>>>>>>> If that doesn't help, how many models are you indexing? Can you choose
>>>>>>>> one, search on just that, and tell us what the define_index block for
>>>>>>>> it is?
>>
>>>>>>>> Cheers
>>
>>>>>>>> --
>>>>>>>> Pat
>>
>>>>>>>> On 29/09/2010, at 5:03 AM, Ryan wrote:
>>
>>>>>>>>> We are currently running Thinking Sphinx 1.3.20 and Sphinx 0.9.8 and
>>>>>>>>> everything is working great. We tried upgrading Sphinx to 0.9.9 and
>>>>>>>>> every search from thinking sphinx gets no results returned. I see the
>>>>>>>>> search come through in the searchd.query.log. We also did the same
>>>>>>>>> search via command line and sphinx is returning results so it seems to
>>>>>>>>> be a problem with thinking sphinx or how we have it configured.
>>
>>>>>>>>> Are we maybe missing a config file change that needs to happen for
>>>>>>>>> Sphinx 0.9.9?
>>
>>>>>>>>> Thank you for you help.
>>
>>>>>>>>> --
>>>>>>>>> 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
>>>>>>> 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
>>>>> 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
>>> 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.
