Hi Pat,
After some more exploration, the previous message (of 2:44pm) seems to
pretty
much cover the situation. The full index definition is:
----------------------------------------------------
define_index do
#fields
#syntax: indexes column_name
indexes full_text
indexes notes
indexes author, :sortable => true
indexes from, :sortable => true
indexes to, :sortable => true
indexes doc_file_name
#attributes
#syntax: has column_name
has legal_case_id
has code
has pub #1
has privileged #2
has importance
has last_access
has date_written
has created_at
has updated_at
has doc_type #3
has doc_file_type #4
has physical_folder #5
end
--------------------------------------------
Searching an index made with this configuration causes the error.
With an index made with either lines #1, or #2, or (#3, #4 and #5)
commented out, the search works fine. #1 & #2 are booleans, #3 and #4
are strings, and #5 is a string with :limit => 12. (I said it was 30
before, but I pulled it down to 12 to compare with another column).
Without one of those 3 options
satisfied, I haven't found any other way to make it work. Even the
following causes the error:
----------------------------------------------
define_index do
#fields
#syntax: indexes column_name
#indexes full_text
#indexes notes
#indexes author, :sortable => true
#indexes from, :sortable => true
#indexes to, :sortable => true
indexes doc_file_name
#attributes
#syntax: has column_name
#has legal_case_id
#has code
has pub
has privileged
#has importance
#has last_access
#has date_written
#has created_at
#has updated_at
#has doc_type
#has doc_file_type
has physical_folder
end
----------------------------------
And having any one of the last 3 attributes un-commented also causes
the error.
Moreover, exchanging "code" for "physical_folder" in the above, i.e.
changing
--------------------------------
#has code --> has code
has physical_folder --> #has physical_folder
-------------------------------------
removes the error, even though both of these are strings with :limit
=> 12. Neither of these columns have any actual information in the
database, either.
- Farmer
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
