Can you try upgrading Sphinx to 2.0.6 or 2.0.7?
On 23/05/2013, at 11:30 PM, pix_plm wrote:
> Hi,
> I've upgraded from TS2 to TS3 and I can"t make facets work.
> For instance, with my model Statistic, search is ok but facet no
> facets = Statistic.facets(mystring)
> facet.each{| f, f_option| puts f} gets error :
> ThinkingSphinx::SyntaxError: sphinxql: syntax error, unexpected ',',
> expecting IDENT near ', @count FROM `statistic_core`, `statistic_delta` WHERE
> MATCH('hollande @sphinx_internal_class_name (Statistic)') AND sphinx_deleted
> = 0 GROUP BY sphinx_internal_class LIMIT 0, 20 OPTION max_matches=10000; SHOW
> META; SELECT *, *, @groupby, @count FROM `statistic_core`, `statistic_delta`
> WHERE MATCH('hollande @sphinx_internal_class_name (Statistic)') AND
> sphinx_deleted = 0 GROUP BY provider_id LIMIT 0, 20 OPTION max_matches=10000;
>
> statistic_index.rb :
> ThinkingSphinx::Index.define(:statistic, :with => :active_record, :delta =>
> true) do
> indexes user.login, :as => :user_login, :sortable => true
> indexes user.title.name, :as => :title_name, :sortable => true
> indexes image.provider.name, :as => :provider_name, :sortable => true
> indexes image.creator, :as => :creator, :sortable => true
> indexes image.headline, :as => :headline, :sortable => true
> indexes image.description, :as => :description
> indexes image.subject, :as => :subject
>
> # attributes
> has user_id, image_id, created_at
> has user.title_id, :as => :title_id
> has image.provider_id, :as => :provider_id, :facet => true
> has operation_label_id
> end
>
> thinking-shpinx.yml :
> morphology: none
> enable_star: true
> min_prefix_len: 3
> html_strip: 1
> mem_limit: 1024M
> max_matches: 10000
> bin_path: '/usr/local/bin'
>
>
> configuration
> Sphinx 2.0.1-beta (r2792)
> TS 3.0.3
> mysql2 (0.3.12b6)
> Rails 3.2.13
>
> Anyone to help me ?
> Thanks
> P
>
>
> --
> 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?hl=en.
> 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?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.
