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:

  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}   

This is the main line:

  sql_query_killlist = stopwords_torrents   

My stopwords_torrents Select from the torrent_id table looks like this:

  mysql> Choose * from Stopwords_torrents; + ---- + ------------ + | ID | Torrent_ID | + ---- + ------------ + | 2 | 14115 | + ---- + ------------ + 1 set in row (0.00 seconds)   

When you go to SphinxQL

  mysql -h 0 -P 9306   

And type it, I still get deleted documents. what is this?

  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)    

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 .

Comments

Popular posts from this blog

Pass DB Connection parameters to a Kettle a.k.a PDI table Input step dynamically from Excel -

multithreading - PhantomJS-Node in a for Loop -

c++ - MATLAB .m file to .mex file using Matlab Compiler -