Hi Georgina What version of Sphinx are you using? TS v3.1.0 expects Sphinx 2.1.2 or newer by default... if you're using something older, have a read of the latest release notes to adapt things accordingly: https://github.com/pat/thinking-sphinx/releases/tag/v3.1.0
If you're on Sphinx 2.1.2 or something more recent than that, then my presumption is wrong... let me know either way. Cheers -- Pat On 5 Feb 2014, at 2:58 pm, Georgina Wood <[email protected]> wrote: > Hi Pat, > > I'm back with a different problem this time. > I would like to implement facets but I keep getting this groupby error. > I also tried the a normal search with the :group_by option and it came back > with the same error. > > This isn't urgent but it would be nice to have. > Thanks for your help, > > Georgina > > @search = ThinkingSphinx.search Riddle::Query.escape(params["keywords"]), > :classes => classes(), # [Dr::Accounts,Cr::Accounts] > :page => page, > :per_page => limit, > :star => true > > @facets = @search.facets > > p @facets > print @facets.to_hash > > > > #<ThinkingSphinx::FacetSearch:0xa263720 > @options={:classes=>[Dr::Accounts(debtor_id: string, name_key: string, > dr_unique_id: integer, address_key: string, financial_id: string, > ... > update_time: timestamp)], :page=>1, :per_page=>100, :star=>true}, > @query="wood", @hash={}> > ThinkingSphinx::ParseError - index dr_accounts_core: parse error: unknown > identifier 'groupby' (not an attribute, not a function): > > /H/georgina/.gem/ruby/1.9.1/gems/thinking-sphinx-3.1.0/lib/thinking_sphinx/connection.rb:90:in > `rescue in query' > > /H/georgina/.gem/ruby/1.9.1/gems/thinking-sphinx-3.1.0/lib/thinking_sphinx/connection.rb:93:in > `query' > > /H/georgina/.gem/ruby/1.9.1/gems/thinking-sphinx-3.1.0/lib/thinking_sphinx/connection.rb:75:in > `query_all' > > /H/georgina/.gem/ruby/1.9.1/gems/thinking-sphinx-3.1.0/lib/thinking_sphinx/search/batch_inquirer.rb:17:in > `block in results' > > /H/georgina/.gem/ruby/1.9.1/gems/thinking-sphinx-3.1.0/lib/thinking_sphinx/connection.rb:37:in > `block in take' > /usr/lib/ruby/gems/1.9.1/gems/innertube-1.1.0/lib/innertube.rb:138:in > `take' > ... > > > > > > > -- > 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.
