Still doesn't help :\ Yes, it's the primary key! On Aug 31, 1:21 am, Pat Allan <[email protected]> wrote: > 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, > >>>>> [email protected].> To unsubscribe from this > >>>>> group, [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 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.
