Hi Arun I can't think of any reason why it was working with older TS and now isn't with case-insensitive columns on newer TS, but at least it's now working with the correct case :)
-- Pat On 10/01/2012, at 3:21 AM, Arun Kumar Nachimuthu wrote: > 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. > -- 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.
