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 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.
