Hmm.. What do you have in your config/thinking_sphinx.yml? Do you have enable_star: true and either min_infix_len or min_prefix_len for all environments?
(And you've noticed that it's now config/thinking_sphinx.yml, not config/sphinx.yml?) -Timo On 6 May 2014 19:36, Walter Lee Davis <[email protected]> wrote: > Thanks, but these options don't return any hits either. > > 1.9.3-p484 :001 > User.search('walt', :star => true) > Sphinx Query (11.3ms) SELECT * FROM `user_core` WHERE MATCH('*walt*') AND > `sphinx_deleted` = 0 LIMIT 0, 20 > Sphinx Found 0 results > => [] > 1.9.3-p484 :002 > User.search('walt*') > Sphinx Query (1.0ms) SELECT * FROM `user_core` WHERE MATCH('walt*') AND > `sphinx_deleted` = 0 LIMIT 0, 20 > Sphinx Found 0 results > => [] > 1.9.3-p484 :003 > User.search('walter') > Sphinx Query (1.0ms) SELECT * FROM `user_core` WHERE MATCH('walter') AND > `sphinx_deleted` = 0 LIMIT 0, 20 > Sphinx Found 2 results > User Load (0.4ms) SELECT `users`.* FROM `users` WHERE `users`.`id` IN (1, > 3) > > I'm using Sphinx 2.1.4, and TS 3.1.1. > > Could this be one of those things like MySQL full text search, where fewer > than half the records can match in order for there to be any results? > > Walter > > On May 6, 2014, at 12:22 PM, Timo Virkkala wrote: > >> Hi Walter, >> >> You need to search for 'walt*', or provide :star => true. >> >> -Timo >> >> On 6 May 2014 18:20, Walter Lee Davis <[email protected]> wrote: >>> I am testing TS3 in a new site (have previously stuck to the older >>> versions) and right away, I'm seeing fewer results (well, none, in my >>> limited test) where I would expect them to appear. I have indexed my users >>> table, and I try searching for myself. >>> >>> ThinkingSphinx::Index.define :user, :with => :active_record do >>> # fields >>> indexes first_name, :sortable => true >>> indexes last_name, :sortable => true >>> indexes bio >>> >>> # attributes >>> has created_at, updated_at >>> end >>> >>> User.search('walt') >>> Sphinx Query (37.4ms) SELECT * FROM `user_core` WHERE MATCH('walt') AND >>> `sphinx_deleted` = 0 LIMIT 0, 20 >>> Sphinx Found 0 results >>> => [] >>> >>> User.search('walter') >>> Sphinx Query (1.0ms) SELECT * FROM `user_core` WHERE MATCH('walter') AND >>> `sphinx_deleted` = 0 LIMIT 0, 20 >>> Sphinx Found 2 results >>> User Load (0.4ms) SELECT `users`.* FROM `users` WHERE `users`.`id` IN (1, >>> 3) >>> ... record follows ... >>> >>> Why is it not stemming on my first name, and getting walt and walter >>> together in the index? >>> >>> Thanks in advance, >>> >>> Walter >>> >>> -- >>> You received this message because you are subscribed to the Google Groups >>> "Thinking Sphinx" group. >>> To unsubscribe from this group and stop receiving emails from it, send an >>> email to [email protected]. >>> To post to this group, send email to [email protected]. >>> Visit this group at http://groups.google.com/group/thinking-sphinx. >>> For more options, visit https://groups.google.com/d/optout. >> >> -- >> You received this message because you are subscribed to the Google Groups >> "Thinking Sphinx" group. >> To unsubscribe from this group and stop receiving emails from it, send an >> email to [email protected]. >> To post to this group, send email to [email protected]. >> Visit this group at http://groups.google.com/group/thinking-sphinx. >> For more options, visit https://groups.google.com/d/optout. > > -- > You received this message because you are subscribed to the Google Groups > "Thinking Sphinx" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > To post to this group, send email to [email protected]. > Visit this group at http://groups.google.com/group/thinking-sphinx. > For more options, visit https://groups.google.com/d/optout. -- You received this message because you are subscribed to the Google Groups "Thinking Sphinx" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/thinking-sphinx. For more options, visit https://groups.google.com/d/optout.
