Pat, Sorry for the late response.
Changing the case did the trick and now it is working fine. Did something change regarding case sensitivity between thinking-sphinx versions or sphinx versions? -- Arun On Dec 18 2011, 4:50 pm, Pat Allan <[email protected]> wrote: > Hmm, not sure if Sphinx is case-sensitive, but perhaps it's worth changing > the field references to use the same cases as the columns? You can add > aliases too: > > indexes TITLE, :as => :title > indexes Abstract, :as => :abstract > indexes Description, :as => :description > > -- > Pat > > On 18/12/2011, at 9:28 PM, Arun Kumar Nachimuthu wrote: > > > > > > > > > I have tried with different words. Still the same result. > > > Here is the define_index block > > > define_index do > > indexes :title > > indexes :abstract > > indexes :description > > > set_property :field_weights => { > > :title => 100, > > :abstract => 75, > > :description => 50 > > } > > end > > > One more information if it helps/ we are using custom model name. Our > > model name and table names are different. > > > class Model < ActiveRecord::Base > > > set_table_name "model_info" > > set_primary_key 'row_ID' > > def row_id; read_attribute :row_ID; end > > def model_id; read_attribute :model_ID; end > > def title; read_attribute :TITLE; end > > def abstract; read_attribute :Abstract; end > > def description; read_attribute :Description; end > > def id; read_attribute :id; end > > > end > > > On Dec 18, 7:06 am, Pat Allan <[email protected]> wrote: > >> Can you try with other words? Can you show us your define_index block? > > >> -- > >> Pat > > >> On 14/12/2011, at 11:29 PM, Arun Kumar Nachimuthu wrote: > > >>> When I give empty search, the following is the query log. > > >>> [Wed Dec 14 12:25:23.229 2011] 0.358 sec [ext/2/rel 6076952 (0,200)] > >>> [model2_core] > > >>> From this, it seems like empty search returns results. I think the > >>> word search that is the problem. > > >>> [Wed Dec 14 12:26:02.394 2011] 0.014 sec [ext/2/rel 0 (0,200)] > >>> [model2_core] system > > >>> -- > >>> Arun > >>> On Dec 14, 5:06 pm, Pat Allan <[email protected]> wrote: > >>>> Okay. Well, I recommend sticking with 1.4.10 as a gem. > > >>>> What happens when you run a search with no query? > >>>> ThinkingSphinx.search > > >>>> Is there anything in log/searchd.log or log/searchd.query.log that > >>>> provides any clues? > > >>>> -- > >>>> Pat > > >>>> On 14/12/2011, at 11:00 PM, Arun Kumar Nachimuthu wrote: > > >>>>> Hi Pat, > > >>>>> Thank you for the reply. I have already tried all versions above 1.4.6 > >>>>> til 1.4.10 both in plugin format and gem formats. But no success with > >>>>> any of them. > > >>>>> -- > >>>>> Arun > > >>>>> On Dec 14, 4:25 pm, Pat Allan <[email protected]> wrote: > >>>>>> Hi Arun > > >>>>>> Can you try Thinking Sphinx 1.4.10? I have a feeling Sphinx 2.0.x > >>>>>> support was a little flaky in TS 1.4.6. > > >>>>>> -- > >>>>>> Pat > > >>>>>> On 13/12/2011, at 9:22 PM, Arun Kumar Nachimuthu wrote: > > >>>>>>> We used to have a setup of Sphinx 0.9.9 and Thinking Sphinx 1.3.17. > >>>>>>> Our DB Size is close to 50GB. When I try to upgrade to sphinx 2.0.2 > >>>>>>> and Thinking sphinx 1.4.6 versions, nothing is getting indexed. When I > >>>>>>> run "rake thinking_sphinx:index", > > >>>>>>> Generating Configuration to ../../sphinx_index/staging/sphinx.conf > >>>>>>> Sphinx 2.0.2-beta (r3019) > >>>>>>> Copyright (c) 2001-2011, Andrew Aksyonoff > >>>>>>> Copyright (c) 2008-2011, Sphinx Technologies Inc (http:// > >>>>>>> sphinxsearch.com) > > >>>>>>> using config file '../../sphinx_index/staging/sphinx.conf'... > >>>>>>> indexing index 'model1_core'... > >>>>>>> collected 107973 docs, 0.0 MB > >>>>>>> total 107973 docs, 0 bytes > >>>>>>> total 0.315 sec, 0 bytes/sec, 342507.20 docs/sec > >>>>>>> skipping non-plain index 'model1'... > >>>>>>> indexing index 'model2_core'... > >>>>>>> collected 6076952 docs, 0.0 MB > >>>>>>> total 6076952 docs, 0 bytes > >>>>>>> total 1051.501 sec, 0 bytes/sec, 5779.30 docs/sec > >>>>>>> skipping non-plain index 'model2'... > >>>>>>> total 2 reads, 0.000 sec, 0.0 kb/call avg, 0.0 msec/call avg > >>>>>>> total 178 writes, 0.517 sec, 916.1 kb/call avg, 2.9 msec/call avg > > >>>>>>> When I query for some search term, I get empty results all the time. > >>>>>>> This used to work with TS 1.3.17 and sphinx 0.9.9. > > >>>>>>> What could cause this issue? > > >>>>>>> -- > >>>>>>> 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.
