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 software http://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 -~----------~----~----~----~------~----~------~--~---
