当前位置：Gxlcms > PHP教程 > sphinx以mysql为数据源建索引失败

sphinx以mysql为数据源建索引失败

时间：2021-07-01 10:21:17 帮助过：9人阅读

这是sphinx.conf 的内容
source src1
{

    type                    = mysql

    sql_host                = localhost
    sql_user                = root
    sql_pass                = 1goodlusslulU
    sql_db                  = fangxinjia_sku
    sql_port                = 3306  # optional, default is 3306

    sql_query_pre        = SET NAMES utf8
   # sql_query_pre        = SET SESSION query_cache_type=OFF

    sql_query               = \
            SELECT product_attribute_id,product_name \
            FROM product_attribute

    sql_attr_uint           = product_attribute_id
    sql_attr_string         = product_name

}

这是我建立索引的命令 /usr/local/sphinx/bin/indexer --config /usr/local/sphinx/etc/sphinx.conf --all
执行完一直是这个结果，

Sphinx 2.2.10-id64-release (2c212e0)
Copyright (c) 2001-2015, Andrew Aksyonoff
Copyright (c) 2008-2015, Sphinx Technologies Inc (http://sphinxsearch.com)

using config file '/usr/local/sphinx/etc/sphinx.conf'...
skipping non-plain index 'product_attribute'...
total 0 reads, 0.000 sec, 0.0 kb/call avg, 0.0 msec/call avg
total 0 writes, 0.000 sec, 0.0 kb/call avg, 0.0 msec/call avg

求教有什么问题，感谢

mysql库中有文件，索引执行命运也没有报错，但就是没数据

回复内容：