Thinking Sphinx isn't built to work with tables that aren't represented by models, I'm afraid. What you're trying to do is outside the scope of TS supported functionality.
On 30 Oct 2013, at 11:33 pm, Max NudePatch <[email protected]> wrote: > Column type is integer. But there is no model for this table. > Posts has model. > But boards doesn't. > I'm just using Joins like > SELECT * FROM `posts` > INNER JOIN `board` ON (`posts`.`id_board` = `board`.`id_board`) > > This query I put into index config > set_property :sql_query => "QUERY" > > среда, 30 октября 2013 г., 18:00:58 UTC+6 пользователь Pat Allan написал: > Does id_board exist in the model's table? If so, what's the column type? > > On 30 Oct 2013, at 10:53 pm, Max NudePatch <[email protected]> wrote: > >> I want to index data with conditional joining. >> Table with posts that I want to index has some data in other table (wich >> doesn't have model) >> I used 'sql_query' property to make custom query. And it works well. >> But I need to add an additional attribute for indexing from other table. >> So when I add 'has id_board' to config file, I'm getting 'undefined method >> `type' for nil:NilClass' error. >> >> Part of trace >> /home/max/.rvm/gems/ruby-1.9.3-p392/gems/thinking-sphinx-3.0.6/lib/thinking_sphinx/active_record/attribute/type.rb:64:in >> `type_from_database' >> /home/max/.rvm/gems/ruby-1.9.3-p392/gems/thinking-sphinx-3.0.6/lib/thinking_sphinx/active_record/attribute/type.rb:17:in >> `type' >> /home/max/.rvm/gems/ruby-1.9.3-p392/gems/thinking-sphinx-3.0.6/lib/thinking_sphinx/active_record/attribute.rb:4:in >> `type' >> >> Maybe there is another way to do joins (and let SQLBuilder to construct >> query automatically)? >> >> -- >> 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 [email protected]. >> To post to this group, send email to [email protected]. >> Visit this group at http://groups.google.com/group/thinking-sphinx. >> For more options, visit https://groups.google.com/groups/opt_out. > > > -- > 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 [email protected]. > To post to this group, send email to [email protected]. > Visit this group at http://groups.google.com/group/thinking-sphinx. > For more options, visit https://groups.google.com/groups/opt_out. -- 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 [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/thinking-sphinx. For more options, visit https://groups.google.com/groups/opt_out.
