Carrying on from your last example, what's the output of the following:
Article.search('ts').first.sphinx_attributes
This should display the created_at value as Sphinx stores it, which
will hopefully give us some clues.
--
Pat
On 29/10/2009, at 3:27 PM, ThadeMark wrote:
>
> I'm not able to get results for recent records when searching using
> date ranges. I've been debugging for hours now. Any help would be
> appreciated.
>
> Using latest ThinkingSphinx (as of 2009/10/28), Sphinx (0.9.8.1),
> Rails (2.3.4), Ruby (1.8.7), and MySQL (Ver 14.12 Distrib 5.0.45) on
> Mac OS 10.5.8.
>
> ### Article Model
> define_index do
> indexes title, :sortable => :true
> indexes body
>
> has created_at
>
> set_property :delta => true
> end
>
> ### Schema
> create_table "articles", :force => true do |t|
> t.integer "user_id"
> t.string "title"
> t.string "synopsis"
> t.text "body"
> t.string "state"
> t.integer "rating"
> t.integer "view_count"
> t.datetime "created_at"
> t.datetime "updated_at"
> t.boolean "delta", :default => true, :null => false
> end
>
> ### Console Session
> a = Article.create(:user_id => 34, :title => "TS Test", :body =>
> "Testing Thinking Sphinx")
> => Leaving out part of results code for privacy reasons
> Sphinx 0.9.8.1-release (r1533)
> Copyright (c) 2001-2008, Andrew Aksyonoff
>
> using config file '/Users/thade/dev/rails/config/
> development.sphinx.conf'...
> indexing index 'article_delta'...
> collected 2 docs, 0.0 MB
> collected 0 attr values
> sorted 0.0 Mvalues, 100.0% done
> sorted 0.0 Mhits, 100.0% done
> total 2 docs, 60 bytes
> total 0.168 sec, 358.18 bytes/sec, 11.94 docs/sec
> rotating indices: succesfully sent SIGHUP to searchd (pid=11628).
> Querying Sphinx:
> Querying Sphinx:
>
>>> a.valid?
> => true
>
>>> Article.search :with => { :created_at => 1.day.ago..Time.now }
> Querying Sphinx:
> => []
>
>>> 1.day.ago
> => Tue, 27 Oct 2009 21:12:29 PDT -07:00
>>> Time.now
> => Wed Oct 28 21:12:26 -0700 2009
>>> a.created_at
> => Wed, 28 Oct 2009 21:07:51 PDT -07:00
>
> ### Let's 'rake ts:rebuild'
>
>>> Article.search :with => { :created_at => 1.day.ago..Time.now }
> Querying Sphinx:
> => []
>
> ### Let's try making the range go back further
>
>>> Article.search :with => { :created_at => 30.days.ago..Time.now }
> Querying Sphinx:
> Article Load (0.7ms) SELECT * FROM `articles` WHERE
> (`articles`.`id` IN (14))
> => [#<Article id: 14, user_id: 93, title: "Test", synopsis: "Test",
> body: "Test", state: "active", rating: nil, view_count: 1, created_at:
> "2009-10-06 18:33:15", updated_at: "2009-10-06 18:35:00", delta:
> false>]
>
> ### Success! We have an article result, although not the most recent
> one that was just created
>
> ### Let's try searching with terms
>
>>> Article.search 'ts'
> Querying Sphinx: ts
> Article Load (0.6ms) SELECT * FROM `articles` WHERE
> (`articles`.`id` IN (16))
> => [#<Article id: 16, user_id: 34, title: "TS Test", synopsis: nil,
> body: "Testing Thinking Sphinx", state: "queued", rating: nil,
> view_count: nil, created_at: "2009-10-29 04:07:28", updated_at:
> "2009-10-29 04:07:28", delta: false>]
>
> ### Success! Sphinx has the latest article in there, just not finding
> it with the date range search
>
> Any ideas?
>
> >
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
