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 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.
