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.
