I actually did this with a brand new, clean rails project and got
similar results:
class Article < ActiveRecord::Base
define_index do
indexes subject, :sortable => true
indexes content
indexes author.first_name, :as => :author_fname, :sortable => true
has author_id, created_at, updated_at
end
end
sql_query = SELECT `articles`.`id` * 1 + 0 AS `id` , CAST
(`articles`.`subject` AS CHAR) AS `subject`, CAST(`articles`.`content`
AS CHAR) AS `content`, CAST(`articles`.`first_name` AS CHAR) AS
`author_fname`, `articles`.`id` AS `sphinx_internal_id`, 3448190970 AS
`class_crc`, '3448190970' AS `subclass_crcs`, 0 AS `sphinx_deleted`,
IFNULL(`articles`.`subject`, '') AS `subject_sort`, IFNULL
(`articles`.`first_name`, '') AS `author_fname_sort`,
`articles`.`author_id` AS `author_id`, UNIX_TIMESTAMP
(`articles`.`created_at`) AS `created_at`, UNIX_TIMESTAMP
(`articles`.`updated_at`) AS `updated_at` FROM `articles` WHERE
`articles`.`id` >= $start AND `articles`.`id` <= $end GROUP BY
`articles`.`id` ORDER BY NULL
articles`.`first_name` is wrong. It should be author.first_name
I am using Thinking Sphinx v1.1.17
On May 26, 4:52 pm, phil <[email protected]> wrote:
> I am trying to switch to Thinking Sphinx from Ultrasphinx and having
> some very basic problems.
>
> I have a class:
>
> class Film < ActiveRecord::Base
> define_index do
> indexes :title, :as => :title_en, :sortable => true
> indexes title_es(:title), :as => :spanish_title
> indexes synopses.synopsis, :as => :synopsis
>
> has created_at, updated_at
> end
>
> has_many :synopses
> has_one :title_es, :class_name => "TranslatedTitle", :conditions =>
> "language = 'es'"
> end
>
> When I run rake thinking_sphinx:configure I get a conf file that seems
> just plain wrong!
>
> Here is the sql query:
>
> sql_query = SELECT `films`.`id` * 1 + 0 AS `id` , CAST
> (`films`.`title` AS CHAR) AS `title_en`, CAST(`films`.`title` AS CHAR)
> AS `spanish_title`, CAST(`films`.`synopsis` AS CHAR) AS `synopsis`,
> `films`.`id` AS `sphinx_internal_id`, 578162972 AS `class_crc`,
> '578162972' AS `subclass_crcs`, 0 AS `sphinx_deleted`, IFNULL
> (`films`.`title`, '') AS `title_en_sort`, UNIX_TIMESTAMP
> (`films`.`created_at`) AS `created_at`, UNIX_TIMESTAMP
> (`films`.`updated_at`) AS `updated_at` FROM `films` WHERE
> `films`.`id` >= $start AND `films`.`id` <= $end GROUP BY `films`.`id`
> ORDER BY NULL
>
> it is not looking at any associated classes, but thinking that the
> fields are on Film itself!
>
> This conf file, obviously, doesn't run against sphinx as there is no
> synopsis field and it gives me duplicate titles.
>
> I am sure I am doing something very basic and stupid, but right now I
> can't see what!
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
