Yup, worth setting the encoding setting for both environments. On 8 Apr 2014, at 5:02 pm, Daniel Gottschalck <[email protected]> wrote:
> Heya > > Thanks alot, sorry, misread before :-) I will check when I'm off work, I only > have access from home. I assume they are both the latest, 2.1.4. > > - There is no encoding set in either database environment in database.yml - > should I set it? > > - I will change my deploy and cron(rake task) aswell > > Thanks > > > Den tirsdag den 8. april 2014 08.56.58 UTC+2 skrev Pat Allan: > 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. -- 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.
