Problem solved. Post for reference :) After conversation with Pat it turned out that the problem is with my crc32 function in postgresql. Ultrasphinx added this function and I didn't remove it so it generated wrong values.
Here is migration to remove those functions added by ultrasphinx: http://pastie.org/295620 Another thing - thinking sphinx needs postgresql >=8.3. It was the main cause. TS creates crc32 with: "CREATE OR REPLACE FUNCTION crc32(word text)". If I had got postgresql 8.3 it would replace function from ultrasphinx. My version was 8.2.7. @Pat: thanks for help and great plugin :) Cheers On Oct 18, 4:23 pm, Pat Allan <[EMAIL PROTECTED]> wrote: > Hmm, this should work with the latest in GitHub - indeed, anything > from the last few days... > > Can you copy and send (offlist if you'd prefer) your > development.sphinx.conf file? > > Also, what's the results from the following SQL query: > SELECT DISTINCT pages.class_name, crc32(pages.class_name) from pages; > > Cheers > > -- > Pat > > On 18/10/2008, at 9:18 PM, Piotr Sarnacki wrote: > > > > > I'm running postgres, thinking sphinx from current master at github. > > > On Oct 18, 3:58 pm, Pat Allan <[EMAIL PROTECTED]> wrote: > >> Okay, different bug then. Are you running PostgreSQL or MySQL? How > >> recent is your version of Thinking Sphinx? > > >> On 18/10/2008, at 8:36 PM, Piotr Sarnacki wrote: > > >>> The output is array with subclasses: NewsPage, ArticlesPage, > >>> PastebinPage. > > >>> On Oct 18, 3:26 pm, Pat Allan <[EMAIL PROTECTED]> wrote: > >>>> Hi Piotr > > >>>> I saw this problem the other day with someone else, off-list. Not > >>>> entirely sure it's a bug with TS, but let's see if it's the same > >>>> cause. > > >>>> In script/console, when you type Page.send(:subclasses), what do > >>>> you > >>>> get back? > > >>>> -- > >>>> Pat > > >>>> On 18/10/2008, at 8:21 PM, Piotr Sarnacki wrote: > > >>>>> Hi, > > >>>>> I have a Page class and some pages types with single table > >>>>> inheritance > >>>>> usage. > > >>>>> I've installed thinking sphinx and latest sphinx. > > >>>>> In my Page model I've left only two attributes to index: > >>>>> define_index do > >>>>> indexes title > >>>>> indexes description > >>>>> end > > >>>>> inheritance column is set to :class_name > > >>>>> After running some queries I've realised that only pages with > >>>>> class_name == nil are found. I've tried to run > >>>>> ArticlePage.search '' > >>>>> to get pages with class_name == "ArticlePage" but it returns 0 > >>>>> results. > > >>>>> How to force TS to find all types of records? > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Thinking Sphinx" 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/thinking-sphinx?hl=en -~----------~----~----~----~------~----~------~--~---
