Sorry, I wasn't clear. Because you're using the same database columns for both fields and attributes, Sphinx may get confused - so you need to rename one or the other. Here's an example:
indexes title indexes description indexes keywords, :as => :tags has title, :as => :video_title has description, :as => :video_desc has keywords Also - what is the output of ts:rebuild? -- Pat On 25/04/2011, at 11:28 PM, Matias wrote: > I already run ts:rebuild. It doesn't work. > > The search query its simple Video.search 'music' > > I didn't understand the alias thing. What do you mean? > > On Apr 20, 10:25 pm, Pat Allan <[email protected]> wrote: >> I've not seen that one before. >> >> Try running rake ts:rebuild - and post the output here if that doesn't fix >> anything. It's not your database schema that's the problem, it's the Sphinx >> index schema. Sounds like it's expecting one thing, but getting something >> else back. >> >> What's the search query you're using that returns that error? >> >> Also, you should probably alias your title and description attributes (or >> fields) so you're not conflicting on names (ie: you've currently got both >> fields and attributes named title and description). >> >> Cheers >> >> -- >> Pat >> >> On 21/04/2011, at 5:36 AM,Matiaswrote: >> >> >> >> >> >> >> >>> ThinkingSphinx::SphinxError: index video_core: INTERNAL ERROR: >>> incoming-schema mismatch (in=ordinal title:32@160, my=ordinal title: >>> 32@0) >> >>> What this mean? >> >>> class Video < ActiveRecord::Base >> >>> define_index do >>> indexes title >>> indexes description >>> indexes keywords, :as => :tags >> >>> has title, description, keywords >>> end >>> ... >> >>> schema.rb >> >>> create_table "videos", :force => true do |t| >>> t.string "youtube_id" >>> t.string "title" >>> t.datetime "created_at" >>> t.datetime "updated_at" >>> t.string "description" >>> t.string "keywords" >>> t.integer "keywords_count" >>> t.integer "duration" >>> t.boolean "racy" >>> t.time "published_at" >>> t.string "categories" >>> t.string "author" >>> t.string "thumb_url" >>> t.string "thumb_big_url" >>> t.integer "rating_min", :default => 1 >>> t.integer "rating_max", :default => 5 >>> t.float "rating_avg" >>> t.integer "rating_count" >>> t.integer "view_count" >>> t.integer "favorite_count" >>> t.float "rating_score" >>> t.float "views_score" >>> t.integer "category_id" >>> end >> >>> I ran ts:index and ts:start >> >>> -- >>> 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.
