Hi Pat, Updating jdbc-mysql version from 5.1.37 to 5.1.35 solved the problem.
Thank you so much. Regards, Suresh. On Thursday, November 19, 2015 at 2:35:36 AM UTC+5:30, Pat Allan wrote: > > 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 > > 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] > <javascript:>> 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] > <javascript:>> 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] <javascript:> 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] <javascript:>. > To post to this group, send email to [email protected] > <javascript:>. > Visit this group at http://groups.google.com/group/thinking-sphinx. > For more options, visit 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] <javascript:>. > To post to this group, send email to [email protected] > <javascript:>. > Visit this group at http://groups.google.com/group/thinking-sphinx. > For more options, visit 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] <javascript:>. > To post to this group, send email to [email protected] > <javascript:>. > Visit this group at http://groups.google.com/group/thinking-sphinx. > For more options, visit 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.
