Hi Greg
:class_name on your association definitions will work fine in TS, as
should the rest of the code you've described.
What's the sql_range_query SQL statement from your Sphinx
configuration file for that model? And your full define_index block?
--
Pat
On 04/09/2009, at 6:17 PM, Greg wrote:
>
> The error:
>
> ERROR: index 'ticket_core': sql_range_query: You have an error in your
> SQL syntax; check the manual that corresponds to your MySQL server
> version for the right syntax to use near 'AS CHAR) AS `owner_name`,
> `tickets`.`id` AS `sphinx_internal_id`, 2416748693 AS ' at line 1
> (DSN=mysql://rails:*...@localhost:3306/ticket-dev).
>
> In my Ticket Active record class I have this:
>
> belongs_to :owner, options = {:class_name => 'User'}
> ...
> define_index do
> ...
> indexes owner(:full_name), :as => :owner_name
> end
>
> Is my use of :class_name of User not supported by Thinking in Sphinx?
>
> >
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
