This really is an odd problem - that it would work with some of the attributes but not others.
What happens when you use the test 'search' command line tool? ie: search -c config/development.sphinx.conf -- Pat On 17/12/2008, at 1:06 PM, farmer wrote: > > 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 -~----------~----~----~----~------~----~------~--~---
