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.
