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.
