Yes, you are right. Thanks Pat for all your help! it is much appreciated On Jan 9, 11:08 pm, "Pat Allan" <[email protected]> wrote: > Wait… that query's still not quite right. :conditions is for field queries, > and :with is for attribute filters - but you've got the latter and other > options within :conditions. Try the following instead: > > Item.search params[:search], > :with => {:business_id => @businessid, :active => 1}, > :star => true, > :field_weights => {:itemname => 20, :description => 10, :catone => 5, > :cattwo => 5, :catthree => 5}, > :page => params[:page], > :per_page => 10 > > -- > Pat > > On 10/01/2012, at 3:01 PM, maximulus wrote: > > > > > > > > > Hi Pat, > > > I managed to fix the delta part. I left thinking_sphinx.remote_sphinx > > on in my production.rb (thought I had hashed it out). Sorry :-S But as > > a side not I find when I use define_indexes as oppose to define index > > I get an error. > > > As for fuzzy: > > I just managed to fix that too. It appears for what ever reason, the > > query must be formed this way. > > > @items = Item.search > > params[:search], :star=>true, :conditions=> {:business_id=> > > @businessid, :active=>1, > > :field_weights => {:itemname => 20, :description => > > 10, :catone => 5, :cattwo => 5, :catthree => 5} > > }, :page=>params[:page], :per_page=>10 > > > To be honest, I have no idea why. This works on my development > > machine, same Rails version, same sphinx version, same thinking sphinx > > version and same yml. Must be something with passenger/webbrick > > difference. Anyway, thank you so much for your time. I have been > > working on this for almost a week. Great gem. > > > On Jan 9, 10:28 pm, "Pat Allan" <[email protected]> wrote: > >> Yeah, the delta indexing output looks fine - also, it's define_indexes, > >> not define_index, to ensure indices are loaded. > > >> As for the fuzzy searching on production, can you confirm that the > >> enable_star and min_infix_len settings are set in the generated Sphinx > >> configuration file? And :star should be true, not 1, though I'd be > >> surprised if that changed anything (1 is still true-ish). > > >> -- > >> Pat > > >> On 10/01/2012, at 2:22 PM, maximulus wrote: > > >>> I am using script/console production and then > > >>> Item.define_index && Item.index_delta; 'lentils' > > >>> I get this: > > >>> using config file > >>> '/home/webuser/rails_apps/project/current/config/ > >>> production.sphinx.conf'... > >>> indexing index 'item_delta'... > >>> collected 0 docs, 0.0 MB > >>> collected 0 attr values > >>> sorted 0.0 Mvalues, nan% done > >>> total 0 docs, 0 bytes > >>> total 0.006 sec, 0 bytes/sec, 0.00 docs/sec > >>> total 0 reads, 0.000 sec, 0.0 kb/call avg, 0.0 msec/call avg > >>> total 4 writes, 0.000 sec, 0.1 kb/call avg, 0.0 msec/call avg > >>> rotating indices: succesfully sent SIGHUP to searchd (pid=3462). > >>> => "lentils" > > >>> I have to be honest, I think that is what I should get but I am not > >>> certain. > > >>> However, when I do the test for fuzzy, I DO get all the > >>> results I should on the test with > >>> Item.search('pistachio', :star => 1) from console. > > >>> Here is my query from the controller > > >>> @items = Item.search params[:search], :conditions=> > >>> {:active=>1, :star=>1, > >>> :field_weights => {:itemname => 20, :description => 10} > >>> }, :page=>params[:page], :per_page=>10 > > >>> Do you see anything here? Is the 'star' not reading as 1 perhaps? > > >>> Thanks for all your help. I am running out of ideas. > > >>> Ari > > >>> On Jan 9, 7:24 pm, "Pat Allan" <[email protected]> wrote: > >>>> Hmm, nothing out of the ordinary there. How are you testing fuzzy > >>>> searching? And deltas? > > >>>> -- > >>>> Pat > > >>>> On 10/01/2012, at 12:41 AM, maximulus wrote: > > >>>>> Sure thanks Pat. > > >>>>> Just to update, I did a full reinstall of sphinx and thinking sphinx, > >>>>> as I had originally installed sphinx with the yum package manager, > >>>>> which installed sphinx from root and then I manually changed the > >>>>> ownership. I reinstalled from source (using wget) through the web > >>>>> user, which is why searched is now in /usr/local/bin' as oppose to usr/ > >>>>> bin in the original question. > > >>>>> Was shocked to find I still have the same problem. > > >>>>> Here is what is in the sphinx.yml file > >>>>> production: > >>>>> port: 3312 > >>>>> bin_path: '/usr/local/bin' > >>>>> address: 127.0.0.1 > >>>>> mem_limit: 512M > >>>>> max_children: 300 > >>>>> max_matches: 100000 > >>>>> seamless_rotate: 1 > >>>>> preopen_indexes: 1 > >>>>> enable_star: true > >>>>> morphology: stem_en > >>>>> min_infix_len: 3 > >>>>> query_log_file: "/home/webuser/rails_apps/project/current/log/ > >>>>> searchd.query.log" > >>>>> searchd_log_file: "/home/webuser/rails_apps/project/current/log/ > >>>>> searchd.log" > >>>>> pid_file: "/home/webuser/rails_apps/project/shared/pids" > >>>>> searchd_file_path: "/home/webuser/rails_apps/project/current/db/ > >>>>> sphinx" > > >>>>> On Jan 9, 6:24 am, "Pat Allan" <[email protected]> wrote: > >>>>>> Can you share the contents of your config/sphinx.yml file? > > >>>>>> -- > >>>>>> Pat > > >>>>>> On 08/01/2012, at 11:37 AM, maximulus wrote: > > >>>>>>> Hello, > > >>>>>>> I am using Rails 2.3.12 > > >>>>>>> All settings are the same for development and production server except > >>>>>>> the os: Leopard/Centos and WEBBrick/Nginx-Passenger > > >>>>>>> I am using thinking-sphinx-0.9.9 gem version 1.3.2 > > >>>>>>> I am using sphinx 0.9.9 R2117 > > >>>>>>> Permissions to web user have been granted to all thinking sphinx files > >>>>>>> and searchd. > >>>>>>> I Rake with RAILS_ENV=production in production mode, that is the only > >>>>>>> difference I can find. > >>>>>>> Path is set to where searchd is, in usr/bin. > >>>>>>> I can see no errors in the production.log, or the nginx error log. > > >>>>>>> I am in fact using the same database, so when I make a change to say, > >>>>>>> an item name, it works in development but not production. Also fuzzy > >>>>>>> search works only in development. Rake ts:index works fine in both. > > >>>>>>> Are there any other tests I can run, or have I overlooked anything? > > >>>>>>> Thank you in advance, > >>>>>>> Max > > >>>>>>> -- > >>>>>>> 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.
