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 <scottma...@gmail.com> 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 thinking-sphinx+unsubscr...@googlegroups.com
> <mailto:thinking-sphinx+unsubscr...@googlegroups.com>.
> To post to this group, send email to thinking-sphinx@googlegroups.com
> <mailto:thinking-sphinx@googlegroups.com>.
> 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 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.
