Yeah that was the entire issue. I guess 0.9.8 didn't require it. I added the pseudo-attributes to all the models and results are returning just fine in 0.9.9 now.
Thanks for your help. Ryan On Oct 11, 6:32 pm, Pat Allan <[email protected]> wrote: > 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 > > 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.
