Hi Melissa I think the first problem is that you're using the test environment for normal requests - when deltas and updates are disabled by default in the test environment (perhaps I'll change that at some point).
To get around this, add the following to the bottom of config/environment.rb (outside the main block): ThinkingSphinx.deltas_enabled = true ThinkingSphinx.updates_enabled = true Generally though, I'd recommend using a different environment (just because of expectations of other libraries and Rails itself) for a test server - staging, perhaps? I'm not sure what's causing the second problem - but can you try the above change and then see if that fixes both issues? Also, can you provide a stack trace if the problem remains? Cheers -- Pat On 03/06/2011, at 8:59 PM, melissa wrote: > Hi all, > > I have (delayed) delta indexing running correctly on my development > server. Now that I've deployed my app to my test server it seems that > delayed delta indexing is running but not actually responding to any > changes. I haven't been able to find errors in log files. > > I thought maybe path settings were a problem and tried to add the > following to my sphinx.yml, but I don't see them in the generated conf > file. Is this necessary? > test: > pid_file: /Users/username/app_path/tmp/searchd.pid > searchd_file_path: /Users/username/app_path/db/sphinx > > > Another, probably unrelated, problem is that :sphinx_select in > combination with :with is working on my development server but creates > an error on the test server. I have to turn delta indexing off to > actually see the error. What I'm doing something like this: > http://freelancing-god.github.com/ts/en/common_issues.html#or_attributes > with_relevant = "*, IF((school_year=#{@school_year} AND > assessment_semester=#{@semester}) OR is_collective_assessment=1, 1, 0) > AS relevant" > @assessments = Assessment.search @search, :sphinx_select => > with_relevant, :with => {'relevant' => 1}, :without => {:assessment_id > => @id}, :page => params[:page], :per_page => 20, :star => > true, :match_mode => :boolean, :order => @order, :sort_mode => > @sort_order > > The error I'm getting is a 'no such filter attribute'. It doesn't > recognise the name 'relevant' as something usable in the :with part of > the query. Anyone understand what is going on here? > > > I'm at a dead end with these issues. I've wanted to change from ferret > to sphinx because the ferret index gets corrupted several times a day > and causes me a lot of headache. I really need to get this to work. > > My version of Sphinx 0.9.9 r2117 is the same on both servers, as are > the gem versions: > daemon_controller (0.2.6) > daemons (1.1.0, 1.0.10) > delayed_job (2.0.7) > riddle (1.3.3, 1.3.2, 1.2.2) > thinking_sphinx (1.4.4) > ts-delayed-delta (1.1.1) > > The only difference as far as I can see: > My test server is a G5 PowerPC computer with OSX 10.5.8. > My development server is an intel machine. > > Is it at all possible that my problems are hardware related? If so, > then I can put pressure on my employer to update the server hardware. > But more than anything I'm just hoping for any solutions or debugging > pointers... > > Melissa > > -- > 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.
