Okay, testing this further, the issue seems to be related to the latest two releases of jdbc-mysql (5.1.36 and 5.1.37). If you specifically request 5.1.35 in your Gemfile, queries should work.
I’ve raised the problem on the Sphinx forum so those more involved in Sphinx itself are aware of the issue: http://sphinxsearch.com/forum/view.html?id=13939 <http://sphinxsearch.com/forum/view.html?id=13939> Also: you do not need the mysql_version_string setting - I’d forgotten that Thinking Sphinx will do this for you automatically, so it’s completely unnecessary to have this in your own config file. — Pat > On 18 Nov 2015, at 4:43 pm, Pat Allan <[email protected]> wrote: > > … sorry, I meant the jdbc-mysql library, not ruby-mysql. Which does raise the > question: which version of jdbc-mysql are you using? > >> On 18 Nov 2015, at 4:17 pm, Pat Allan <[email protected] >> <mailto:[email protected]>> wrote: >> >> 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] >>> <mailto:[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] >> <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] > <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.
