设置Sphinx

Question

哈哈，别嘲笑我，我只是想在我当地的WAMP上设置Sphinx，我以前没有做过，所以我可能在做一些愚蠢的事情。

这是我的sphinx.conf文件：

source code
{
    type = mysql
    sql_host = localhost
    sql_user = root
    sql_pass =
    sql_db = ****
    sql_port = 3306
    sql_query = SELECT id, language_id, category_id, title, description, UNIX_TIMESTAMP(time_posted) AS time_posted FROM codes
    sql_attr_uint = language_id
    sql_attr_uint = category_id
    sql_attr_timestamp = time_posted
    sql_query_info = SELECT id FROM codes WHERE id=$id
}

index code
{
    source = code
    path = C:/Program Files/Wampserver 2/sphinx/var/data/sphinx/code
    morphology = stem_en
    min_word_len = 3
    min_prefix_len = 0
}

searchd
{
    port = 3312
    log = C:/Program Files/Wampserver 2/sphinx/var/log/searchd/searchd.log
    query_log = C:/Program Files/Wampserver 2/sphinx/var/log/searchd/query.log
    pid_file = C:/Program Files/Wampserver 2/sphinx/var/log/searchd/searchd.pid
}

当我尝试建立索引时，我得到了这个错误：

ERROR: index 'code': column number 1 has no name.

此问题的原因可能是什么？谢谢。

Answer 1

版本不匹配？

http://www.sphinxsearch.com/forum/view.html?id=937

Answer 2

只需将文件bin/libmySQL.dll替换为来自官方PHP php-5.2.1-Win32.zip.的MySql版本5.0.37中的文件

Answer 3

您需要使libmysqlclient15-dev包版本与libmysqlclient15的版本相同。你是?