it is, and working really well too. thanks for making this plugin man
2008/10/23 Pat Allan <[EMAIL PROTECTED]>:
>
> No problems - ideally the bug shouldn't have been there in the first
> place :)
>
> Good to know it's all sorted.
>
> --
> Pat
>
> On 22/10/2008, at 9:20 PM, Oliver Barnes wrote:
>
>>
>> I reinstalled it just now, and it's working fine :)
>> should have tried that earlier, sorry for wasting your time
>>
>> 2008/10/22 Pat Allan <[EMAIL PROTECTED]>:
>>>
>>> Ah, now *that* gives me something to work with. The fields aren't
>>> appearing in the SQL statement. I accidentally introduced a bug about
>>> two week agos that did this, then fixed it later that evening (from
>>> memory). So, how old is your copy of thinking sphinx?
>>>
>>> However, if you're running something from the last couple of days,
>>> looks like this is a different bug...
>>>
>>> --
>>> Pat
>>>
>>> On 22/10/2008, at 9:56 AM, Oliver Barnes wrote:
>>>
>>>>
>>>> Hi Pat,
>>>>
>>>> no worries, thanks for the response :)
>>>>
>>>> I did try deleting the index files and reindexing several times, no
>>>> luck there... I got the latest thinking sphinx from github, and have
>>>> just compiled the lastest stable sphinx source available a couple of
>>>> days ago. running rails 2.1.0
>>>>
>>>> here's my conf:
>>>>
>>>> indexer
>>>> {
>>>> mem_limit = 64M
>>>> }
>>>>
>>>> searchd
>>>> {
>>>> address = 127.0.0.1
>>>> port = 3312
>>>> log = /Users/oliver/Sites/portal_juridico/log/searchd.log
>>>> query_log = /Users/oliver/Sites/portal_juridico/log/
>>>> searchd.query.log
>>>> read_timeout = 5
>>>> max_children = 30
>>>> pid_file = /Users/oliver/Sites/portal_juridico/log/
>>>> searchd.development.pid
>>>> max_matches = 1000
>>>> }
>>>>
>>>> source decision_0_core
>>>> {
>>>> type = mysql
>>>> sql_host = localhost
>>>> sql_user = ********
>>>> sql_pass = ********
>>>> sql_db = juridico_development
>>>>
>>>>
>>>>
>>>> sql_query_pre = SET NAMES utf8
>>>>
>>>> sql_query_pre =
>>>> sql_query = SELECT `decisions`.`id` * 1 + 0 AS `id` ,
>>>> `decisions`.`id` AS `sphinx_internal_id`, 2111495198 AS `class_crc`,
>>>> '2111495198' AS `subclass_crcs`, 0 AS `sphinx_deleted` FROM
>>>> decisions
>>>> WHERE `decisions`.`id` >= $start AND `decisions`.`id` <= $end
>>>> GROUP BY `decisions`.`id` ORDER BY NULL
>>>> sql_query_range = SELECT MIN(`id`), MAX(`id`) FROM `decisions`
>>>> sql_query_info = SELECT * FROM `decisions` WHERE `id` = (($id -
>>>> 0) / 1)
>>>> sql_attr_uint = sphinx_internal_id
>>>> sql_attr_uint = class_crc
>>>> sql_attr_multi = uint subclass_crcs from field
>>>> sql_attr_uint = sphinx_deleted
>>>> }
>>>>
>>>> index decision_core
>>>> {
>>>> source = decision_0_core
>>>> path = /Users/oliver/Sites/portal_juridico/db/sphinx/development/
>>>> decision_core
>>>> charset_type = utf-8
>>>> morphology = stem_en
>>>> }
>>>> index decision
>>>> {
>>>> type = distributed
>>>> local = decision_core
>>>> charset_type = utf-8
>>>> }
>>>>
>>>>
>>>> 2008/10/21 Pat Allan <[EMAIL PROTECTED]>:
>>>>>
>>>>> Hi Oliver
>>>>>
>>>>> Sorry for the delay in a response - I was travelling all of
>>>>> yesterday,
>>>>> and have only just got to some internet access again (although
>>>>> about
>>>>> to dash off to a client meeting, so excuse the brevity).
>>>>>
>>>>> It is a bit of an odd problem, yes. Have you tried deleting the
>>>>> index
>>>>> files, and then reindexing? Also, what is the contents of config/
>>>>> development.sphinx.conf? (Make sure you remove your database
>>>>> passwords
>>>>> from it). How old is your version of Thinking Sphinx? And what
>>>>> version
>>>>> of Rails are you running?
>>>>>
>>>>> Cheers
>>>>>
>>>>> --
>>>>> Pat
>>>>> e: [EMAIL PROTECTED] || m: +614 1327 3337
>>>>> w: http://freelancing-gods.com || t: twitter.com/pat
>>>>> discworld: http://ausdwcon.org || skype: patallan
>>>>>
>>>>> On 21/10/2008, at 10:44 PM, Oliver Barnes wrote:
>>>>>
>>>>>>
>>>>>> hello, is this such a rare problem no one ever had it before? or
>>>>>> am I
>>>>>> doing something so dumb it's not even worth answering?
>>>>>>
>>>>>> 2008/10/20 Oliver Barnes <[EMAIL PROTECTED]>:
>>>>>>> anyone?
>>>>>>>
>>>>>>> 2008/10/20 oliver barnes <[EMAIL PROTECTED]>:
>>>>>>>>
>>>>>>>> Hello,
>>>>>>>>
>>>>>>>> I'm new to TS, and am having a problem running my first index. I
>>>>>>>> have
>>>>>>>> the following index definition on a Decision model:
>>>>>>>>
>>>>>>>> define_index do
>>>>>>>> indexes process_number, :sortable => true
>>>>>>>> indexes summary
>>>>>>>> indexes report
>>>>>>>> indexes observation
>>>>>>>> indexes doctrine
>>>>>>>> end
>>>>>>>>
>>>>>>>> there are 5 records on my table, and sql indexes for each of the
>>>>>>>> fields above, as per recommendations I found here in the list.
>>>>>>>>
>>>>>>>> when I run the index rake task, I get 5 docs with 0 bytes in
>>>>>>>> them.
>>>>>>>> and
>>>>>>>> of course, when I try starting up TS, it fails saying there's
>>>>>>>> nothing
>>>>>>>> to serve.
>>>>>>>>
>>>>>>>> $rake thinking_sphinx:index
>>>>>>>> ...
>>>>>>>> Generating Configuration to config/development.sphinx.conf
>>>>>>>> indexer --config config/development.sphinx.conf --all
>>>>>>>> Sphinx 0.9.8-release (r1371)
>>>>>>>> Copyright (c) 2001-2008, Andrew Aksyonoff
>>>>>>>>
>>>>>>>> using config file 'config/development.sphinx.conf'...
>>>>>>>> indexing index 'decision_core'...
>>>>>>>> collected 5 docs, 0.0 MB
>>>>>>>> collected 0 attr values
>>>>>>>> sorted 0.0 Mvalues, nan% done
>>>>>>>> total 5 docs, 0 bytes
>>>>>>>> total 0.010 sec, 0.00 bytes/sec, 500.00 docs/sec
>>>>>>>> distributed index 'decision' can not be directly indexed;
>>>>>>>> skipping.
>>>>>>>>
>>>>>>>> what am I doing wrong?
>>>>>>>>
>>>>>>>> One note I should add is that I added the mysql indexes after
>>>>>>>> the
>>>>>>>> data
>>>>>>>> was first loaded. I then dropped the db, migrated with the new
>>>>>>>> indexes, and then repopulated the table using fixtures. seems to
>>>>>>>> me
>>>>>>>> this shouldn't make a difference, but who knows...
>>>>>>>>
>>>>>>>> thanks in advance for any help, I've been stuck with this for a
>>>>>>>> couple
>>>>>>>> of days, and haven't found a solution anywhere yet.
>>>>>>>>
>>>>>>>> - Oliver
>>>>>>>>
>>>>>>>>
>>>>>>>>>>
>>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>> --
>>>>>>> Oliver Azevedo Barnes
>>>>>>> [EMAIL PROTECTED]
>>>>>>> +55 11 9768 0193
>>>>>>> http://www.linkedin.com/in/oliverbarnes
>>>>>>> http://workingwithrails.com/person/4704-oliver-barnes
>>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>> --
>>>>>> Oliver Azevedo Barnes
>>>>>> [EMAIL PROTECTED]
>>>>>> +55 11 9768 0193
>>>>>> http://www.linkedin.com/in/oliverbarnes
>>>>>> http://workingwithrails.com/person/4704-oliver-barnes
>>>>>>
>>>>>>>
>>>>>
>>>>>
>>>>>>
>>>>>
>>>>
>>>>
>>>>
>>>> --
>>>> Oliver Azevedo Barnes
>>>> [EMAIL PROTECTED]
>>>> +55 11 9768 0193
>>>> http://www.linkedin.com/in/oliverbarnes
>>>> http://workingwithrails.com/person/4704-oliver-barnes
>>>>
>>>>>
>>>
>>>
>>>>
>>>
>>
>>
>>
>> --
>> Oliver Azevedo Barnes
>> [EMAIL PROTECTED]
>> +55 11 9768 0193
>> http://www.linkedin.com/in/oliverbarnes
>> http://workingwithrails.com/person/4704-oliver-barnes
>>
>> >
>
>
> >
>
--
Oliver Azevedo Barnes
[EMAIL PROTECTED]
+55 11 9768 0193
http://www.linkedin.com/in/oliverbarnes
http://workingwithrails.com/person/4704-oliver-barnes
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Thinking Sphinx" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/thinking-sphinx?hl=en
-~----------~----~----~----~------~----~------~--~---
