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.
