awesome, glad you got it working :) On Feb 22, 2010, at 5:09 PM, Colin wrote:
> I tried to setup my code the way I had it before. When it was still > all null I realised that it obviously wasn't indexing despite what it > was saying. > One reboot later and it all seems to be working :) > > Thanks for your time and patience guys. > > Regards, > > Colin > > On Feb 22, 11:46 pm, Colin <[email protected]> wrote: >> Here you go:http://pastie.org/837827 >> >> On Feb 22, 11:41 pm, Aaron Brethorst <[email protected]> wrote: >> >> >> >>> Can you perform a ts:index and dump the output into a pastie? >> >>> On Feb 22, 2010, at 3:40 PM, Colin wrote: >> >>>> Should that would work as the only place is_active is defined is the >>>> line where Aaron suggested to try it? >> >>>> Either way, no it doesn't. Still empty. >> >>>> On Feb 22, 11:32 pm, Pat Allan <[email protected]> wrote: >>>>> Does a normal search using the attribute work? >> >>>>> Calendar.search :with => {:is_active => true} >> >>>>> -- >>>>> Pat >> >>>>> On 23/02/2010, at 10:24 AM, Colin wrote: >> >>>>>> pastie updated to show whole class:http://pastie.org/837509 >> >>>>>> define_index do >>>>>> indexes id >>>>>> indexes subject >>>>>> indexes parties >> >>>>>> set_property :enable_star => 1 >>>>>> set_property :min_infix_len => 3 >> >>>>>> has organisation_id >>>>>> has "deleted_at IS NULL", :as => :is_active, :type => :boolean >>>>>> end >> >>>>>> Yep, just stopped, reindexed and restarted there again. Still empty. >> >>>>>> On Feb 22, 11:21 pm, Pat Allan <[email protected]> wrote: >>>>>>> What Aaron's been saying has been spot on. >> >>>>>>> Colin: can you paste your define_index block here, as it currently >>>>>>> stands? And also, have you restarted Sphinx and re-indexed? An empty >>>>>>> array would suggest Sphinx doesn't know about the new attribute you've >>>>>>> created. >> >>>>>>> -- >>>>>>> Pat >> >>>>>>> On 23/02/2010, at 9:59 AM, Aaron Brethorst wrote: >> >>>>>>>> and your sphinx_scope was defined identically to this? >> >>>>>>>> sphinx_scope(:active_ts) { >>>>>>>> { :with => {:is_active => true} } >>>>>>>> } >> >>>>>>>> that should work, but i'm no expert unfortunately. >> >>>>>>>> On Feb 22, 2010, at 2:55 PM, Colin wrote: >> >>>>>>>>> Just to add in the "has "deleted_at IS NULL", :as => :is_active, :type >>>>>>>>> => :boolean" line. >> >>>>>>>>> On Feb 22, 10:52 pm, Aaron Brethorst <[email protected]> wrote: >>>>>>>>>> did you modify the define_index block? >> >>>>>>>>>> On Feb 22, 2010, at 2:48 PM, Colin wrote: >> >>>>>>>>>>> I tried your suggestion and also tried replacing the { :conditions >>>>>>>>>>> => >>>>>>>>>>> ["deleted_at IS NULL"] } with {:conditions => {:deleted_at => nil}} >>>>>>>>>>> but in both cases it seems to be returning an empty array. >> >>>>>>>>>>> On Feb 22, 10:34 pm, Aaron Brethorst <[email protected]> wrote: >>>>>>>>>>>> Pat could certainly speak to this better than I, but I was under >>>>>>>>>>>> the impression that conditions are only used in conjunction with >>>>>>>>>>>> fields that have been marked with 'indexes'. >> >>>>>>>>>>>> I was actually doing something similar to what you're trying to >>>>>>>>>>>> accomplish earlier today. Maybe you could do something like the >>>>>>>>>>>> following: >> >>>>>>>>>>>> # note: untested code; written in my Mail app >> >>>>>>>>>>>> define_index do >>>>>>>>>>>> # all of your existing stuff goes here >>>>>>>>>>>> has "deleted_at IS NULL", :as => :is_active, :type => :boolean >>>>>>>>>>>> end >> >>>>>>>>>>>> sphinx_scope(:active_ts) { >>>>>>>>>>>> { :with => {:is_active => true} } >> >>>>>>>>>>>> } >> >>>>>>>>>>>> On Feb 22, 2010, at 2:21 PM, Colin wrote: >> >>>>>>>>>>>>> Thank you for the link. >>>>>>>>>>>>> It fixed the original error but it is now throwing: >> >>>>>>>>>>>>> undefined method `keys' for ["deleted_at IS NULL"] >> >>>>>>>>>>>>> So would I be right in thinking that I can't use the ["deleted_at >>>>>>>>>>>>> IS >>>>>>>>>>>>> NULL"] syntax to define a condition? >> >>>>>>>>>>>>> Regards, >> >>>>>>>>>>>>> Colin >> >>>>>>>>>>>>> On Feb 22, 8:50 pm, Aaron Brethorst <[email protected]> >>>>>>>>>>>>> wrote: >>>>>>>>>>>>>> Try declaring your sphinx_scopes after define_index. >> >>>>>>>>>>>>>> http://brethorsting.com/blog/2010/02/solution-for-undefined-method-sp... >> >>>>>>>>>>>>>> On Feb 22, 2010, at 12:46 PM, Colin wrote: >> >>>>>>>>>>>>>>> Hi, >> >>>>>>>>>>>>>>> I'm getting the above error when I try to declare a >>>>>>>>>>>>>>> sphinx_scope. >>>>>>>>>>>>>>> I've googled around but couldn't find a solution. >>>>>>>>>>>>>>> The model in question can be found here:http://pastie.org/837509 >> >>>>>>>>>>>>>>> I've tried it in the syntax shown above and also a direct copy >>>>>>>>>>>>>>> of the >>>>>>>>>>>>>>> named_scope syntax. >> >>>>>>>>>>>>>>> Any ideas? >> >>>>>>>>>>>>>>> Regards, >> >>>>>>>>>>>>>>> Colin >> >>>>>>>>>>>>>>> -- >>>>>>>>>>>>>>> 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 >>>>>> 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.
