diff --git a/etc/sphinx.conf.in b/etc/sphinx.conf.in index bcd1aa7..936687f 100644 --- a/etc/sphinx.conf.in +++ b/etc/sphinx.conf.in @@ -59,9 +59,9 @@ source tag : base { sql_query_pre = SET NAMES utf8 - sql_query = SELECT `_id`, `id`, `uid`, `tag` FROM `tag` + sql_query = SELECT `_id`, `id` AS iid, `uid`, `tag` FROM `tag` - sql_attr_uint = id + sql_attr_uint = iid sql_attr_uint = uid } @@ -70,9 +70,9 @@ source note : base { sql_query_pre = SET NAMES utf8 - sql_query = SELECT `_id`, `id`, `uid`, `note` FROM `note` + sql_query = SELECT `_id`, `id` AS iid, `uid`, `note` FROM `note` - sql_attr_uint = id + sql_attr_uint = iid sql_attr_uint = uid } @@ -83,8 +83,6 @@ source = main1 path = /var/piler/sphinx/main1 docinfo = extern - charset_type = utf-8 - enable_star = 1 min_prefix_len = 6 min_word_len = 1 #ngram_len = 1 @@ -96,8 +94,6 @@ source = main2 path = /var/piler/sphinx/main2 docinfo = extern - charset_type = utf-8 - enable_star = 1 min_prefix_len = 6 min_word_len = 1 #ngram_len = 1 @@ -109,8 +105,6 @@ source = main3 path = /var/piler/sphinx/main3 docinfo = extern - charset_type = utf-8 - enable_star = 1 min_prefix_len = 6 min_word_len = 1 #ngram_len = 1 @@ -122,8 +116,6 @@ source = main4 path = /var/piler/sphinx/main4 docinfo = extern - charset_type = utf-8 - enable_star = 1 min_prefix_len = 6 min_word_len = 1 #ngram_len = 1 @@ -135,8 +127,6 @@ source = dailydelta path = /var/piler/sphinx/dailydelta1 docinfo = extern - charset_type = utf-8 - enable_star = 1 min_prefix_len = 6 min_word_len = 1 #ngram_len = 1 @@ -148,8 +138,6 @@ source = delta path = /var/piler/sphinx/delta1 docinfo = extern - charset_type = utf-8 - enable_star = 1 min_prefix_len = 6 min_word_len = 1 #ngram_len = 1 @@ -162,8 +150,6 @@ source = tag path = /var/piler/sphinx/tag1 docinfo = extern - charset_type = utf-8 - enable_star = 1 min_prefix_len = 6 min_word_len = 1 #ngram_len = 1 @@ -176,8 +162,6 @@ source = note path = /var/piler/sphinx/note1 docinfo = extern - charset_type = utf-8 - enable_star = 1 min_prefix_len = 6 min_word_len = 1 #ngram_len = 1 @@ -206,5 +190,4 @@ preopen_indexes = 1 unlink_old = 1 workers = threads # for RT to work - compat_sphinxql_magics = 0 } diff --git a/init.d/rc.searchd.in b/init.d/rc.searchd.in index fa03a90..25476e2 100644 --- a/init.d/rc.searchd.in +++ b/init.d/rc.searchd.in @@ -20,6 +20,12 @@ start() { echo "starting searchd . . ." + + if [ ! -d /var/run/piler ]; then + mkdir -p /var/run/piler + chown piler:piler /var/run/piler + fi + if [ `id -u` -eq 0 ]; then su piler -c searchd else diff --git a/webui/model/search/search.php b/webui/model/search/search.php index 094a6c7..68a7ec0 100644 --- a/webui/model/search/search.php +++ b/webui/model/search/search.php @@ -417,10 +417,11 @@ $s = $this->fixup_sphinx_operators($s); - $q = $this->sphx->query("SELECT id FROM $sphx_table WHERE uid=" . $session->get("uid") . " AND MATCH('@$field $s') "); + $q = $this->sphx->query("SELECT iid FROM $sphx_table WHERE uid=" . $session->get("uid") . " AND MATCH('@$field $s') "); + if(ENABLE_SYSLOG == 1) { syslog(LOG_INFO, "sql: " . $q->query); } foreach($q->rows as $a) { - $id_list .= "," . $a['id']; + $id_list .= "," . $a['iid']; } if($id_list) { $id_list = substr($id_list, 1, strlen($id_list)); } @@ -446,10 +447,10 @@ } - $q = $this->db->query("SELECT id FROM " . TABLE_FOLDER_MESSAGE . " WHERE folder_id IN ($q)", $__folders); + $q = $this->db->query("SELECT iid FROM " . TABLE_FOLDER_MESSAGE . " WHERE folder_id IN ($q)", $__folders); foreach($q->rows as $a) { - $id_list .= "," . $a['id']; + $id_list .= "," . $a['iid']; } if($id_list) { $id_list = substr($id_list, 1, strlen($id_list)); }