Hi Suresh
I think this is related to JRuby (perhaps the ruby-mysql library)… one thing
that may help is adding `mysql_version_string: 5.5.21` to each environment in
`config/thinking_sphinx.yml` (you’ll need to create the file if you don’t have
it already):
development:
mysql_version_string = 5.5.21
test:
mysql_version_string = 5.5.21
production:
mysql_version_string = 5.5.21
Once you’ve made this change, run `rake ts:rebuild`.
If that doesn’t help, can you let us know which version of Sphinx you’re using?
Cheers
—
Pat
> On 18 Nov 2015, at 3:59 pm, [email protected] wrote:
>
> Hi,
>
> I am new to thinking sphinx.
>
> I am using torquebox server version 3.1.2 and i am running it in jruby mode
> and jruby version is 1.7.13 to run my application.
>
> Thinking Sphinx version is 3.1.4 and i don't have any issues to run the
> sphinx server.
>
> Whenever i search the keyword thinking sphinx giving the following error.
>
> ThinkingSphinx::SyntaxError (sphinxql: syntax error, unexpected AS, expecting
> $end near 'AS auto_increment_increment, @@character_set_client AS
> character_set_client, @@character_set_connection AS character_set_connection,
> @@character_set_results AS character_set_results, @@character_set_server AS
> character_set_server, @@init_connect AS init_connect, @@interactive_timeout
> AS interactive_timeout, @@license AS license, @@lower_case_table_names AS
> lower_case_table_names, @@max_allowed_packet AS max_allowed_packet,
> @@net_buffer_length AS net_buffer_length, @@net_write_timeout AS
> net_write_timeout, @@query_cache_size AS query_cache_size, @@query_cache_type
> AS query_cache_type, @@sql_mode AS sql_mode, @@system_time_zone AS
> system_time_zone, @@time_zone AS time_zone, @@tx_isolation AS tx_isolation,
> @@wait_timeout AS wait_timeout' - SELECT * FROM `community_core`,
> `community_delta`, `cg_community_profile_core`, `cg_community_profile_delta`
> WHERE MATCH('user') AND `profile_id` IN (79) AND `sphinx_deleted` = 0 LIMIT
> 0, 20 OPTION field_weights=(first_name=150, last_name=150,
> community_name=10); SHOW META):
>
> /usr/local/rvm/gems/jruby-1.7.13/bundler/gems/thinking-sphinx-c8f549f68907/lib/thinking_sphinx/connection.rb:93:in
> `query'
>
> /usr/local/rvm/gems/jruby-1.7.13/bundler/gems/thinking-sphinx-c8f549f68907/lib/thinking_sphinx/connection.rb:77:in
> `query_all'
>
> /usr/local/rvm/gems/jruby-1.7.13/bundler/gems/thinking-sphinx-c8f549f68907/lib/thinking_sphinx/search/batch_inquirer.rb:17:in
> `results'
>
> /usr/local/rvm/gems/jruby-1.7.13/bundler/gems/thinking-sphinx-c8f549f68907/lib/thinking_sphinx/connection.rb:39:in
> `take'
> innertube (1.1.0) lib/innertube.rb:138:in `take'
>
> Could anyone give the reason for this error?
>
> Regards,
> Suresh.
>
> --
> 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]
> <mailto:[email protected]>.
> To post to this group, send email to [email protected]
> <mailto:[email protected]>.
> Visit this group at http://groups.google.com/group/thinking-sphinx
> <http://groups.google.com/group/thinking-sphinx>.
> For more options, visit https://groups.google.com/d/optout
> <https://groups.google.com/d/optout>.
--
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/d/optout.
