Sphinx non-fulltext, integer only search

Posted by James on Stack Overflow See other posts from Stack Overflow or by James
Published on 2010-05-29T17:19:49Z Indexed on 2010/05/29 17:22 UTC
Read the original article Hit count: 298

Filed under:
|
|

Hello guys,

I've got a few tables that literally only hold integers, no "words" and for some reason Sphinx is unable to hold this data in it's library. Just returns "0 bytes" errors for these indexes.

Is it possible to do this? If so, how? Below is an example from my Sphinx.conf for one that fails.

source track
{
 type     = mysql

 sql_host    = host
 sql_user    = user
 sql_pass    = pass
 sql_db     = db
 sql_port    = port

 sql_query    = SELECT id, user, time FROM track;

 sql_attr_uint   = user
 sql_attr_uint   = time

 sql_query_info   = SELECT * FROM track WHERE id=$id
}

index track
{
 source     = track
 path     = /var/lib/sphinx/track
 docinfo     = extern
 charset_type   = utf-8
 min_prefix_len   = 1
 enable_star    = 1
}

© Stack Overflow or respective owner

Related posts about php

Related posts about sphinx