brew adds a few flags in automatically - what flags are you compiling with on the Ubuntu/Debian boxes? https://github.com/mxcl/homebrew/blob/master/Library/Formula/sphinx.rb
If you're using stemming, this could be related… although unlikely. -- Pat On 27/02/2013, at 1:15 AM, Lonnie Warpup wrote: > 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]. > > 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. > > -- 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.
