The acts_as_tsearch description at Google Code (http://code.google.com/p/acts-as-tsearch/) reads
"This very simple plugin is in it's [sic] early development stages[;] however[,] we have it running on our production servers currently on http://activerain.com/search."; The phrase "early development stages" makes me think acts_as_tsearch might not have all the features we need, and also that, like so many plugins and gems, It Just Won't Work (TM). (Just as yesterday I discovered that Thinking Sphinx, which apparently meets many people's needs, doesn't meet ours, because it spits out an unhelpful error message when trying to index the Person model.) These issues may be surmountable, but they give me the aforementioned doubts. Michael On Wed, Aug 20, 2008 at 3:02 AM, Nick Leichty <[EMAIL PROTECTED]> wrote: > > tell me more about your doubts on tsearch. > > On 19 Aug., 21:02, "Michael Hartl" <[EMAIL PROTECTED]> wrote: >> Just a quick note: looking a little closer at acts_as_tsearch has >> given me some doubts about its suitability. So no promises on >> Postgres search. And any help on this front is of course much >> appreciated. >> >> Michael >> >> >> >> On Tue, Aug 19, 2008 at 10:28 AM, Michael Hartl <[EMAIL PROTECTED]> wrote: >> > Sorry we didn't note this in the README. (I've updated it to note the >> > problem.) That's a bug in Ultrasphinx, and in fact we have been >> > unable to get search working with PostgreSQL at this time. It seems >> > that, within literally two weeks after switching to >> > Sphinx/Ultrasphinx, the Cool Kids switched to Sphinx/Thinking Sphinx. >> > Unfortunately, I can't get Thinking Sphinx to work with Insoshi; it >> > totally chokes on the Person model for some reason. >> >> > In any case, we're working with Heroku on a Secret Project, which >> > among other things will involve getting acts_as_tsearch working. So >> > search is coming soon for Postgres. >> >> > Michael >> >> > On Tue, Aug 19, 2008 at 2:01 AM, Nick Leichty <[EMAIL PROTECTED]> wrote: >> >> >> I want to get Insoshi running along with postgresql. >> >> Set-up database.yml and run script/install works well. >> >> >> the problems begin on Sphinx after hitting > rake ultrasphinx:index >> >> >>> using config file >> >>> '/home/brcko/insoshi/config/ultrasphinx/development.conf'... >> >>> indexing index 'main'... >> >>> ERROR: index 'main': sql_range_query: ERROR: function >> >>> unix_timestamp(timestamp >> >>> without time zone) does not exist >> >>> LINE 1: ... AS description, 0 AS email_verified, '' AS name, >> >>> UNIX_TIMES... >> >>> ^ >> >>> HINT: No function matches the given name and argument types. You might >> >>> need to >> >>> add explicit type casts. >> >> >> so I changed the mysql-query UNIX_TIMESTAMP to ABSTIME so postgre can >> >> understand (and yes, i know this isn't the right approach). The >> >> previous rake task works for now, but ultrasphinx:start fails. >> >> >> I also tried it without sphinx, but this is what i got >> >> >>> NoMethodError in HomeController#index >> >>> undefined method `person_id=' for #<PageView:0x7ee734d8> >> >> >> I used for all this the latest git master of Insoshi. >> >> > -- >> > Michael Hartl >> > Insoshi social software >> >http://insoshi.com/ >> >> -- >> Michael Hartl >> Insoshi social softwarehttp://insoshi.com/ > > > -- Michael Hartl Insoshi social software http://insoshi.com/ --~--~---------~--~----~------------~-------~--~----~ Insoshi developer site: http://dogfood.insoshi.com/ Insoshi documentation: http://docs.insoshi.com/ You received this message because you are subscribed to the Google Groups "Insoshi" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/insoshi?hl=en -~----------~----~----~----~------~----~------~--~---
