Thanks for your reply. Shortly after this post, I realized that the delta field was recently added, re-running the indexer fixed it.
Thanks again. On Jun 8, 8:28 pm, Pat Allan <[email protected]> wrote: > For some reason, Sphinx doesn't think the delta index for the model > exists... what's the contents of your db/sphinx/development folder? > > -- > Pat > > On 07/06/2009, at 11:45 PM, gmoniey wrote: > > > > > Hi, > > > I have monkey patched ActiveRecord's destroy to perform soft deletes > > (i.e. set the deleted flag to 1), and I am getting this weird error: > > unknown index 'my_model_delta' in update request. > > > Does anyone have any idea whats going on? This is what my define_index > > looks like: > > > define_index do > > indexes :name, :sortable => true > > > has :deleted > > set_property :delta => true > > end > > > And here is part of the exception: > > > Processing MyController#destroy to xml (for 127.0.0.1 at 2009-06-07 > > 20:38:41) [DELETE] > > Parameters: {"id"=>"5"} > > MyModel Load (0.3ms) SELECT * FROM `my_models` WHERE > > (`my_models`.`id` = 5 AND (`my_models`.`deleted` = 0)) > > MyModel Destroy (0.7ms) UPDATE `my_models` SET deleted = 1, > > updated_at = utc_timestamp() WHERE `id` = 5 > > > Riddle::ResponseError (searchd error (status: 1): unknown index > > 'my_model_delta' in update request): --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
