sphinxql - Sphinx sql_query_killlist is ignored -
I am trying to get the main index to work, but whatever I do, the deleted document is now The SPINXQUL result is also my Sphinx version 2.0.4 . A part of the sphinx.conf file: This is the main line: My stopwords_torrents Select from the torrent_id table looks like this: When you go to SphinxQL And type it, I still get deleted documents. what is this? A mark-list on the index removes documents from the previous index. If you want to remove the documents from the results, then just click the < Modify the code> sql_query .
source torrent {type = mysql sql_host = localhost sql_user = torrents sql_pass = torrents sql_db = torrents Sql_port = 3306 sql_sock = /var/run/mysqld/mysqld.sock sql_query_range = Select MIN (ID), torrents from MAX (id) sql_range_step = 1000 sql_query = \ code, torrents.id, torrents.id, text_data. Select torrent, language_id, category, title, word, hex (torrents.code), amount as seed (trackers_torrents.seeds), zodiac (trackers_torrents.peers) peer, size, creation_date, rating `text_data` \ LEFT Join Torrent.id = text_data.torrent Leave trackers_torrents.torrent = torrents.id Add \ trackers_torrents` to \ where text_data.torrent & gt; = $ Start and text_data.torrent & lt; = $ end \ and `trackers_torrents`.status = 'OK' and` torrents`.is_stopword = 0 \ group by text_data.torrent \ ORDER by text_data.torrent asc \ sql_attr_uint = torrent sql_attr_uint = language_idid sql_attr_string = title sql_field_string = word sql_attr_string = Code sql_attr_uint = seeds sql_attr_uint = companions sql_attr_uint = category sql_attr_bigint = size sql_attr_bigint = CREATION_DATE sql_attr_uint = rating sql_query_pre = set name UTF8 sql_query_pre = set session query_cache_type = off sql_query_killlist = torrent_id selection from stopwords_torrents}
sql_query_killlist = stopwords_torrents
mysql> Choose * from Stopwords_torrents; + ---- + ------------ + | ID | Torrent_ID | + ---- + ------------ + | 2 | 14115 | + ---- + ------------ + 1 set in row (0.00 seconds)
mysql -h 0 -P 9306
mysql> Select ID, edge, all_torrents from WHERE ID = 14115; + ------- + -------- + --------- + ---------------------- -------------------- + ------- + | ID | Weight | Edge | Code | ID | + ------- + -------- + --------- + ---------------------- -------------------- + ------- + | 14115 | 1 | 14115 | 4956 A4E 9 76EA 948025C3C3554567 CA2820F 65F64 | 14115 | + ------- + -------- + --------- + ---------------------- -------------------- + ------- + 1 line set (0.00 seconds)
Comments
Post a Comment