Sorry, turns out excerpt calls weren’t logged. I’ve just fixed this now on the
develop branch, if you want to give that a spin?
gem 'thinking-sphinx', '~> 3.1.2',
:git => 'git://github.com/pat/thinking-sphinx.git',
:branch => ‘develop',
:ref => 'de070904a8'
—
Pat
> On 18 Jan 2015, at 1:42 pm, Walter Lee Davis <[email protected]> wrote:
>
> I turned my production log level up to debug, and ran some searches, but I
> did not get any CALL SNIPPETS statements in the production.log.
>
> Here's an example search from the debug-level log:
>
> I, [2015-01-18T02:39:30.798473 #33311] INFO -- : Started GET
> "/search/results?page=2&q=elbows" for 173.161.197.5 at 2015-01-18 02:39:30
> +0000
> I, [2015-01-18T02:39:30.799777 #33311] INFO -- : Processing by
> SearchController#results as HTML
> I, [2015-01-18T02:39:30.799836 #33311] INFO -- : Parameters: {"page"=>"2",
> "q"=>"elbows"}
> D, [2015-01-18T02:39:30.801638 #33311] DEBUG -- : Sphinx Query (0.8ms)
> SELECT * FROM `page_core`, `person_core`, `title_core` WHERE MATCH('elbows')
> AND `sphinx_deleted` = 0 LIMIT 20, 20
> D, [2015-01-18T02:39:30.801768 #33311] DEBUG -- : Sphinx Found 58 results
> D, [2015-01-18T02:39:30.805019 #33311] DEBUG -- : Title Load (2.5ms)
> SELECT `titles`.* FROM `titles` WHERE `titles`.`id` IN (970, 991, 1169,
> 1228, 1229, 1338, 1616, 1621, 1637, 1656, 1691, 1696, 1701, 1705, 1747, 1755,
> 1784, 1929, 1960, 1976)
> D, [2015-01-18T02:39:30.886971 #33541] DEBUG -- : Content Load (27.1ms)
> SELECT `contents`.* FROM `contents` WHERE `contents`.`title_id` = 2081
> LIMIT 1
> D, [2015-01-18T02:39:30.905921 #33311] DEBUG -- : Content Load (91.8ms)
> SELECT `contents`.* FROM `contents` WHERE `contents`.`title_id` = 970 LIMIT
> 1
> I, [2015-01-18T02:39:31.258680 #33541] INFO -- : Rendered
> search/results.html.erb within layouts/application (14482.7ms)
> I, [2015-01-18T02:39:31.261015 #33541] INFO -- : Rendered
> layouts/_footer.html.erb (0.2ms)
> I, [2015-01-18T02:39:31.262004 #33541] INFO -- : Rendered
> layouts/_top_nav.html.erb (0.8ms)
> I, [2015-01-18T02:39:31.262441 #33541] INFO -- : Completed 200 OK in 14574ms
> (Views: 14178.9ms | ActiveRecord: 313.6ms)
>
>
> Walter
>
> On Jan 17, 2015, at 8:28 PM, Pat Allan <[email protected]> wrote:
>
>> They’re output at a `debug` level, so they’re probably not on production…
>> but should be in development.log by default, yes.
>>
>>> On 18 Jan 2015, at 12:20 pm, Walter Lee Davis <[email protected]> wrote:
>>>
>>> I was getting results that were missing any highlighted search terms. I'm
>>> not seeing those queries at all -- would they be in development log only? I
>>> can turn up the log level, but this is a very busy server.
>>>
>>> Walter
>>>
>>> On Jan 17, 2015, at 7:14 PM, Pat Allan <[email protected]> wrote:
>>>
>>>> Hi Walter
>>>>
>>>> It looks right to me, and I’m not spotting anything in the TS or Riddle
>>>> code that suggests behaviour should be different. Are you getting an error
>>>> when you include those options? Or just no results?
>>>>
>>>> In your Rails log file, there should be a SphinxQL ‘CALL SNIPPETS’
>>>> statement for each excerpt generation call - can you share one of those
>>>> queries here?
>>>>
>>>> —
>>>> Pat
>>>>
>>>>> On 18 Jan 2015, at 7:39 am, Walter Lee Davis <[email protected]> wrote:
>>>>>
>>>>> I had a working Rails 3.0 site with TS 2.0.10 that used the following
>>>>> controller method to gather cross-model results:
>>>>>
>>>>> def results
>>>>> @results = ThinkingSphinx.search Riddle.escape(params[:q].to_s),
>>>>> :page => params[:page],
>>>>> :match_mode => :phrase,
>>>>> :order => 'class_crc ASC, @relevance DESC',
>>>>> :excerpt_options => {
>>>>> :exact_phrase => true,
>>>>> :limit => 2000,
>>>>> :around => 20,
>>>>> :force_all_words => true,
>>>>> :chunk_separator => '</li><li>'
>>>>> }.reject{ |r| r.class.to_s == 'NilClass' }
>>>>> @hits = @results.total_entries rescue 0
>>>>> end
>>>>>
>>>>>
>>>>> In my current Rails 4.1 iteration of this application, I was not able to
>>>>> get the exact_phrase and show_all_words keys to work at all. My
>>>>> controller has those commented out, so the search results work, but are
>>>>> greedier than I'd like them to be.
>>>>>
>>>>> Is there anything new in this area that I have missed from your otherwise
>>>>> great upgrade guide?
>>>>>
>>>>> Thanks,
>>>>>
>>>>> 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.
