What happens when you run the following commands in console: Cimg.define_indexes Cimg.index_delta
The command we care about is the second one - it should print out the output from Sphinx's indexer, and then return a delta object (which will likely be quite big and complex). The indexer output is likely going to be more interesting/helpful for debugging this. -- Pat On 10/10/2011, at 2:38 AM, Zequez wrote: > Sorry, it also does not work neither in console or the browser. > > On Oct 7, 6:18 am, Pat Allan <[email protected]> wrote: >> Is this happening in production? Development? Both? Does it work in console >> but not through a browser? Or fails in both? >> >> -- >> Pat >> >> On 06/10/2011, at 10:56 AM, Zequez wrote: >> >> >> >> >> >> >> >>> Well, I've read a LOT about Delta Index not working in production >>> because of permissions errors, but my problem is not that (I think). >>> Here are the facts: >> >>> This was the migration: >> >>> class AddDeltaIndexToCimgs < ActiveRecord::Migration >>> def change >>> add_column :cimgs, :delta, :boolean, default: true, null: false >>> end >>> end >> >>> This is the define_index: >> >>> define_index do >>> indexes search_cache >>> has :approved >>> set_property delta: true >>> end >> >>> Then I run rake:stop, rake:reindex, and rake:start >> >>> Then I search for something already in the database with: >> >>> Cimg.search query, with: {approved: true} >> >>> And it works as expected... >> >>> But when I create new records, I can't find them. >>> I checked the database and the delta column for those records is set >>> to true (also the approved column, though anyway I tested without it) >>> In the development.log it says the following after creating a new >>> record: >> >>> (41.1ms) COMMIT >>> Sphinx Query (14.5ms) >>> Sphinx Found 0 results >> >>> Here is the generated configuration file:http://pastebin.com/z0fHr43k >>> I checked the db/sphinx folder and a lot of files with the name >>> cimg_delta are created. >> >>> Im using: >>> Sphinx version: 2.0.7 >>> Thinking Sphinx version: 2.0.5 >>> Rails version: 3.1.0.rc8 >>> Ruby version: 1.9.2p290 >> >>> I don't know what else to say, that's all what I know so far. >>> I don't know if the problem is that the records are not indexed or are >>> not being searched, but I don't know how to dump the delta index =/ >>> I tried to submit the index_delta manually calling it in a record, but >>> that didn't worked either. >> >>> -- >>> 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 >>> athttp://groups.google.com/group/thinking-sphinx?hl=en. > > -- > 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. > -- 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.
