This one's a little more surprising… you should see the full SphinxQL command in your logs when Image.search is called - can you confirm what that is, and whether you see results using it directly via mysql?
-- Pat On 15/01/2013, at 12:15 AM, [email protected] wrote: > OK. And the next problem I have when I generate a realtime index with only > the attributes that I got working until now is > that searching seems not work at all for me: > > [13] pry(main)> Image.search('sphinx') > [] > > But when I am connecting directly to sphinx via mysql: > > mysql> select * from image_core where match('sphinx'); > +------+--------+--------------------+----------------+--------+-----------------------+ > | id | weight | sphinx_internal_id | sphinx_deleted | origin | > sphinx_internal_class | > +------+--------+--------------------+----------------+--------+-----------------------+ > | 3390 | 1692 | 1695 | 0 | 3 | Image > | > | 3392 | 1692 | 1696 | 0 | 3 | Image > | > | 3394 | 1692 | 1697 | 0 | 3 | Image > | > +------+--------+--------------------+----------------+--------+-----------------------+ > 3 rows in set (0.00 sec) > > I am a little lost what I might be doing wrong... > > Govinda > > > > Am Montag, 14. Januar 2013 12:15:52 UTC+1 schrieb [email protected]: > Hello guys, > > after the announcement here https://github.com/pat/thinking-sphinx/issues/186 > that there is some support for realtime indexes I gave it shot and tried to > port my existing (and working) thinking_sphinx v2 indexes and tried to port > them to the new v3 syntax... > > ThinkingSphinx::Index.define :image, :with => :real_time do > # indexes assoc(:file) > indexes file_width > indexes file_height > indexes file_colorspace > indexes file_content_type, :as => :file_type > indexes file_resolution > indexes file_depth > indexes description > indexes category > indexes tags > indexes campaigns > indexes image_type.name, :as => :image_type_name > # has "CRC32(file_chromaticity)", :as => :chromaticity, :type => :integer > # has "CRC32(file_aspect_ratio)", :as => :aspect_ratio, :type => :integer > has image_origin_id, :as => :origin > # has image_licencetype_id, :as => :licencetype > # has image_type_id, :as => :image_type > # has client_id > # has user_id > # has created_at > # has updated_at > # has status > end > > When I do a "rake ts:generate" I get the following error: > > rake aborted! > Unknown attribute type '' > > Does anybody know how I have to change my indexes to get them to play nicely > with sphinx3? > I am using the edge branch with Rails 3.2.9, Ruby 1.9.3 and sphinx 2.0.6. > > Cheers, Govinda > > -- > You received this message because you are subscribed to the Google Groups > "Thinking Sphinx" group. > To view this discussion on the web visit > https://groups.google.com/d/msg/thinking-sphinx/-/EK7lcZXrOMIJ. > 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. -- 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.
