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
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
