I'm playing with rails associations, but with any luck. I've add this
index rule:
has category.all_categories(:id), :as => :all_categories, :facet
=> true
and then in the category model:
has_many :all_categories, :class_name => 'Category', :finder_sql =>
'SELECT * FROM categories c WHERE c.lft <= #{lft} and c.rgt >= #{rgt}
ORDER BY c.lft ASC'
I've tried it in the console with a Category.last.all_categories and
it works. But when i do a rake ts:in I get this:
ERROR: index 'article_core': sql_range_query: Unknown column
'all_categories_categories.category_id' in 'on clause' (DSN=mysql://
rails:*...@localhost:3306/App_development).
Looking in the sphinx.conf generated I don't find any lft or rgt
string, it seems that it doesn't apply the sql used by the finder_sql.
Any hint?
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
