I saw some other messages on this but I think this problem is slightly
different. Some background - have been using the TS plugin (version
1.2.9) and am now upgrading to 1.3.16. I am running rails 2.3.5 on Mac
OS 10.5.
Models
======
class Lesson < ActiveRecord::Base
has_many :bucket_lessons
has_many :buckets, :through => :bucket_lessons
end
class BucketLesson < ActiveRecord::Base
belongs_to :bucket
belongs_to :lesson
end
class Bucket < ActiveRecord::Base
has_many :bucket_lessons
has_many :lessons, :through => :bucket_lessons
end
Lesson Index
==========
has buckets(:id), :as => :bucket_ids
The search call is:
@bucket.lessons.search "string"
This worked fine with version 1.2.9, but in 1.3.16 it throws the error
"Missing Attribute for Foreign Key bucket_id"
I added some logging into has_many_association.rb file in the
'attribute_for_foreign_key' method:
Here is what is being logged:
"COLUMNS are #{attrib.columns.inspect} AND
#{attrib.columns.first.__name}"
The results are:
[#<ThinkingSphinx::Index::FauxColumn:0x7452228 @name=:id,
@stack=[:buckets]>] AND id
In version 1.2.9 TS would combine the stag and name to check the
foreign key. But in 1.3.16 it is just checking the name which is
incorrect. Therefore it never finds the bucket_id foreign key.
By changing the index I can get it to work.
has bucket_lessons(:bucket_ids), :as => :bucket_ids
But that it not ideal.
Was this a deliberate change in the upgrade to 1.3 or is this a bug?
Greg DeVore
Blue Mango Learning Systems
--
You received this message because you are subscribed to the Google Groups
"Thinking Sphinx" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/thinking-sphinx?hl=en.
