It doesn't get any simpler. The index definitions are identical:
define_index do
indexes :first_name, :sortable => true
indexes :last_name, :sortable => true
indexes :message
has created_at
has dist90038
where "type in
('ContactShow','DoctorContact','ProcedureRequest','TellUs')"
end
By the way, I tried removing the has statements and the where statement and
reconfiguring and reindexing with the same results. Even if I try the
simplest search:
ContactInfo.search('worried')
ContactArchive.search('worried')
The first one works, the second one doesn't.
Seems crazy but there it is.
I'm wondering about versions. What gem version for Thinking Sphinx and
Riddle should I be using for Rails 2.3.15?
Regards,
Stan
On Wed, Oct 9, 2013 at 11:39 PM, Pat Allan <[email protected]> wrote:
> Can you show us the index definitions for both models, and the queries
> you're running?
>
> On 09/10/2013, at 4:28 AM, stasch <[email protected]> wrote:
>
> 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.
>
>
> --
> You received this message because you are subscribed to a topic in the
> Google Groups "Thinking Sphinx" group.
> To unsubscribe from this topic, visit
> https://groups.google.com/d/topic/thinking-sphinx/tVmRxNDkM3M/unsubscribe.
> To unsubscribe from this group and all its topics, 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.
>
--
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.
