Stack Overflow
Stack Overflow

Questions tagged [thinking-sphinx]

Thinking Sphinx is a Ruby library that connects ActiveRecord models to the Sphinx search service.

Thinking Sphinx is a Ruby library that connects ActiveRecord models to the Sphinx search service.

Sphinx is a very fast search engine that indexes data and provides flexible ways of searching it. Thinking Sphinx allows you to link up your models into Sphinx simply and painlessly, and provides an interpretation of search results into ActiveRecord model instances.

875 questions
0
votes
1 answer

How to load extra fields into a model from thinking-sphinx?

I use thinking-sphinx like this : class Project < ActiveRecord::Base define_index do indexes title indexes comments.message, as: :comment_message indexes category_projects.description, as: :category_description end class << self …
Dougui
  • 7,142
  • 7
  • 52
  • 87
0
votes
1 answer

Deploying Thinking Sphinx through Capistrano yields 'Column number 6 has no name'

I'm not exactly sure where the problem I'm running into is occurring. When I run the deploy task the rake thinking_sphinx:configure works fine, but then when it tries to index it this error occurs: ERROR: index 'board_core': column 6 has no name.…
Kurt
0
votes
1 answer

Thinking-Sphinx Grouping Error

I have have the meeting model which belongs to the project: class Project < ActiveRecord::Base has_many :meetings end class Meeting < ActiveRecord::Base belongs_to :project define_index do join project indexes agenda indexes…
alexs333
  • 12,143
  • 11
  • 51
  • 89
0
votes
1 answer

Thinking Sphinx geodist search returns locations in a different city

I have Thinking Sphinx indexing locations all over the US and I need to find locations closest to a certain lat/lon. In the simplest example, I use the lat/lon of a particular city (lat/lon pulled from Google Maps API) and do a search, sorting by…
Tricnic
  • 115
  • 1
  • 6
0
votes
1 answer

How to create an index in Sphinx from a MySQL column?

In Thinking Sphinx, the Ruby plugin, I can create a sphinx index from a db column. How can I do this without Thinking Sphinx, with the indexer function, or in Python? EDIT: The column in question would be text.
user179169
0
votes
2 answers

Thinking sphinx, filtering with associations?

I have serious problem with Thinking Sphinx in my Rails application. My app specifications are as follows: Rails 3.2.6 Ruby 1.9.3 Sphinx 2.0.4 (r3135) Thinking Sphinx 2.0.12 In my application I have a Page model and a Offer model and pages have…
skipi
  • 112
  • 6
0
votes
2 answers

Indexing calculated field for search conditions in Thinking Sphinx

I have a products model set up that I am trying to search with Thinking Sphinx. The model has an attribute called status which can be Active, Not active or Active during specified dates. I would like to be able to restrict my search results to…
Caps
  • 1,493
  • 1
  • 16
  • 24
0
votes
1 answer

thinking_sphinx nested date search

Let's say I've got the following scenario: class Conference < ActiveRecord::Base has_many :meetings define_index do # index end end class Meeting < ActiveRecord::Base belongs_to :conference validates_presence_of…
alexs333
  • 12,143
  • 11
  • 51
  • 89
0
votes
2 answers

Thinking-Sphinx not returning any results in console or via web app

Similar to these: sphinx-not-indexing, thinking-sphinx returning empty results in console, similar here The problem description is this: I can't get any results with any parameters from Sphinx. I have a hdd scaffold, and when I try and perform a…
Adam Miller
  • 1,756
  • 1
  • 25
  • 44
0
votes
2 answers

Auto-generate Tags with ElasticSearch (or Thinking Sphinx / pg-search )

I've thought about this a bit (and looked at every "auto-generate tags for content" type post on StackOverflow). I have an Article (body:string) with multiple Tags (joined through Taggings). Right now in the app, in order to suggest tags for the…
Doug
  • 293
  • 1
  • 2
  • 10
0
votes
1 answer

Are Sphinx & thinking_sphinx really stable? Not indexing Columns

I'm encountering strange behaviour from thinking_sphinx/sphinx. My define_index block is about 100 lines, so quite a lot of columns i'm indexing. For full-text searching I only need about 10 attributes, for sorting and filtering I have another…
seb
  • 3,274
  • 4
  • 22
  • 16
0
votes
1 answer

Sphinx Search mysql client on production server

I want to connect to SphinxQL on my production server to execute sphinx queries on mysql database, Please note I ran the following commands in the production server terminal(Ubuntu 10.04) by connecting to it remotely. mysql -h 127.0.0.1 -P…
beck03076
  • 3,268
  • 2
  • 27
  • 37
0
votes
1 answer

Sphinx searcing related has_many with thinkingsphinx

Hypothetically, I have a Room model that belongs to a Building model. Buildings has a has_many relationship with categories. I'm trying to figure out how to index the Room model so that a search for category_id = 1 will return any room, in any…
Nathan
0
votes
1 answer

Problems with indexer query with Thinking Sphinx and Postgresql in productio

I am using Rails 3.2.3, Sphinx 2.0.1 beta and Postgresql 9.1.3 in development, with this index: define_index do indexes :name indexes :city has :id has :gender_cd, as :gender, type: :integer has "extract(year from age(birthdate))", as:…
Nikolay Shebanov
  • 1,363
  • 19
  • 33
0
votes
1 answer

Thinking Sphinx with has_many through indexes just fine but saving item crashes

Thinking sphinx indexes just fine and lookup works well on my attributes. However, my attempt to save a model instance crashes. class Location < ActiveRecord::Base has_many :operation_intervals_locations has_many :operation_intervals, :through…
Abdo
  • 13,549
  • 10
  • 79
  • 98
1 2 3
…
58 59