Hi Jake What's your smallest and largest id values for the Asset model? Are you using PostgreSQL or MySQL? And do you have anything in your config/sphinx.yml file?
Cheers -- Pat On 25/02/2011, at 11:37 AM, Jake wrote: > I recently just ran into an issue where it seems that Sphinx is not indexing > all of my data. I have an Asset model with the following define_index block: > > define_index do > indexes title, :sortable => true > indexes alternate_titles.title, :as => :alternate_titles > set_property :enable_star => 1 > set_property :min_infix_len => 1 > where "asset_status_id = (select id from asset_statuses where name = > 'approved')" > indexes type, author, publisher, director, writer, producer, artist > has original_language(:id), :as => :original_language_id > has country(:id), :as => :country_id > has mpaa_rating(:id), :as => :mpaa_rating_id > has genres(:id), :as => :genre_ids > has 'YEAR(release_date)', :as => :release_year, :type => :integer > has decade(:id), :as => :decade_id > indexes taggings.tag.name, :as => :tag_names > end > > Here are the results of two calls that show the discrepancy: > > ruby-1.9.2-p0 > Asset.search_count > => 1709 > ruby-1.9.2-p0 > Asset.count > => 1767 > > I've run rake ts:rebuild countless times trying to figure this out, but I > really have no idea where to look. I'm on the rails3 branch and at version > 2.0.0, using ruby 1.9.2p0. Any help you can give me would be greatly > appreciated, even if it's just a hint about where to try looking next. My > co-worker has the same issue, but is only missing one Asset instead of 58. > > -- > 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.
