Can anybody help me with Sphinx Search…I have a two-word search criteria, it only search for the last word…I have hitless_words = all and index_exact_words = 1…
The source and index are almost default except for the hitless and exact. I have entries on the database that is 1 Fruit and 2 Fruits, I searched for 1 Fruit, even 2 Fruit is showing.
This is my conf:
source list
{
type = mysql
sql_host = localhost
sql_user = root
sql_pass = pr0p3r7y
sql_db = pwf_pool
sql_sock = /var/run/mysqld/mysqld.sock
sql_port = 3306
# indexer query
# document_id MUST be the very first field
# document_id MUST be positive (non-zero, non-negative)
# document_id MUST fit into 32 bits
# document_id MUST be unique
sql_query = \\
SELECT \\
listing_id AS id, language_id, \\
header_text, \\
FROM \\
listing_headers;
# sql_group_column = language_id
sql_attr_uint = language_id
# sql_attr_uint = list
# document info query
# ONLY used by search utility to display document information
# MUST be able to fetch document info by its id, therefore
# MUST contain '$id' macro
#
sql_query_info = SELECT * FROM pw_listing WHERE listing_id=$id
}
index list
{
source = list
path = /var/lib/sphinxsearch/data/list
# morphology = stem_en
index_exact_words = 1
charset_type = utf-8
min_word_len = 2
min_prefix_len = 0
min_infix_len = 3
}
indexer
{
mem_limit = 512M
max_iops = 40
max_iosize = 1048576
}
searchd
{
port = 3312
log = /var/log/searchd/searchd.log
query_log = /var/log/searchd/query.log
pid_file = /var/log/searchd/searchd.pid
}
Thank you very much!