ruby on rails - Textacular Fuzzy Search -

-

i trying implement the textacular gem in rails 4 app. basic , advanced search work fine, when try implement fuzzy search, encounter trouble.

installation instructions repository:

finally, #fuzzy_search method lets use postgres's trigram search funcionality.

in order use this, you'll need make sure database has pg_trgm module installed. on development machine, can require textacular/tasks , run

rake textacular:install_trigram

depending on production environment, might able use rake task, or might have manually run command. postgres 9.1 , above, you'll want run

create extension pg_trgm;

what i've tried

i tried running rake textacular:install_trigram , bundle exec rake textacular:install_trigram in root directory of app , message:

/usr/local/cellar/postgresql/9.2.4/share/postgresql/extension/pg_trgm.control rake aborted! pg::insufficientprivilege: error:  permission denied create extension "pg_trgm" hint:  must superuser create extension. : create extension pg_trgm; /users/ssapra/.rvm/gems/ruby-2.0.0-p247/gems/activerecord-4.0.0/lib/active_record/connection_adapters/postgresql/database_statements.rb:128:in `exec' /users/ssapra/.rvm/gems/ruby-2.0.0-p247/gems/activerecord-4.0.0/lib/active_record/connection_adapters/postgresql/database_statements.rb:128:in `block in execute' /users/ssapra/.rvm/gems/ruby-2.0.0-p247/gems/activerecord-4.0.0/lib/active_record/connection_adapters/abstract_adapter.rb:425:in `block in log' /users/ssapra/.rvm/gems/ruby-2.0.0-p247/gems/activesupport-4.0.0/lib/active_support/notifications/instrumenter.rb:20:in `instrument' /users/ssapra/.rvm/gems/ruby-2.0.0-p247/gems/activerecord-4.0.0/lib/active_record/connection_adapters/abstract_adapter.rb:420:in `log' /users/ssapra/.rvm/gems/ruby-2.0.0-p247/gems/activerecord-4.0.0/lib/active_record/connection_adapters/postgresql/database_statements.rb:127:in `execute' /users/ssapra/.rvm/gems/ruby-2.0.0-p247/gems/textacular-3.1.0/lib/textacular/postgres_module_installer.rb:54:in `install_postgres_91_module' /users/ssapra/.rvm/gems/ruby-2.0.0-p247/gems/textacular-3.1.0/lib/textacular/postgres_module_installer.rb:7:in `install_module' /users/ssapra/.rvm/gems/ruby-2.0.0-p247/gems/textacular-3.1.0/lib/textacular/tasks.rb:14:in `block (2 levels) in <top (required)>' /users/ssapra/.rvm/gems/ruby-2.0.0-p247/bin/ruby_noexec_wrapper:14:in `eval' /users/ssapra/.rvm/gems/ruby-2.0.0-p247/bin/ruby_noexec_wrapper:14:in `<main>' tasks: top => textacular:install_trigram

based on this, tried sudo rake textacular:install_trigram , got this:

cannot load such file -- bundler/setup /users/ssapra/sameet/programming/webdev/rails/myapp/config/boot.rb:4:in `<top (required)>' /users/ssapra/sameet/programming/webdev/rails/myapp/config/application.rb:1:in `<top (required)>' /users/ssapra/sameet/programming/webdev/rails/myapp/rakefile:4:in `<top (required)>' /users/ssapra/.rvm/gems/ruby-2.0.0-p247/bin/ruby_noexec_wrapper:14:in `eval' /users/ssapra/.rvm/gems/ruby-2.0.0-p247/bin/ruby_noexec_wrapper:14:in `<main>' (see full trace running task --trace)

lastly, after reading for postgres 9.1 , above, tried running psql , create extension pg_trgm;. no errors (although anytime now, tell me exists). \quit , replace line of code work:

@search = content.advanced_search(params[:search].split(" ").join("|")).basic_search(params[:search])

with:

@search = content.fuzzy_search(title: params[:search]).fuzzy_search(text: params[:search])

or even:

 @search = content.fuzzy_search(params[:search])

and this:

pg::undefinedfunction: error:  operator not exist: character varying % unknown line 1: ...nt(*) "contents"  (("contents"."title" % 'inv')) ...                                                              ^ hint:  no operator matches given name , argument type(s). might need add explicit type casts. : select count(*) "contents"  (("contents"."title" % 'inv')) , (("contents"."text" % 'inv'))

it gets stuck on first line:

-if @contents.empty?        %p="no results found for: #{@query}" -elsif !@query.empty?        %p="your search results for: #{@query}"

contents controller

in contents_controller.rb: have these 3 additions:

require 'textacular' require 'textacular/tasks' activerecord::base.extend(textacular)

i running postgres 9.2.4. ideas?


Comments

Post a Comment

Popular posts from this blog

java - JavaFX 2 slider labelFormatter not being used -

-
i have following code not label slider "foo50", etc... 1 expect setlabelformatter call, instead seems have no effect (the slider labelled 50, 100, etc , println's dont run). there missing? not implemented in default 2.2 skin? using oracle java 7 package javafxbugtest; import javafx.application.application; import javafx.scene.*; import javafx.scene.control.*; import javafx.stage.*; import javafx.util.stringconverter; public class javafxbugtest extends application { @override public void start(final stage primarystage) { slider cp = new slider(); cp.setlabelformatter(new stringconverter<double>() { @override public string tostring(double t) { system.out.println("nope?"); return "foo" + t.tostring(); } @override public double fromstring(string string) { system.out.println("he
Read more

Detect support for Shoutcast ICY MP3 without navigator.userAgent in Firefox? -

-
the current version of mozilla firefox 23.0.1, version not support play mp3 shoutcast streams tcp port different 80 (most common 8000 shoutcast 1.9.8). i use flash when mp3 support not available in html5 audio, way detect is: try{ var = document.createelement('audio'); r = !!(a.canplaytype && !!a.canplaytype("audio/mpeg; codecs=mp3").replace(/^no$/,'')) }catch(e){ r = false; } the support mp3 shoutcast streams in firefox added in version 24 . a.canplaytype("audio/mpeg; codecs=mp3") = in chrome , firefox, chrome support, firefox not support, due current code detect not work firefox. the current version of jquery support ie 6 1.10.2, version not has .browser i think "stylized" way testing features , not querying browsers / versions, notwithstanding here see hard not violate "principle". what "stylized" way of detect mp3 icy support without navigator.useragent in firefox? ther
Read more

web - SVG not rendering properly in Firefox -

-
i have problem svg renderring in firefox. whilst works in safari, chrome or in ie, doesn't work in firefox. inspecting element seems layers there, background visible if it's z-index higher z-index of others. rendered in firefox: svg logo in firefox link original source file: svg file thanks help. ps: used sketch 3 export svg. if helps somehow. you're experiencing bug 995813 . i fixed bug time ago change still making way through release process example display correctly firefox 31 onwards released on 22 july 2014. in meantime if move fill="white" <mask> element child <use> element work around firefox bug.
Read more