Hi Daniel Thanks for those details - all useful, but one more bit of detail may be helpful: what version of *Sphinx* (not Thinking Sphinx) is installed in each environment? Best to make sure they’re the same (and, ideally, 2.1.4 or newer on both machines).
However, my thinking is as follows: * You likely have encoding set to utf8 in your config/database.yml file for your development environment. You’ll want to set this for your production environment as well. * You only need to run the ts:rebuild task when your index structure changes (it’s the equivalent of db:migrate) - and ts:rebuild stops and starts your Sphinx daemon, which is likely why you’ve seen some ‘no enabled local indexes’ errors. Change your cron task to just the ts:index instead, which will avoid restarting the daemon. Cheers — Pat On 8 Apr 2014, at 4:39 pm, Daniel Gottschalck <[email protected]> wrote: > Hi Pat > > Thanks for your response. > > Both environments are using latest Thinking Sphinx gem '3.1.0' - along with > MySQL - and mysql2 gem (latest) > > I have a whenever cron task, to run ts:rebuild at 12pm every day. > > Den tirsdag den 8. april 2014 00.46.26 UTC+2 skrev Pat Allan: > What database and what version of Sphinx are you using locally? And what > about on production? > > Also: do you have any cron tasks set up that involve Sphinx/Thinking Sphinx? > > On 8 Apr 2014, at 5:16 am, Daniel Gottschalck <[email protected]> wrote: > >> Hi >> >> >> Ive implemented Thinking Sphinx on a site. >> >> The search functionality works fine in development on my MacBook Pro OSX >> 10.9.2. >> >> I can do search with æ,ø,å letters and results will show just fine. The >> search I do is with city names "Århus, Værløse, Allerød". >> >> >> But when I try with the same letters on the remote server which is Ubuntu >> 12.04, Apache/Passenger setup, it wont return any results at all. >> >> >> I can search with any other english letter: a-y >> >> >> I received this error sometime aswell: >> >> ThinkingSphinx::SphinxError: no enabled local indexes to search >> search#index >> >> >> rake ts:rebuild etc works just fine: >> >> indexing index 'refinery_wayfinders_club_core'... >> >> WARNING: collect_hits: mem_limit=0 kb too low, increasing to 13824 kb >> >> collected 75 docs, 0.0 MB >> >> sorted 0.0 Mhits, 100.0% done >> >> total 75 docs, 1781 bytes >> >> total 0.052 sec, 33804 bytes/sec, 1423.52 docs/sec >> >> indexing index 'refinery_page_core'... >> >> WARNING: collect_hits: mem_limit=0 kb too low, increasing to 13568 kb >> >> collected 10 docs, 0.0 MB >> >> sorted 0.0 Mhits, 100.0% done >> >> total 10 docs, 205 bytes >> >> total 0.030 sec, 6629 bytes/sec, 323.40 docs/sec >> >> indexing index 'refinery_wayfinders_project_core'... >> >> WARNING: collect_hits: mem_limit=0 kb too low, increasing to 14368 kb >> >> collected 189 docs, 0.0 MB >> >> collected 928 attr values >> >> sorted 0.0 Mvalues, 100.0% done >> >> sorted 0.0 Mhits, 100.0% done >> >> total 189 docs, 15852 bytes >> >> total 0.404 sec, 39155 bytes/sec, 466.83 docs/sec >> >> skipping non-plain index 'refinery_wayfinders_club'... >> >> skipping non-plain index 'refinery_page'... >> >> skipping non-plain index 'refinery_wayfinders_project'... >> >> total 1310 reads, 0.010 sec, 0.0 kb/call avg, 0.0 msec/call avg >> >> total 29 writes, 0.002 sec, 3.4 kb/call avg, 0.0 msec/call avg >> >> Started searchd successfully (pid: 21517). >> >> >> >> I tried adding a thinking_sphinx.yml config file with a charset_table with >> all the neccessary unicodes, then it wouldn't reindex at all. >> >> So, any suggestions? >> >> How can I get the production environment to allow the "æ,ø,å" characters so >> the search will work? >> >> >> Thanks in advance >> >> >> Regards >> >> -- >> 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. >> For more options, visit https://groups.google.com/d/optout. > > > -- > 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. > For more options, visit https://groups.google.com/d/optout. -- 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. For more options, visit https://groups.google.com/d/optout.
