Yes, I actually am trying to figure the exact nested sets out as well. If anyone can provide any input, it would be helpful.
Manish On Aug 25, 6:28 am, mix <[email protected]> wrote: > 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 -~----------~----~----~----~------~----~------~--~---
