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.

Reply via email to