Hi Piotr As Greg's suggested, would be great if you can confirm the generated SQL is returning the data you want. Also, can you provide an example of a user login, as well as the output when you run 'rake thinking_sphinx:index'?
Cheers -- Pat On 10/06/2009, at 3:16 PM, Greg Weber wrote: > > I start by doing a show full processlist to get the query that was > ran, and run it manually. Or you could paste from the file and put in > a start and an end. If the SQL is correct, then thinking sphinx would > appear to be doing its job- you may want to ask over on the sphinx > forums. You can run the indexer program yourself, instead of through > thinking sphinx, and that will give you output as to how many > documents were found and the size of the index. > > On Jun 10, 9:17 am, Piotr Sarnacki <[email protected]> wrote: >> Hi, >> >> I've added indexes to one of my models and it fails to index one of >> the fields. >> >> I left only one association in index to check this out: >> define_index do >> indexes user.login, :as => :user_login >> end >> >> Generated query is here:http://pastie.org/507384 >> >> After indexing it no records are returned while performing searches >> (with existing logins). Is there any way to find out what actually is >> indexed? Or maybe any other way to debug it? > > --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
