The syntax you're using there is going to cause some problems (although I've no idea if it's related to the id searching).
Try: indexes [logins.login, logins.email], :as => :logins To merge multiple columns together, you need to have them in an array. Your statement was creating two different fields with the same name (hence a conflict). Cheers -- Pat On 03/06/2009, at 10:50 AM, joren wrote: > > The problem only occurs when I also indexes an association > > "indexes logins.login, logins.email, :as => :logins" > > it takes a lot longer to index and the searching id's is broken > afterwords. > If I don't index this has_may association, everything works just fine. > > any suggestions? > > On Jun 3, 3:34 pm, joren <[email protected]> wrote: >> is there a max size for the index of a model? or a max number of >> indexable fields. >> If I run the index only on the id, I don't have any problems. >> >> If I run the index on 25 fields of the model I can't search on the >> whole id... only on the first 3 number of it with a * at the end >> >> On May 25, 7:16 pm, Pat Allan <[email protected]> wrote: >> >>> If you look at development.log (or whichever is appropriate for your >>> environment), it will show you the query Thinking Sphinx sends to >>> Sphinx. It doesn't output filters though. >> >>> -- >>> Pat >> >>> On 25/05/2009, at 6:59 AM, joren wrote: >> >>>> is there a way to see the real sql queries generated from sphinx? >>>> so I >>>> can try to solve my problem via there? >> >>>> On May 25, 2:30 pm, joren <[email protected]> wrote: >>>>> Hi, >> >>>>> Is there any reason why I only can search for the first 3 >>>>> characters >>>>> of an id? >> >>>>> I have a record with id 123456, when I search for ‘123’ I get a >>>>> result, but when I search for ‘1234’ or the complete id, My >>>>> result is >>>>> empty, without any error output in any logs. >> >>>>> Is this a setting or an option I can adjust in my config? >>>>> thanks > > --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
