Hi Pat, solved!! It was the old version of TS causing all the trouble... Upgraded to the newest one (which apparently didn't work with my Win7) and it all works as it should.
Thank you very much for your detailed help and the wonderful plugin! Best, Tom 2009/9/3 T Nielson <[email protected]> > There is no version in the thinking_sphinx.rb and the rake tast didn't > work, either (I will update asap and try it again). > > As for the console-output, take a look at this: > > >> Container.create(:name => "consoletest", :type_id => 3) > => #<Container id: 17745, name: "consoletest", type_id: 3, delta: true> > > Sphinx 0.9.8-release (r1533) > Copyright (c) 2001-2008, Andrew Aksynoff > > using config file > 'F:/Work/Aptana/test_project/config/development.sphinx.conf'...' > indexing index 'container_delta'... > collected 1 docs, 0.0 MB > collected 0 attr values > sorted 0.0 Mvalues, 100.0% done > sorted 0.0 Mhits, 100.0% done > total 1 docs, 12 bytes > total 0.265 sec, 45.31 bytes/sec, 3.78 docs/sec > > >> Container.search 'consoletest' > => [] > >> Container.search '*console*' > => [] > > But the values get passed to the searchd: > > accepting connections > [Mon Aug 3 13:13:48.062 2009] 0.000 sec [all/2/rel 0 (0,20)] [*] > consoletest > [Mon Aug 3 13:13:55.014 2009] 0.000 sec [all/2/rel 0 (0,20)] [*] *console* > > Best, > Tom > > 2009/9/3 Pat Allan <[email protected]> > >> >> rake ts:index should output that line if Sphinx is running. If you're >> indexing while Sphinx is stopped, then the line will not appear. >> >> As for versions, if you're using a relatively recent version of TS, >> you can run rake thinking_sphinx:version. Otherwise, have a look in >> the thinking_sphinx.rb file in vendor/plugins/thinking_sphinx/lib/. >> (Although I recommend updating if you're using that old a version). >> >> With regards to the delta issues - no idea why it's different for >> different versions of Windows - it's been quite some time since I've >> used Ruby on a Windows machine. Can you show me the code you're >> running on console to create a new object and then test that it >> appears in the search? You will want to wait a couple of seconds >> between creation and searching for Sphinx to catch up. >> >> -- >> Pat >> >> On 03/09/2009, at 12:21 PM, T Nielson wrote: >> >> > Hmm, >> > >> > does the current version of sphinx/TS produce output like >> > >> > "rotating indices: succesfully sent SIGHUP to searchd (pid=5716)" ? >> > >> > Found this on http://railsforum.com/viewtopic.php?id=24959 and >> > compared the authors output with mine and this line is missing. >> > >> > Best, >> > Tom >> > >> > 2009/9/3 T Nielson <[email protected]> >> > P.S. >> > on XP I'm using an older version of TS but I don't know where to >> > find the versionnumber ;-) >> > >> > 2009/9/3 T Nielson <[email protected]> >> > >> > Hi Pat, >> > >> > maybe it was an issue of Windows 7. However, i tried my approach on >> > XP and it worked, except for delta-indexing. The Model contains >> > set_property :delta => true and the database was migrated >> > successfully. If I create a new object, I can see in the console, >> > that TS was invoked like: >> > >> > using config file... >> > indexing index 'container_delta' >> > collected 1 docs, 0.0 MB >> > ... >> > total 1 docs, 60 bytes >> > >> > But a searchquery on this new object doesn't return any result. >> > That's kind of weird 'cause delta-indexing worked for me (2 months >> > ago I think). Any idea? >> > >> > Regards, >> > Tom >> > >> > 2009/9/3 Pat Allan <[email protected]> >> > >> > >> > What happens if you change >> > Container.search params[:search] >> > to >> > ThinkingSphinx.search params[:search], :class => Container >> > >> > Although ideally, the first version *should* work, but I've not seen >> > this issue before. >> > >> > -- >> > Pat >> > >> > On 03/09/2009, at 9:15 AM, T Nielson wrote: >> > >> > > Hi Pat, >> > > >> > > I'm using the latest stable version of sphinx (0.9.8.1), Rails >> > > 2.2.2, Ruby 1.8.6 and the latest version of TS I've found on >> http://github.com/freelancing-god/thinking-sphinx/tree/master >> > > (clicked the Download Button). The searchcode is nearly the same >> > > I've tried in the console: >> > > >> > > All this tried in development and on a local connection (localhost): >> > > >> > > Console: >> > > Container.search 'myvalue' --> returns an Array containing elements >> > > >> > > Controller: >> > > Container.search params[:search] --> returns 'undefined method >> > > `search' for #<Class:0x10bc9944>' , I've already checked the >> > > params[:search], so that's not the issue >> > > >> > > I could imagine that this is a PATH issue, but I'm not sure. My >> > > sphinx.yml looks as below (development same as production and I >> > > didn't set the bin_path in my system_environment path-variable, only >> > > in the yml): >> > > >> > > production: >> > > enable_star: 1 >> > > min_infix_len: 3 >> > > max_matches: 1000 >> > > bin_path: 'F:/Work/Aptana/sphinx/bin' >> > > log: 'F:/Work/Aptana/sphinx/bin/log/searchd.log' >> > > query_log: 'F:/Work/Aptana/sphinx/bin/log/query.log' >> > > >> > > Thank you very much for your help! >> > > >> > > Tom >> > > >> > > 2009/9/2 Pat Allan <[email protected]> >> > > >> > > Hi Tom >> > > >> > > Good to know we've got one issue out of the way. >> > > >> > > As for the next... what versions of TS, Rails and Sphinx are you >> > > using? And what is the search code in the controller that isn't >> > > working? Is there an error? Or just no results being returned? >> > > >> > > -- >> > > Pat >> > > >> > > On 02/09/2009, at 9:43 PM, T Nielson wrote: >> > > >> > > > Hi Pat, >> > > > >> > > > I tried your proposal and it worked ;-) !! Thank you very much - >> > > > but now I experience another problem: Model.search via ruby/script >> > > > console works... but Model.search from a controller doesn't. >> > Maybe a >> > > > problem of a wrong thinking_sphinx version? Or do you have any >> > clues >> > > > how this issue is caused? >> > > > >> > > > Best, >> > > > Tom >> > > > >> > > > 2009/9/2 Pat Allan <[email protected]> >> > > > >> > > > Hi Tom >> > > > >> > > > attris.value in your Container's define_index block should work. I >> > > > don't think value is a reserved word, but just in case, try the >> > > > following: >> > > > indexes attris(:value), :as => :container_attribute >> > > > >> > > > -- >> > > > Pat >> > > > >> > > > On 02/09/2009, at 7:09 PM, Tom wrote: >> > > > >> > > > > >> > > > > Hi Pat, >> > > > > >> > > > > thank you for your response. I tried two different ways >> > because my >> > > > > models (Container and Attri) are in a 1:N association. I wanted >> > > all >> > > > > container.attributes.values to be indexed but that didn't >> > work, so >> > > > > I've tried the solution you can see in the Attri-Model below >> > (and >> > > > that >> > > > > didn't work either..). All my other Models get indexed as they >> > are >> > > > > supposed to be, so I thought about reserved keywords, in this >> > > > example >> > > > > "value". Here my models: >> > > > > >> > > > > >> > > > > class Attri < ActiveRecord::Base >> > > > > belongs_to :container >> > > > > >> > > > > define_index do >> > > > > indexes :value, :as => :attri_value >> > > > > set_property :delta => true >> > > > > end >> > > > > >> > > > > end >> > > > > >> > > > > >> > > > > class Container < ActiveRecord::Base >> > > > > has_many :attris, :dependent => :destroy >> > > > > >> > > > > define_index do >> > > > > indexes :name >> > > > > indexes attris.value, :as => :container_attribute #does >> > this >> > > > > work? or should it be indexes container.attris.values, :as >> > > > > => :something ? >> > > > > set_property :delta => true >> > > > > end >> > > > > >> > > > > end >> > > > > >> > > > > >> > > > > Best regards, >> > > > > Tom >> > > > > >> > > > > >> > > > > On 2 Sep., 18:02, Pat Allan <[email protected]> wrote: >> > > > >> Hi Tom >> > > > >> >> > > > >> What's your define_index block looking like for this model? Are >> > > you >> > > > >> seeing any error messages (and if not, what's indicating that >> > > it's >> > > > >> not >> > > > >> working?) >> > > > >> >> > > > >> -- >> > > > >> Pat >> > > > >> >> > > > >> On 01/09/2009, at 1:40 PM, Tom wrote: >> > > > >> >> > > > >> >> > > > >> >> > > > >>> hi there, >> > > > >> >> > > > >>> i'm trying to five models. the whole thing works.. except for >> > > one >> > > > >>> model. it's name is "Attri" and has three values: >> > > "container_id", >> > > > >>> "key_id" and .. the value i want to index: "value". is "value" >> > > > >>> maybe a >> > > > >>> reserved keyword and is not recognized by ts? >> > > > >> >> > > > >>> thanks in advance, >> > > > >>> tom >> > > > > > >> > > > >> > > > >> > > > >> > > > >> > > > >> > > > > >> > > >> > > >> > > >> > > >> > > >> > > > >> > >> > >> > >> > >> > >> > >> > >> > > >> >> >> >> >> > --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
