Sphinx内部错误:传入模式不匹配

Question

我正在努力使这个索引正常工作：

sql_query               = \

SELECT bo.es_id, bo.es_id as id, mem.es_country, es_uid, bo.es_featured 
as es_featured,
**bo.es_reverse_featured**, mem.es_signup_status as es_signup_status, mem.es_memtype as es_memtype, es_title, es_keywords, bo.tempdate, bo.es_postedon, bo.es_reverse_featured, bo.es_viewed, mem.es_reverse_memtype \
                FROM ephpb2b_offers_buy bo INNER JOIN ephpb2b_members mem ON bo.es_uid=mem.es_id \
        Where bo.es_featured IN (0,1)

sql_attr_uint = id
sql_attr_uint = es_signup_status
sql_attr_uint = es_memtype
sql_attr_uint = es_reverse_memtype
sql_attr_uint = es_country
sql_attr_uint = es_uid
sql_attr_timestamp = es_postedon
sql_attr_timestamp = tempdate
**sql_attr_uint = es_reverse_featured**
sql_attr_uint = es_viewed
sql_attr_uint = es_featured

这给我带来了错误：

    index tradeban_b2bdb_bo_relevent: INTERNAL ERROR: incoming-schema mismatch
(in=uint es_reverse_featured:32@288, my=uint es_reverse_featured:32@128)

我试过谷歌搜索，并想出了这个问题。但这是关于Ruby和thinking-sphinx和我正在使用php。这个错误意味着什么?我如何解决它？

Answer 1

根据我从几个回答中所了解到的，其他一些问题和源码：你有

• 为同一列创建多个索引
• 或者，在我看来，更有可能的是，您也有一个名为es_reverse_featured的索引。由于您试图在查询中选择一个同名列，因此会发生冲突。

尝试下面的查询，它将列重命名为es_reverse_featured_2

SELECT bo.es_id, bo.es_id as id, mem.es_country, es_uid,
 bo.es_featured AS es_featured,
 bo.es_reverse_featured AS es_reverse_featured_2,
 mem.es_signup_status AS es_signup_status, mem.es_memtype as es_memtype, es_title,
 es_keywords, bo.tempdate, bo.es_postedon, bo.es_reverse_featured, bo.es_viewed,
 mem.es_reverse_memtype
FROM ephpb2b_offers_buy bo
INNER JOIN ephpb2b_members mem ON bo.es_uid=mem.es_id
Where bo.es_featured IN (0,1)

Answer 2

谢谢你们的帮助，伙计们。

我发现我在select语句中选择了两次es_reverse_featured：

Select es_reverse_featured, other_field1, other_field2, es_reverse_featured from table1。

我删除了另一个条目，问题解决了。