Also of note, my development machine is an OS X machine, the staging server
is Debian Squeeze, and another developer's machine (also not finding any
records) is ubuntu 12.04.
On Monday, February 25, 2013 12:46:24 PM UTC-5, Lonnie Warpup wrote:
>
> 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: "交流���C",
> parent_name: "���C", 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.
