Pat,
I know that Thinking Sphinx is an API to Sphinx itself, but perhaps you
know this. I have a local development machine and a staging server, both
with the same version of thinking_sphinx (213447d230) and the same version
of sphinx (2.0.6 r3473). The sphinx indexes have been built the same way
on both machines, however if I attempt to search for a non-English
character set on the staging server I am coming up with zero results, yet
it works on my local machine. Below are the console histories and the
query logs to see that they are going through identically, but with
different results. Does Sphinx use its own database or whatever? I'm
trying to figure out what the differences are...
Local Development Machine:
1.9.3p194 :001 > tt = Type.find('motors-ac').translations.where(:locale =>
'zh-CN').first
Type Load (0.5ms) SELECT `types`.* FROM `types` WHERE
`types`.`cached_slug` = 'motors-ac' AND (`types`.`name` != 'znull') LIMIT 1
TranslatedType Load (0.3ms) SELECT `translated_types`.* FROM
`translated_types` WHERE `translated_types`.`type_id` = 1220 AND
`translated_types`.`locale` = 'zh-CN' LIMIT 1
=> #<TranslatedType id: 80346, type_id: 1220, type_class: "ToolingType",
locale: "zh-CN", name: "交流电机", parent_name: "电机", created_at: "2013-02-14
16:58:12", updated_at: "2013-02-14 16:58:12">
1.9.3p194 :002 > TranslatedType.search("#{tt.name[0,2]}*")
TranslatedType Load (0.4ms) SELECT `translated_types`.* FROM
`translated_types` WHERE `translated_types`.`id` IN (80346, 81411)
=> [#<TranslatedType id: 80346, type_id: 1220, type_class: "ToolingType",
locale: "zh-CN", name: "交流电机", parent_name: "电机", created_at: "2013-02-14
16:58:12", updated_at: "2013-02-14 16:58:12">, #<TranslatedType id: 81411,
type_id: 1220, type_class: "ToolingType", locale: "zh-TW", name: "交流電機",
parent_name: "電機", created_at: "2013-02-14 16:58:17", updated_at:
"2013-02-14 16:58:17">]
development.searchd.query.log
[Mon Feb 25 12:22:29.866 2013] 0.001 sec [ext2/1/ext 2 (0,20)]
[translated_type_dd_core`, `translated_type_dds_core] 交流*
@sphinx_internal_class_name (TranslatedType)
Staging Server:
irb(main):001:0> tt = Type.find('motors-ac').translations.where(:locale =>
'zh-CN').first
Type Load (0.2ms) SELECT `types`.* FROM `types` WHERE
`types`.`cached_slug` = 'motors-ac' AND (`types`.`name` != 'znull') LIMIT 1
TranslatedType Load (0.1ms) SELECT `translated_types`.* FROM
`translated_types` WHERE `translated_types`.`type_id` = 1220 AND
`translated_types`.`locale` = 'zh-CN' LIMIT 1
=> #<TranslatedType id: 22439, type_id: 1220, type_class: "ToolingType",
locale: "zh-CN", name: "交流电机", parent_name: "电机", created_at: "2013-02-25
16:30:07", updated_at: "2013-02-25 16:30:07">
irb(main):002:0> TranslatedType.search("#{tt.name[0,2]}*")
=> []
staging.searchd.query.log
[Mon Feb 25 11:21:20.121 2013] 0.000 sec [ext2/1/ext 0 (0,20)]
[translated_type_dd_core`, `translated_type_dds_core] 交流*
@sphinx_internal_class_name (TranslatedType)
Thanks.
-Lonnie
--
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?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.
