The OS X installation was done with brew, and the others were done from
source (http://sphinxsearch.com/docs/2.0.6/installing.html). Does this
help any?
On Monday, February 25, 2013 8:53:06 PM UTC-5, Pat Allan wrote:
>
> 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] <javascript:>.
> > To post to this group, send email to
> > [email protected]<javascript:>
> .
> > 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.
