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