Hi Nataly
You’ll want to do two things. Firstly, update/add Riddle in your Gemfile:
gem ‘riddle’, ‘~> 1.5.9’,
:git => ‘git://github.com/pat/riddle.git',
:branch => ‘develop’,
:ref => ‘01d35a37b8’
And then, change @random to RAND(). I pushed a fix for Riddle to avoid escaping
functions yesterday, hence why you’ll need that latest commit, and SphinxQL
expects RAND() instead of @random (Sphinx is deprecating special @-variables
and replacing them with functions).
Cheers
—
Pat
On 30 Oct 2013, at 3:55 am, [email protected] wrote:
> Hello,
>
> Since we have updated to version 3.0.6 we have an error with the random
> sorting :
> ThinkingSphinx::SyntaxError (sphinxql: syntax error, unexpected USERVAR,
> expecting IDENT (or 5 other tokens) near '@random ASC LIMIT 0, 40 OPTION
> max_matches=10 000; SHOW META'):
> Has the syntax changed?
>
> Here what i can see in the model (sorry i'm new to ruby and rails) :
> sphinx_scope(:by_random) {
> {:sort_mode => :extended, :order =>'@random ASC'}
> }
>
> Thank in advance for your help,
>
> Nataly
>
> --
> 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.
--
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.
