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/ --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
