Hi Govinda Sorry, I'm not yet sure what the cause of this problem is. If you're performing a search, there should be the SphinxQL statement in your development log - most certainly when accessing via a browser, but I would expect it even via Rails' console. That should could some clues as to what's different with the SphinxQL queries you've been testing directly.
-- Pat On 17/01/2013, at 6:05 PM, [email protected] wrote: > What I meant with it works is that the generation of the index works... not > the search itself... > I get results when I query sphinx directly with qlsql... but still not from > thinking_sphinx itself... > > Govinda > > > Am Mittwoch, 16. Januar 2013 08:10:03 UTC+1 schrieb > [email protected]: > with a different name it works... :-) > > Am Mittwoch, 16. Januar 2013 00:01:32 UTC+1 schrieb Pat Allan: > Ah, I guess status is a keyword with Sphinx. I'll have to put a patch in for > that… in the meantime, does it work if you give the attribute a different > name? > has status, :as => :image_status, :type => :integer > > On 16/01/2013, at 1:06 AM, [email protected] wrote: > > > And for the following line in my index definition > > > > has status, :type => :integer > > > > the index generation fails: > > > > /workspace/imageserver_xinet thinking_sphinx_edge ✗ ➤ zeus rake ts:generate > > > > > > [5s] > > Generating index files for image_core > > Error with statement: REPLACE INTO image_core (id, > > sphinx_internal_class_name, file, file_width, file_height, file_colorspace, > > file_type, file_resolution, file_depth, description, category, tags, > > campaigns, image_type_name, sphinx_internal_id, sphinx_internal_class, > > sphinx_deleted, aspect_ratio, chromaticity, origin, image_type, > > licencetype, client_id, user_id, created_at, updated_at, status) VALUES > > (2640, 'Image', > > '/Users/govindafichtner/workspace/imageserver_xinet/uploads/development/original/standortaktiv/client_images/0000/0/1/hier_wird_modernisiert_0000010o.pdf', > > '867', '442', 'DirectClass sRGB Matte', 'application/pdf', '72', '16', '', > > 'client_images', '', '', '', 1320, 'Image', 0, 4081532648, 0, 0, 0, 0, 11, > > 0, 1353509710, 1353509723, 0) > > rake aborted! > > sphinxql: syntax error, unexpected STATUS, expecting IDENT (or 4 other > > tokens) near 'status) VALUES (2640, 'Image', > > '/Users/govindafichtner/workspace/imageserver_xinet/uploads/development/original/standortaktiv/client_images/0000/0/1/hier_wird_modernisiert_0000010o.pdf', > > '867', '442', 'DirectClass sRGB Matte', 'application/pdf', '72', '16', '', > > 'client_images', '', '', '', 1320, 'Image', 0, 4081532648, 0, 0, 0, 0, 11, > > 0, 1353509710, 1353509723, 0)' > > -e:1:in `<main>' > > Tasks: TOP => ts:generate > > (See full trace by running task with --trace) > > > > 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/-/F7qxQxuZ31wJ. > > 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 view this discussion on the web visit > https://groups.google.com/d/msg/thinking-sphinx/-/U6pU2wwdBr4J. > 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.
