Hi Scott Sounds like the `ts:regenerate` task might not be stopping the Sphinx daemon. Can you try the following:
* run `rake ts:stop` * check that the daemon is not running using `ps aux | grep searchd` - you don’t want to see any searchd processes. * manually kill any searchd processes if they are still running * run `rake ts:regenerate` Hope this sorts it out. — Pat > On 2 Aug 2016, at 3:05 AM, Scott Macri <[email protected]> wrote: > > Thanks for your help, but unfortunately this causes a different error when > running 'rake ts:regenerate': > ThinkingSphinx::SphinxError: unknown column: 'bbc_compliance_names' - REPLACE > INTO bbc_facility_core (id, `sphinx_internal_class_name`, `name`, > `bbc_compliance_names`, `sphinx_internal_id`, `sphinx_internal_class`, > `sphinx_deleted`, `name_sort`) VALUES ('all values for fields are actually > listed here') > > On Friday, July 22, 2016 at 11:52:44 PM UTC-4, Scott Macri wrote: > Hello, > > I'm new to sphinx and am attempting a has_many_through. I'm using Rails 4.2 > and Ruby 2.2. I'm getting the following error when running config. > ThinkingSphinx::SphinxError: unknown column: 'bbc_compliances' - REPLACE INTO > bbc_facility_core > > Here is my setup: > > ThinkingSphinx::Index.define :bbc_facility, :with => :real_time do > indexes name, sortable: true > indexes bbc_compliances.name <http://bbc_compliances.name/>, :as => > :bbc_compliances > end > > class BbcCompliance < ActiveRecord::Base > has_many :bbc_facility_compliances, dependent: :destroy > has_many :bbc_facilities, through: :bbc_facility_compliances > end > > class BbcFacility < ActiveRecord::Base > after_save ThinkingSphinx::RealTime.callback_for(:bbc_facility) > has_many :bbc_facility_compliances, dependent: :destroy > has_many :bbc_compliances, through: :bbc_facility_compliances > end > > Any help would be greatly appreciated. Also, where can I find some > documentation on complex topics such as this one? Thanks. > > > > -- > 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] > <mailto:[email protected]>. > To post to this group, send email to [email protected] > <mailto:[email protected]>. > Visit this group at https://groups.google.com/group/thinking-sphinx > <https://groups.google.com/group/thinking-sphinx>. > For more options, visit https://groups.google.com/d/optout > <https://groups.google.com/d/optout>. -- 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 https://groups.google.com/group/thinking-sphinx. For more options, visit https://groups.google.com/d/optout.
