Hi Jake Just been looking over your original config - there's a lot there!
I'd try add some fields and attributes back in, bit by bit. See if there's some point where it doesn't work anymore. I know it's a bit fiddly, but I had to do this a week or so ago on someone else's data. Get two terminals going, one in script/console for testing, the other with all the rake tasks lined up: rake ts:stop ts:in ts:start That way, you make the change to the index, save the file, run the rake task line, then run the test query in script/console. The symbols or method calls should both work fine, provided it's not an existing method on Object (and there's nothing in the config that stood out to me). Cheers -- Pat On 19/05/2009, at 12:02 PM, Jacob wrote: > > Well I just ripped everything out of my model and table leaving me > with nothing but a single column. > > class Property < ActiveRecord::Base > define_index do > indexes :listing_number > end > end > > And suddenly the indexes start working again. Are their specific > column names that I should be avoiding, or would the type/default/ > nullable combo be the culprit? > > Best > Jake > > On May 19, 12:34 pm, Jacob <[email protected]> wrote: >> 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 -~----------~----~----~----~------~----~------~--~---
