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]<javascript:>> > 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] <javascript:>. > To post to this group, send email to [email protected]<javascript:> > . > 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.
