I should add that the query is identical on the production server. On Jan 9, 10:22 pm, maximulus <[email protected]> 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 at http://groups.google.com/group/thinking-sphinx?hl=en.
