Hi Walter Timo's suggestions are spot on - although if these queries worked previously, I'm a little surprised that they don't work now.
Do you have a config/sphinx.yml file? Because that was the TS v2 equivalent of TS v3's config/thinking_sphinx.yml. And if you do, what's in the old file? -- Pat On 7 May 2014, at 4:23 am, Walter Lee Davis <[email protected]> wrote: > Thanks! > > Walter > > On May 6, 2014, at 2:06 PM, Timo Virkkala wrote: > >> You're supposed to create it yourself. >> See this for some instructions: >> http://pat.github.io/thinking-sphinx/advanced_config.html >> >> Basically, if you don't need anything else, this should suffice: >> >> development: >> enable_star: true >> min_prefix_len: 2 >> test: >> enable_star: true >> min_prefix_len: 2 >> production: >> enable_star: true >> min_prefix_len: 2 >> >> -Timo >> >> >> On 6 May 2014 20:36, Walter Lee Davis <[email protected]> wrote: >>> How do I generate that file? It's entirely missing here. >>> >>> Walter >>> >>> On May 6, 2014, at 12:54 PM, Timo Virkkala wrote: >>> >>>> 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. >>> >>> -- >>> 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.
