This is a little surprising $)A !-
What versions of Ruby are you using across all machines? And how was Sphinx
installed on each? Compiled by hand? Apt packages? Homebrew?
--
Pat
On 26/02/2013, at 6:04 AM, Lonnie Warpup wrote:
> 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: " $)A =;Aw5g;z ", parent_name: " 5g;z ", 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: " $)A =;Aw5g;z ", parent_name: " 5g;z ", 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: "
> =;Aw $)GgYq" ", parent_name: " gYq" ", 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] $)A =;Aw *
> @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: " $)A =;Aw5g;z ", parent_name: " 5g;z ", 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] $)A =;Aw *
> @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.
>
>
--
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.
