I've got two tables in the same database that are identical in structure - 
columns, indexes, permissions (one is an archive of the other).  The model 
files are not identical but the associations and index declarations are.  
The archive model contains a subset of the functionality of the original, 
but I have already gone so far as to reduce the model file for the archive 
to just the associations and index declarations.  When I rebuild the 
indexes after deleting all files in the index directory both models are  
processed without complaint.  The index files are created with identical 
permissions.  But when I do a simple search (for the word 'worried') on 
each the original file returns many results, the archive file returns no 
results.  When I use the error method to check for errors on the result set 
it returns nil.  When I look in the query log it shows that the query was 
successfully executed and returned 0 results.  But when I do a sql query on 
the indexed field in the archive file it returns over 3000 results (select 
count(*) from contact_archive where message like '% worried %').

My environment is Ruby 1.8.7, Rails 2.3.15 and Thinking Sphinx 1.4.10.  Any 
help would be greatly appreciated.

-- 
You received this message because you are subscribed to the Google Groups 
"Thinking Sphinx" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/thinking-sphinx.
For more options, visit https://groups.google.com/groups/opt_out.

Reply via email to