What if you add this: group_by 'spots.id'
Also: is id the primary key of the model? -- Pat On 30/08/2011, at 10:26 PM, David Krmpotic wrote: > Pat, > > No, unfortunately it didn't help... > > david > > On Aug 30, 1:09 pm, Pat Allan <[email protected]> wrote: >> Hi David >> >> Not seeing anything that *exactly* relates to the error you are seeing, but >> given you're using PostgreSQL, any columns that aren't aggregated and are >> used in SQL snippets will need to be grouped by - so, this means lat, lng, >> status and uploaded_as. >> >> So, try adding this to the define_index block somewhere: >> >> group_by 'lat', 'lng', 'status', 'uploaded_as' >> >> Does that help things at all? >> >> -- >> Pat >> >> On 30/08/2011, at 9:01 PM, David Krmpotic wrote: >> >> >> >> >> >> >> >>> Hi Pat, >> >>> define_index do >>> indexes :name, company, description, street, loc_info, zip, city, >>> services, tags, hidden, internal, country >> >>> has 'RADIANS(lat)', :as => :lat, :type => :float >>> has 'RADIANS(lng)', :as => :lng, :type => :float >> >>> # sphinx converts string attributes to integers internally, but we >>> don't know to what... >>> # to be able to filter on these values we need a (known) integer >>> hash function >>> # and since psql doesn't support CRC32, we invent one - it's >>> basically first 8 integer digits from md5 hash of the field >>> has "cast(substring(translate(md5(status), 'abcdef', '') from 1 >>> for 8) as integer)", :as => :status_hash, :type => :integer >>> has "cast(substring(translate(md5(uploaded_as), 'abcdef', '') from >>> 1 for 8) as integer)", :as => :uploaded_as_hash, :type => :integer >>> has :wifi >>> has :student_coupon >>> has :has_active_deal >> >>> set_property :field_weights => {'name' => 50, 'company' => 1000, >>> 'city' => 80} >>> set_property :delta => true >>> end >> >>> Postgresql: 8.4.0 >>> TS: 1.3.2 >> >>> I ment normal associated model.. >> >>> Thank you! >>> david >> >>> On Aug 27, 5:11 am, Pat Allan <[email protected]> wrote: >>>> Hi David >> >>>> Is there anything else in the define_index block? And which versions of >>>> Thinking Sphinx and PostgreSQL are you using? >> >>>> Also: when you say submodel, do you mean associated model? Or is there >>>> some inheritance as part of all of this? >> >>>> Cheers >> >>>> -- >>>> Pat >> >>>> On 25/08/2011, at 7:13 PM, David Krmpotic wrote: >> >>>>> Hello, >> >>>>> I have a problem with indexing a submodel attribute. >> >>>>> class Spot < ... >>>>> has_many :deals >> >>>>> define_index do >>>>> indexes :name, company, description >>>>> indexes deals.title, :as => :deal >>>>> end >>>>> end >> >>>>> I get this: ERROR: index 'spot_core': sql_range_query: ERROR: column >>>>> "spots.id" must appear in the GROUP BY clause or be used in an >>>>> aggregate function >>>>> LINE 1: SELECT "spots"."id" * 2 + 1 AS "id" , "spots"."name" AS >>>>> "nam... >> >>>>> I'm using Postgres. >> >>>>> The error disappears when I remove indexes deals.title, :as => :deal >> >>>>> Can you please help? >>>>> Thank you! >> >>>>> David >> >>>>> -->>> You received this message because you are subscribed to the Google >>>>> Groups "Thinking Sphinx" group.> To post to this group, send >>>>> [email protected].> To unsubscribe from this group, >>>>> send [email protected]. >>>>> For more options, visit this group >>>>> athttp://groups.google.com/group/thinking-sphinx?hl=en. >> >>> -- >>> You received this message because you are subscribed to the Google Groups >>> "Thinking Sphinx" group.> To post to this group, send email >>> [email protected].> To unsubscribe from this group, send >>> email [email protected]. >>> For more options, visit this group >>> athttp://groups.google.com/group/thinking-sphinx?hl=en. > > -- > 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. > -- 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.
