Hi Pat, I'm not adding the :conditions to my search in this case. I'd like to just index it so I can search for whatever I want in that city in particular.
Just for the record, do I need to configure the sphinx.conf that comes with Sphinx? Or will development.sphinx.conf replace it? Because right now, I've just configured the first one with Sphinx logs and bin directories, and to test it in the command line(and it works without conditions and such). Also, what I've noticed is that the SQL in the development.sphinx.conf is being generated wrongly. I guess the conditions part is wrong. So, if it's that, what am I suppose to do? How can I keep the changes on that file every time i index in the future? Thanks, Brian On Jan 20, 12:22 pm, Pat Allan <[email protected]> wrote: > Hi Brian > > Is it possible that the description column from the 'incorrect' matches had > the words shirt, stores or california? Or are you directing california to the > provide field? > > Announcement.search 'Shirt Stores', :conditions => {:province => > 'California'} > > As for starting the service on Windows 7, I'm afraid I don't have a clue... > I'll ask on Twitter, point people to this thread, maybe someone else can > chime in. > > -- > Pat > > On 20/01/2010, at 9:34 AM, Brian Roisentul wrote: > > > Yes, it is. Also, today I tried my app on another pc running Windows XP > > (instead of 7) and it seems to be working better. Eventhough, I don't > > why, some things work and some others don't. For example, I was trying > > to search by city(without filtering), and returned weird results. For > > example, I tried to find "shirt stores california" and it found me > > some results from that city, but most of them from other city, leaving > > out many results from california that matched the search. I don't know > > what's wrong, but I can't make it work 100%. > > > Of course that for doing this I previously included "indexes province > > (:name), :as => :province" in my index, or it was province.name, I > > tried both of them. > > > Thank you for the help. > > > Brian > > > On Jan 19, 12:37 am, Pat Allan <[email protected]> wrote: > >> Hi Brian > > >> I'm not a Windows user either, so this is a little bit of guesswork... but > >> when you start Sphinx via the Services window, are you specifying a > >> configuration file, and is it config/development.sphinx.conf in your Rails > >> project? > > >> -- > >> Pat > > >> On 19/01/2010, at 3:13 AM, Brian Roisentul wrote: > > >>> Ok. Thanks anyway. Can anybody give me a hand with this? I have the > >>> feeling that something is configured wrong, because this is not > >>> supposed to work like it does in my case. > > >>> Thanks, > >>> Brian > > >>> On 18 ene, 17:02, halogen64 <[email protected]> wrote: > >>>> You want it to say "accepting connections" so there is no issue with > >>>> that. I'm not familiar with TS or sphinx on windows so I probably > >>>> can't be any additional help. > > >>>> On Jan 18, 12:58 pm, Brian Roisentul <[email protected]> > >>>> wrote: > > >>>>> I don't get any error message when I run ts:start. It just keep > >>>>> starting forever. When I restart the service manually from the > >>>>> Services window I find the following line at the searchd.log: > > >>>>> [Sun Jan 17 20:24:51.212 2010] [ 4812] accepting connections > > >>>>> Do you know if there's something wrong with that? > > >>>>> Thanks, > >>>>> Brian > > >>>>> On 18 ene, 14:54, halogen64 <[email protected]> wrote: > > >>>>>> You should be running > > >>>>>> rake ts:rebuild > > >>>>>> after you change an index. One thing that I often find helps is when > >>>>>> you get an error message, copy the command thinking sphinx runs and > >>>>>> run it yourself, you get more insight into the issue that way. > > >>>>>> On Jan 18, 12:21 pm, Brian Roisentul <[email protected]> > >>>>>> wrote: > > >>>>>>> I did. It's pretty weird what's happening. I really don't understand > >>>>>>> what I'm missing. > > >>>>>>> After I change the index, I run: reindex, config, stop and start > >>>>>>> commands. The start command won't start though, but I manually restart > >>>>>>> the Sphinx windows service just in case. > > >>>>>>> On 18 ene, 14:13, Matt Mongeau <[email protected]> wrote: > > >>>>>>>> Did you reindex the table? You also won't need the alias. > > >>>>>>>> On Mon, Jan 18, 2010 at 12:08 PM, Brian Roisentul > > >>>>>>>> <[email protected]> wrote: > >>>>>>>>> Hi, > > >>>>>>>>> I'm working with Ruby on rails 2.3.2, TS 1.3.14 and Sphinx 0.9.9. > > >>>>>>>>> I found out that none of my filters work actually, while without > >>>>>>>>> them > >>>>>>>>> the search works correctly! I mean, in my announcements table I've > >>>>>>>>> got > >>>>>>>>> a province_id integer field. When I set up the index as follows it > >>>>>>>>> won't work either: > > >>>>>>>>> class Announcement < ActiveRecord::Base > > >>>>>>>>> belongs_to :announcement_type > >>>>>>>>> belongs_to :user > >>>>>>>>> belongs_to :province > >>>>>>>>> has_many :announcement_favorites > >>>>>>>>> has_many :announcement_comments > >>>>>>>>> has_many :announcement_subscriptions > >>>>>>>>> has_many :announcement_views > >>>>>>>>> acts_as_taggable_on :tags > > >>>>>>>>> validates_presence_of :title, :description, :expirationDate > > >>>>>>>>> define_index do > >>>>>>>>> indexes title, :as => :title > >>>>>>>>> indexes description, :as => :description > > >>>>>>>>> has province_id, :as => :province_id #or without the alias > >>>>>>>>> end > > >>>>>>>>> Then I search this way: > > >>>>>>>>> Announcement.search params[:search], :with => {:province_id => > >>>>>>>>> 1}, :page=>params[:page], :per_page => 10 > > >>>>>>>>> Am I missing something? > > >>>>>>>>> Please help! > > >>>>>>>>> Thanks, > >>>>>>>>> Brian > > >>>>>>>>> -- > >>>>>>>>> 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.
