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].
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.
