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