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.
