Upgraded thinking_sphinx 2 to 3, Rails 3.1
Item.search( :with => { :item_set_id => [] } )
Sphinx Query (0.9ms) SELECT * FROM `item_core`, `item_delta` WHERE
`item_set_id` IN () AND `sphinx_deleted` = 0 LIMIT 0, 20 OPTION
ThinkingSphinx::SyntaxError: sphinxql: syntax error, unexpected ')',
expecting CONST_INT or '-' near ') AND `sphinx_deleted` = 0 LIMIT 0, 20
OPTION max_matches=200000; SHOW META'
That same line of Ruby worked properly with thinking_sphinx 2. Is the
problem obvious? Logically, the generated query is what I'm looking for...
but Sphinx does not like the empty list -- `item_set_id` IN ().
Thinking_sphinx2 must've handled this differently.
Thank you
Adam
--
You received this message because you are subscribed to the Google Groups
"Thinking Sphinx" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/thinking-sphinx.
For more options, visit https://groups.google.com/groups/opt_out.
