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
-~----------~----~----~----~------~----~------~--~---
