Right - the sphinx_internal_class shouldn't be sql_attr_str2ordinal, but
sql_attr_string. That's the problem, but as for the cause... can you try the
latest TS gem release instead of Github? v2.0.7
--
Pat
On 30/08/2011, at 7:23 PM, Timo Virkkala wrote:
> Hi,
>
> I'll try to create a minimal example and post that somewhere.
> Meanwhile, some snippets from the current conf file:
>
> source brand_core_0
> {
> [...]
> sql_query = SELECT [...] 3717453404 AS `class_crc`, IFNULL('Brand',
> '') AS `sphinx_internal_class` [...]
> [...]
> sql_attr_uint = class_crc
> sql_attr_str2ordinal = sphinx_internal_class
> [...]
> }
>
> Is that what you were looking for? That's from a table which does not
> have STI. One STI table has the following:
>
> source party_core_0
> {
> [...]
> sql_query = SELECT [...] CASE IFNULL(`parties`.`type`, '') WHEN
> 'Person' THEN 863032384 WHEN 'Organization' THEN 3655317636 ELSE
> 1213489636 END AS `class_crc`, IFNULL(`parties`.`type`, '') AS
> `sphinx_internal_class` [...]
> [...]
> sql_attr_uint = class_crc
> sql_attr_str2ordinal = sphinx_internal_class
> [...]
> }
>
> -Timo
>
> On Tue, Aug 30, 2011 at 11:58, Pat Allan <[email protected]> wrote:
>> Hi Timo
>>
>> Thanks for getting back to me. Can you share your development.sphinx.conf
>> file in a gist or similar? Make sure you remove the database password from
>> each source.
>>
>> --
>> Pat
>>
>> On 29/08/2011, at 7:50 PM, Timo Virkkala wrote:
>>
>>> Hi Pat,
>>>
>>> And thanks for the quick reply. Yeah, it happens in all environments. We do
>>> have some STI with a column called 'type' in one table. But the problem
>>> exists even when I limit indexing to only one of our models (and remove the
>>> older index files), and that one doesn't have a column called 'type'.
>>>
>>> -Timo
>>>
>>> --
>>> You received this message because you are subscribed to the Google Groups
>>> "Thinking Sphinx" group.
>>> To view this discussion on the web visit
>>> https://groups.google.com/d/msg/thinking-sphinx/-/2ebUP3XjggEJ.
>>> 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.
>>
>> --
>> 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.
>>
>>
>
> --
> 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.
>
--
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.
