Great to know it's working - I'm really not sure why it wasn't though, beyond the two settings defaulting to false in the test environment.
If you hit any other problems, get in touch :) -- Pat On 04/06/2011, at 8:44 PM, melissa wrote: > Hi Pat, > > OK, so I switched my environment and everything is well. Hooray! > I still have no idea what caused my problems on the test environment > though. > I'd be curious to hear about it if you do figure it out. > > In any case, thanks for all your help. > You saved the day! > > Melissa > > > On Jun 4, 9:29 pm, melissa wrote: >> Hi Pat, >> >> I'm constantly rebuilding... >> This is my define_index block: >> >> define_index do >> indexes :grade, :sortable => true >> indexes :EC, :sortable => true >> indexes self.school_class.title, :as >> => :school_classname, :sortable => true >> indexes self.subject.title, :as => :subjectname, :sortable => >> true >> indexes :semester, :sortable => true >> indexes :periode, :sortable => true >> indexes :created_at, :sortable => true >> indexes "DATE_FORMAT(assessments.created_at,'%Y%m%d%H%M >> %S')", :as => :created_at_condensed, :sortable => true >> indexes :type, :sortable => true >> indexes >> [self.student.firstname,self.student.prefix,self.student.lastname], :as >> => :student_fullname, :sortable => true >> indexes self.student.lastname, :as >> => :student_lastname, :sortable => true >> indexes "DATE_FORMAT(assessments.created_at,'%d-%m-%Y')", :as >> => :creation_date_european >> indexes >> [self.person.firstname,self.person.prefix,self.person.lastname], :as >> => :person_fullname, :sortable => true >> indexes self.person.lastname, :as >> => :person_lastname, :sortable => true >> has :id, :as => :assessment_id >> has "IF(STRCMP(assessments.type,'CollectiveAssessment'), >> 0,1)",:type => :integer, :as => :is_collective_assessment >> has "IF(DATE_FORMAT(assessments.assessed_at,'%m') > 9, >> CONCAT(DATE_FORMAT(assessments.assessed_at,'%Y'),DATE_FORMAT(assessments.assessed_at,'%Y') >> +1), >> CONCAT(DATE_FORMAT(assessments.assessed_at,'%Y')-1,DATE_FORMAT(assessments.assessed_at,'%Y'))) >> ",:type => :integer, :as => :school_year >> has :created_at, :as => :assessment_created_at >> has :grade, :as => :assessment_grade >> has :EC, :type => :integer, :as => :assessment_EC >> has :periode, :type => :integer, :as => :assessment_periode >> has :semester,:type => :integer, :as => :assessment_semester >> set_property :delta => :delayed >> end >> >> Thank you! >> >> Melissa >> >> On Jun 4, 8:53 pm, Pat Allan <[email protected]> wrote: >> >> >> >> >> >> >> >>> Hi Melissa >> >>> Can you share what your define_index block looks like? >> >>> Also, have you restarted *and* reindexed Sphinx on your test server since >>> making index structure changes? This can be done with the ts:rebuild task. >> >>> Cheers >> >>> -- >>> Pat >> >>> On 04/06/2011, at 7:07 PM, melissa wrote: >> >>>> To solve the sorting problem I used an attribute, which worked in >>>> development. >>>> But now I get in the test environment: index assessment_delta: sort-by >>>> attribute 'created_at_sort' not found >> >>>> Basically, what is happening I think, is that the attributes are not >>>> being recognised. I think that this could potentially explain both >>>> my :sphinx_select and my current sort-by attribute problem, since both >>>> depend apon an attribute. >> >>>> Is the only way to solve this to switch environment? >> >>>> Melissa >> >>>> On Jun 4, 1:33 pm, melissa wrote: >>>>> About what I thought was caching is actually a sorting problem. >>>>> All the results are there, just not in the right order. I'll post the >>>>> solution if I can find it. >> >>>> -- >>>> 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.
