I was a bit wary of the tutorial using variables rather then symbols, but I just went with it. I did go back and double check the single index on my users table and it turns out it is indexing and I can search.
As for the table that is not indexing, I removed everything from define_index except a single index, using a symbol for the field. I tried stopping sphinx, deleting db/sphinx, indexing and starting, again with no luck. Here is the output and a pastie of the schema. I cannot share the model, but is there something I should be looking for? I'll take gander to see if my model is redefining any sphinx methods. Table: http://pastie.org/private/v8yfsooycac2jxxx4lz7cg Updated Sphinx conf: http://pastie.org/483000 Thanks jacobbas...@dude:~/src/smart$ rake ts:stop (in /home/jacobbasham/src/smart) Sphinx 0.9.8.1-release (r1533) Copyright (c) 2001-2008, Andrew Aksyonoff using config file '/home/jacobbasham/src/smart/config/ development.sphinx.conf'... stop: succesfully sent SIGTERM to pid 32212 Stopped search daemon (pid 32212). jacobbas...@dude:~/src/smart$ rm -rf db/sphinx/ jacobbas...@dude:~/src/smart$ rake ts:index (in /home/jacobbasham/src/smart) Generating Configuration to /home/jacobbasham/src/smart/config/ development.sphinx.conf indexer --config /home/jacobbasham/src/smart/config/ development.sphinx.conf --all Sphinx 0.9.8.1-release (r1533) Copyright (c) 2001-2008, Andrew Aksyonoff using config file '/home/jacobbasham/src/smart/config/ development.sphinx.conf'... indexing index 'property_core'... collected 700 docs, 0.0 MB collected 0 attr values sorted 0.0 Mvalues, 100.0% done sorted 0.0 Mhits, 100.0% done total 700 docs, 5600 bytes total 0.031 sec, 182898.94 bytes/sec, 22862.37 docs/sec distributed index 'property' can not be directly indexed; skipping. indexing index 'user_core'... collected 45204 docs, 0.0 MB collected 0 attr values sorted 0.0 Mvalues, 100.0% done sorted 0.0 Mhits, 100.0% done total 45204 docs, 423 bytes total 0.152 sec, 2782.16 bytes/sec, 297316.49 docs/sec distributed index 'user' can not be directly indexed; skipping. jacobbas...@dude:~/src/smart$ rake ts:start (in /home/jacobbasham/src/smart) searchd --pidfile --config /home/jacobbasham/src/smart/config/ development.sphinx.conf Sphinx 0.9.8.1-release (r1533) Copyright (c) 2001-2008, Andrew Aksyonoff using config file '/home/jacobbasham/src/smart/config/ development.sphinx.conf'... creating server socket on 127.0.0.1:3312 Started successfully (pid 705). jacobbas...@dude:~/src/smart$ script/console Loading development environment (Rails 2.1.0) >> User.search("[email protected]").first.email => "[email protected]" >> Property.first(:conditions => "listing_number is not null").listing_number => "06430044" >> Property.search("06430044") => [] On May 19, 10:44 am, aitrus <[email protected]> wrote: > My first inclination would be to try referencing the column names as > symbols. IE, > > indexes :listing_number > > rather than, > > indexes listing_number > > If that still doesn't do the trick, I'd remove the "bitmask" portion > and do a rake ts:stop/index/start, and post the output plus your table > structure and the model and I'll peek at it some more. > > Scott > > On May 19, 7:22 am, Jacob <[email protected]> wrote: > > > > > Scott, > > > My original define_index has grown to have some fancy other options I > > had to add in (so I can easily index a bitmask) so it will look a bit > > funny. Although I have tried ripping everything out but a single > > indexed field, as well as indexing a single field on a different > > model. > > > fancy index:http://pastie.org/482782 > > generated config:http://pastie.org/482784 > > > The second 'test' index is a basic > > > define_index do > > indexes email > > end > > > Jake > > > On May 19, 12:48 am, aitrus <[email protected]> wrote: > > > > Can you pastie your define_index statements, and your table schema? > > > Can ;you also pastie your sphinx.conf that's generated? > > > > Be sure to check the name of your columns. Some may conflict with > > > reserved words in Ruby / Sphinx / whatever. > > > > Also, test your define_index first, with one or two columns and no > > > other fancy options. > > > > Scott > > > > On May 18, 10:21 am, Jacob <[email protected]> wrote: > > > > > This is probably more a question for the Sphinx forum, but I'll ask > > > > here first. I have defined indexes for two of my models and was able > > > > to index a couple weeks back. Now when I try and index it looks like > > > > Sphinx is finding the documents, but isn't indexing anything. The > > > > physical size of the collected documents also looks to be very off. > > > > I've tried Googling for days and haven't been able to find any leads. > > > > Does this mean the indexing query is not returning any rows? > > > > > Thanks > > > > Jake > > > > > indexing index 'property_core'... > > > > collected 700 docs, 0.2 MB > > > > collected 0 attr values > > > > sorted 0.0 Mvalues, 100.0% done > > > > sorted 0.0 Mhits, 100.0% done > > > > total 700 docs, 212855 bytes > > > > total 0.144 sec, 1482617.91 bytes/sec, 4875.77 docs/sec > > > > distributed index 'property' can not be directly indexed; skipping. > > > > indexing index 'user_core'... > > > > collected 45204 docs, 0.0 MB > > > > collected 0 attr values > > > > sorted 0.0 Mvalues, 100.0% done > > > > sorted 0.0 Mhits, 100.0% done > > > > total 45204 docs, 423 bytes > > > > total 0.151 sec, 2795.51 bytes/sec, 298743.00 docs/sec > > > > distributed index 'user' can not be directly indexed; skipping. --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
