I cannot figure out the differences and this is driving me crazy. Do you have any suggestions on how I can interact with the sphinx engine directly for a test, and not go through TS? I want to see if it is TS, or sphinx itself. These queries worked prior to my upgrade to TS3. I tried using the search command line tool, but that appears to be broken and not supported anymore.
On Wednesday, February 27, 2013 10:19:18 PM UTC-5, Pat Allan wrote: > > 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] <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.
