Existing results in production weren't showing up because the boolean delta values on those were null, as I didn't specify a default in the migration... this should be defaulted to false. Just a word of warning to everyone in the future. Everything works well now.
Thanks again Pat, and to all of the contributers, for writing TS. Eric On May 19, 1:49 am, Eric <[email protected]> wrote: > It turns out that the 0.9.5 branch tag is really outdated - someone > should change the quickstart guide, because it's seriously misleading. > The thing that convinced me to recheckout the git repo was the last > comment by Pat > here:http://freelancing-gods.com/posts/thinking_sphinx_delta_changes > - "Hi Tony > > The usage page is woefully out-of-date when it comes to version > numbers – the latest version on GitHub is 1.1.10. I’ve not been adding > tags though, but just get the latest version, and things should work. > > Cheers" > > Once I rechecked out Sphinx without changing to 0.9.5, everything > worked perfectly! > > Now to figure out why no results are returned period on my production > box (Passenger/mod_rails)... > > On May 18, 6:02 pm, Eric <[email protected]> wrote: > > > Thinking Sphinx has been a great boon, and it seems to work really > > well for the most part, so a big thank you to Pat for writing this. > > > I've been trying all day without much success to get delta indexing to > > work, though. I've tried pretty much everything I could find on this > > group, but nothing seems to work. Part of my lack of success is likely > > due to my lack of experience with Ruby, Rails, Sphinx, etc, however - > > I very well may have applied some of the solutions incorrectly. > > > I believe I've narrowed it to index_delta never being called on save - > > if I call index_delta directly on an instance of the model in script/ > > console, indexer runs and an appropriate line mentioning that the > > delta index is updated, but the searchd.log shows no delta runs in > > normal operation. > > > My current setup is: Mac OS 10.5, Rails 2.3.2, Sphinx 0.9.9-rc2 > > (r1785), TS 0.9.5 > > > The define_index I'm using, in a model called Customer: > > > define_index do > > indexes [first_name, last_name], :as => :name, :sortable => true > > has business_id > > #set_property :enable_star => 1 > > set_property :min_infix_len => 1 > > set_property :delta => true > > end > > > config/sphinx.yml: > > > development: > > allow_star: true > > bin_path: '/usr/local/bin' > > pid_file: "tmp/pids/searchd.development.pid" > > > test: > > allow_star: true > > > production: > > allow_star: true > > bin_path: '/usr/local/bin' > > pid_file: "tmp/pids/searchd.production.pid" > > > And the migration I used to add the delta column to the table: > > class AddDeltaColumnToCustomers < ActiveRecord::Migration > > def self.up > > add_column :customers, :delta, :boolean > > end > > > def self.down > > remove_column :customers, :delta > > end > > end > > > I'm not sure what to do/try at this point... this is all in dev still. > > I'm going to give up on dev and try on production shortly. Any ideas? > > Thanks in advance. --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
