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.
