Yeah I can see that it's an old Sphinxsearch version, I will try to update,
and see if that changes anything
Den tirsdag den 8. april 2014 16.52.30 UTC+2 skrev Daniel Gottschalck:
>
> Hi Pat
>
> Just came home and edited the configs, and the 2 environments on the
> remote server.
>
>>
>> production: &production
>> adapter: mysql2
>> host: xxx
>> database: xxx
>> username: xxx
>> password: xxx
>> encoding: utf8
>> development: &production
>> adapter: mysql2
>> host: xxx
>> database: xxx
>> username: xxx
>> password: xxx
>> encoding: utf8
>> project_data:
>> adapter: mysql2
>> host: xxx
>> database: xxxx
>> username: xxx
>> password: xxx
>
>
> The search URL is: /search?utf8=✓&search=brøndby
>
> It still works fine locally, all though I've also changed the 2
> environments there.
>
> The deploy output:
>
>
> ** [out :: domain.dk]
>>> ********************************************************************************
>>
>> ** [out :: domain.dk] {:adapter=>"mysql2", :host=>"host",
>>> :database=>"db", :username=>"user", :password=>"pass", :encoding=>"utf8"}
>>
>> ** [out :: domain.dk]
>>> ********************************************************************************
>>
>> ** [out :: domain.dk] Generating configuration to
>>> /home/dir/app/releases/20140408144244/config/production.sphinx.conf
>>
>> ** [out :: domain.dk] Sphinx 2.0.4-release (r3135)
>>
>> ** [out :: domain.dk] Copyright (c) 2001-2012, Andrew Aksyonoff
>>
>> ** [out :: domain.dk] Copyright (c) 2008-2012, Sphinx Technologies Inc (
>>> http://sphinxsearch.com)
>>
>> ** [out :: domain.dk]
>>
>> ** [out :: domain.dk] using config file
>>> '/home/dir/app/releases/20140408144244/config/production.sphinx.conf'...
>>
>> ** [out :: domain.dk] indexing index 'refinery_wayfinders_club_core'...
>>
>> ** [out :: domain.dk] WARNING: collect_hits: mem_limit=0 kb too low,
>>> increasing to 13824 kb
>>
>> ** [out :: domain.dk] collected 75 docs, 0.0 MB
>>
>> ** [out :: domain.dk] sorted 0.0 Mhits, 100.0% done
>>
>> ** [out :: domain.dk] total 75 docs, 1835 bytes
>>
>> ** [out :: domain.dk] total 0.039 sec, 46892 bytes/sec, 1916.59 docs/sec
>>
>> ** [out :: domain.dk] indexing index 'refinery_page_core'...
>>
>> ** [out :: domain.dk] WARNING: collect_hits: mem_limit=0 kb too low,
>>> increasing to 13568 kb
>>
>> ** [out :: domain.dk] collected 10 docs, 0.0 MB
>>
>> ** [out :: domain.dk] sorted 0.0 Mhits, 100.0% done
>>
>> ** [out :: domain.dk] total 10 docs, 205 bytes
>>
>> ** [out :: domain.dk] total 0.021 sec, 9720 bytes/sec, 474.18 docs/sec
>>
>> ** [out :: domain.dk] indexing index
>>> 'refinery_wayfinders_project_core'...
>>
>> ** [out :: domain.dk] WARNING: collect_hits: mem_limit=0 kb too low,
>>> increasing to 14080 kb
>>
>> ** [out :: domain.dk] collected 189 docs, 0.0 MB
>>
>> ** [out :: domain.dk] sorted 0.0 Mhits, 100.0% done
>>
>> ** [out :: domain.dk] total 189 docs, 16227 bytes
>>
>> ** [out :: domain.dk] total 0.393 sec, 41230 bytes/sec, 480.22 docs/sec
>>
>> ** [out :: domain.dk] skipping non-plain index
>>> 'refinery_wayfinders_club'...
>>
>> ** [out :: domain.dk] skipping non-plain index 'refinery_page'...
>>
>> ** [out :: domain.dk] skipping non-plain index
>>> 'refinery_wayfinders_project'...
>>
>> ** [out :: domain.dk] total 9 reads, 0.000 sec, 2.7 kb/call avg, 0.0
>>> msec/call avg
>>
>> ** [out :: domain.dk] total 27 writes, 0.001 sec, 2.4 kb/call avg, 0.0
>>> msec/call avg
>>
>> ** [out :: domain.dk] rotating indices: succesfully sent SIGHUP to
>>> searchd (pid=13727).
>>
>>
>>
>
> So, what to do...
>
>
>
> Den tirsdag den 8. april 2014 09.04.15 UTC+2 skrev Pat Allan:
>>
>> 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
>>>> thinkin...@googlegroups.<http://googlegroups.com/>
>>>> com <http://googlegroups.com/>.
>>>> 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.
