Hi, I keep getting the following error (ThinkingSphinx::NoIndicesError - see below) when I try to call DR::Accounts.search 'Smith' . I have no problems when I do a global search (ThinkingSphinx.search) and have no problems with rake ts:configure, ts:index and ts:start. I also have no problems with calling DR::Accounts.find(:first) using just active record.
I am using Sinatra (1.3.2) and thinking-sphinx (3.1.0) I'm not sure if the structure I am using is entirely correct. Any feedback would be appreciated. *rackup -p 4567* api server started Starting Creditors-CR on /api/creditors/CR ... Starting ClientPortal on /api/clientportal Starting Search on /api/search All Started >> Thin web server (v1.5.1 codename Straight Razor) >> Maximum connections set to 1024 >> Listening on 0.0.0.0:4567, CTRL+C to stop *ThinkingSphinx::NoIndicesError - ThinkingSphinx::NoIndicesError: /H/georgina/.gem/ruby/1.9.1/gems/thinking-sphinx-3.1.0/lib/thinking_sphinx/middlewares/sphinxql.rb:137:in `indices' /H/georgina/.gem/ruby/1.9.1/gems/thinking-sphinx-3.1.0/lib/thinking_sphinx/middlewares/sphinxql.rb:25:in `call' /H/georgina/.gem/ruby/1.9.1/gems/thinking-sphinx-3.1.0/lib/thinking_sphinx/middlewares/sphinxql.rb:11:in `block in call' /H/georgina/.gem/ruby/1.9.1/gems/thinking-sphinx-3.1.0/lib/thinking_sphinx/middlewares/sphinxql.rb:10:in `each' /H/georgina/.gem/ruby/1.9.1/gems/thinking-sphinx-3.1.0/lib/thinking_sphinx/middlewares/sphinxql.rb:10:in `call' /H/georgina/.gem/ruby/1.9.1/gems/thinking-sphinx-3.1.0/lib/thinking_sphinx/middlewares/stale_id_filter.rb:10:in `call'* * /usr/lib/ruby/gems/1.9.1/gems/middleware-0.1.0/lib/middleware/runner.rb:31:in `call' /usr/lib/ruby/gems/1.9.1/gems/middleware-0.1.0/lib/middleware/builder.rb:102:in `call' /H/georgina/.gem/ruby/1.9.1/gems/thinking-sphinx-3.1.0/lib/thinking_sphinx/search.rb:67:in `populate' /H/georgina/.gem/ruby/1.9.1/gems/thinking-sphinx-3.1.0/lib/thinking_sphinx/search.rb:113:in `method_missing' /s/home/georgina/module/api/search.rb:37:in `block in <class:ApiSearch>'* /usr/lib/ruby/gems/1.9.1/gems/sinatra-1.3.6/lib/sinatra/base.rb:1293:in `call' /usr/lib/ruby/gems/1.9.1/gems/sinatra-1.3.6/lib/sinatra/base.rb:1293:in `block in compile!' ... *Gemfile:* source 'http://rubygems.org' gem 'mysql2', '~> 0.3.13' gem 'sinatra', '~> 1.3.2' gem 'sqlite3', '~> 1.3.7' gem 'json', '~> 1.6.8' # Bundle the extra gems: gem 'activerecord', '~> 3.2.14' gem 'activerecord-import', '~> 0.3.1' gem 'savon', '~> 2.3.0' gem 'thinking-sphinx', :require => 'thinking_sphinx/sinatra' gem 'rake' *Rakefile:* require 'thinking_sphinx/tasks' require 'thinking_sphinx/sinatra' task :environment do require File.expand_path('config/environment', File.dirname(__FILE__)) end *config/environment.rb:* require './api_server_lib.rb' (active record base, establish_connection) require './app/models/DR.rb' load 'app/indicies/DR.rb' *search.rb* require 'thinking_sphinx/sinatra' require './config/environment.rb' class ApiSearch < ApiServer addTemplate({ :url => '/api/search/applications?{parameters}', :options => "GET" }) get '/applications' do p 'params: '+params.to_s #street = ThinkingSphinx.search params['keywords'] #return street.to_s #p DR::Accounts.find(:first) road = DR::Accounts.search 'road' p road.to_s #ave = ThinkingSphinx.search 'ave' , :classes => [DR::Accounts] #p ave #'here' end *Indicies:* *app/indicies/DR.rb:* module DR def self.table_name_prefix 'dr_' end load 'app/indicies/DR/accounts.rb' end *app/indicies/DR/accounts.rb:* ThinkingSphinx::Index.define 'DR/accounts', :with => :active_record do indexes debtor_id, :sortable => true indexes first_name indexes surname indexes address_1 indexes address_2 indexes address_3 indexes address_4 exclude control account where "debtor_id NOT RLIKE '^ {7}9'" end -- You received this message because you are subscribed to the Google Groups "Thinking Sphinx" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/thinking-sphinx. For more options, visit https://groups.google.com/groups/opt_out.
