Ah noted on the lower-case symbol will do adjustments accordingly! Here are the other index definition:
ThinkingSphinx::Index.define :PocketWifi, :with => :real_time do # fields indexes number_of_user, :sortable => true, :match_mode => :any, :sort_mode => :desc indexes origin_country, :sortable => true, :match_mode => :any, :sort_mode => :desc indexes destination_country, :sortable => true, :match_mode => :any, :sort_mode => :desc ThinkingSphinx::Index.define :SimSize, :with => :real_time do # fields indexes sim_name, :sortable => true, :match_mode => :any, :sort_mode => :desc indexes sim_type, :sortable => true, :match_mode => :any, :sort_mode => :desc ThinkingSphinx::Index.define :Rechargeable, :with => :real_time do # fields indexes recharge_quota, :sortable => true, :match_mode => :any, :sort_mode => :desc indexes recharge_price, :sortable => true, :match_mode => :any, :sort_mode => :desc indexes recharge_desc, :sortable => true, :match_mode => :any, :sort_mode => :desc I figured it was a problem with the where clause during the query and made some adjustments. It is working but can I assign thinking sphinx search to only search through an index? @results = ThinkingSphinx.search( :with => { :country_id => "#{params[:country]}", :plan_day => "#{params[:duration]}"}, :select => '*', :indices => ['Provider_core', 'Source_core'] ) provider_core contains country but source_core does not and it's giving me an error due to that, any way I can simplify this? -- 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 thinking-sphinx+unsubscr...@googlegroups.com. To post to this group, send email to thinking-sphinx@googlegroups.com. Visit this group at https://groups.google.com/group/thinking-sphinx. For more options, visit https://groups.google.com/d/optout.