I've been fighting this issue for a couple days, trying various configs and
re-indexing each time, and still cannot find partial matches.
Any suggestions?
Thanks,
Frank
This returns 0 results(wrong):
Translation.search 'doct', :star => true
This returns 1 result(correct):
Translation.search 'doctor', :star => true
Machine:
Sphinx 2.1.0
Mac OSX 10.9
Environment:
Thinking-Sphinx 2.1.2
Rails 3.2.8
Ruby 1.9.3p392
development.sphinx.conf:
source translation_core_0
{
type = mysql
sql_host = localhost
sql_user = root
sql_pass =
sql_db = medbillmanager_development
sql_query_pre = SET NAMES utf8
sql_query_pre = SET TIME_ZONE = '+0:00'
sql_query = SELECT SQL_NO_CACHE `translations`.`id` * CAST(6 AS SIGNED) +
4 AS `id` , `translations`.`text` AS `text`, `phrases`.`source_table` AS
`source_table`, `translations`.`locale_id` AS `locale_id`,
`translations`.`id` AS `sphinx_internal_id`, 0 AS `sphinx_deleted`,
854969016 AS `class_crc`, IFNULL('Translation', '') AS
`sphinx_internal_class`, IFNULL(CONCAT(phrases.source_table, '.',
phrases.source_column), '') AS `col_attribute` FROM `translations` LEFT
OUTER JOIN `phrases` ON `phrases`.`id` = `translations`.`phrase_id` WHERE
(`translations`.`id` >= $start AND `translations`.`id` <= $end AND
phrases.source_table IN
('provider_service_groups','drug_informations','provider_service_codes')
AND locale_id != 1) GROUP BY `translations`.`id` ORDER BY NULL
sql_query_range = SELECT IFNULL(MIN(`id`), 1), IFNULL(MAX(`id`), 1) FROM
`translations`
sql_attr_uint = sphinx_internal_id
sql_attr_uint = sphinx_deleted
sql_attr_uint = class_crc
sql_attr_string = sphinx_internal_class
sql_attr_string = col_attribute
sql_query_info = SELECT * FROM `translations` WHERE `id` = (($id - 4) / 6)
}
index translation_core
{
source = translation_core_0
path =
/Users/frankkany/railsprojects/chapp/db/sphinx/development/translation_core
morphology = stem_en
min_stemming_len = 4
stopwords = config/sphinx_stopwords.txt
min_word_len = 4
charset_type = utf-8
}
index translation
{
type = distributed
local = translation_core
}
--
You received this message because you are subscribed to the Google Groups
"Thinking Sphinx" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/thinking-sphinx.
For more options, visit https://groups.google.com/groups/opt_out.
