Hi Pat, after your hint i double-checked my configuration and........turns out that the error came from different settings between the development and the production environment....
I consider this issue solved, thanks for your help. On Dec 14, 7:36 am, Pat Allan <[email protected]> wrote: > Hmm, what's the sql_query that's generated for track_core? The error > from Sphinx might be misleading with the reference to field list. > > -- > Pat > > On 13/12/2008, at 11:24 PM, j0llyr0g3r wrote: > > > > > Hey guys, > > > i get the following error message when running "rake > > thinking_sphinx:index" > > > CODE: > > indexing index 'track_core'... > > ERROR: index 'track_core': sql_range_query: Unknown column > > 'tracks.beat' in 'field list' (DSN=mysql://yourtunes:*...@localhost: > > 3306/yourtunes_development). > > > My migration (only the relevant parts) looks like this: > > > CODE: > > class CreateTracks < ActiveRecord::Migration > > def self.up > > create_table :tracks do |t| > > t.string :artist > > t.string :title > > ........... > > t.integer :track_length > > ........... > > t.boolean :loop, :default => false > > t.boolean :beat, :default => false > > t.boolean :vocals, :default => false > > end > > end > > > And here is the "define index" part from the model: > > > CODE: > > define_index do > > # enable keyword search 'tags', 'artist','title', > > 'short_description', 'full_description' > > indexes tags, :sortable => true > > indexes short_description, :sortable => true > > indexes full_description, :sortable => true > > indexes artist, :sortable => true > > indexes title, :sortable => true > > attribute beat > > attribute vocals > > # we _must_ use a symbol here, because loop is also a ruby kernel > > method > > attribute :loop > > has track_length > > end > > > Now, what i don't get is: > > > Why does sphinx / thinking sphinx want to index an attribute? > > > How can i solve this problem? --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
