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 at
http://groups.google.com/group/thinking-sphinx?hl=en.
