Does your development.sphinx.conf (or production.sphinx.conf, depending on the 
environment we're talking about) contain an sql_attr_(something) = ende 
definition in the post_core_0 block?

On Feb 24, 2011, at 10:04 AM, Benjamin Bock wrote:

> Hi Clemens,
> 
> define_index do
>    indexes aoderg, :as => :ad_type
>    indexes rubrik, :as => :category
>    indexes stadt, :as => :location
>    indexes status, email, ip
>    indexes [ueberschrift, text, kontakt], :as => :full_text
>    where 'ende > 1293750000'
>    has beginn, ende
>  end
> 
> The search call which causes the exception is in fact an update call,
> as mentioned in the last mail:
> 
> Post.update(post_id.to_i, :status => status)
> 
> The search call which fails with 1.10-beta but is fine with 0.9.9 is
> 
> Post.search full_text, :page => page, :per_page =>
> per_page, :conditions => {:ende => now.to_i..now.to_i +
> 4.weeks.to_i}  :order => "beginn DESC", :max_matches => 1000000
> 
> The latter error does not occur if full_text is nil.
> 
> - Benjamin
> 
> On 23 Feb., 23:45, Clemens Kofler <[email protected]> wrote:
>> Hi Benjamin,
>> 
>> help us help you by posting the define_index block and your precise search 
>> call. :-)
>> 
>> - Clemens
>> 
>> On Feb 23, 2011, at 8:53 PM, Benjamin Bock wrote:
>> 
>> 
>> 
>> 
>> 
>> 
>> 
>>> Hi Pat et al.
>> 
>>> as complained on Twitter [1] two days ago I'm having some problems
>>> with Thinking Sphinx and/or Sphinx which I haven't been able to solve
>>> yet. The problems stays with both the 2.0.2 gem and the latest from
>>> the rails 3 branch.
>>> I've tried Sphinx 1.10-beta and 0.9.9.
>> 
>>> The error received is "searchd error (status: 1): index post_core:
>>> attribute 'ende' not found".
>>> define_index is quite at the end of the model file and there are no
>>> associations defined.
>> 
>>> With Sphinx 1.10 I cannot even search anything (same or similar error
>>> as above), with 0.9.9 the error occurs only when calling
>>> "Post.update(post_id.to_i, :status => status)"
>> 
>>> Do you have any idea where I could look or what I could try to solve
>>> this?
>> 
>>> Thanks in advance!
>> 
>>> Benjamin
>> 
>>> [1]https://twitter.com/bnjmnbck/status/39486194404302848
>> 
>>> --
>>> 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.

Reply via email to