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.




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

Reply via email to