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, :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.
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.
