Thanks one again Pat, it was the problem I upgraded Sphinx to 2.0.7 and it did
work fine
Best regards
P
Le 23 mai 2013 à 15:34, Pat Allan a écrit :
> 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 a topic in the Google
> Groups "Thinking Sphinx" group.
> To unsubscribe from this topic, visit
> https://groups.google.com/d/topic/thinking-sphinx/zn-o2drCiws/unsubscribe?hl=en.
> To unsubscribe from this group and all its topics, 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.
