title: Sphinx Search Index
body: <p>I'm having an issue with a Sphinx Search Index. I keep getting empty result sets from it.</p>
  
  <pre><code>source mrc
  {
      type     = mysql
      sql_host = localhost
      sql_user = root
      sql_pass = 
      sql_db   = test_db
      sql_port = 3306
      mysql_connect_flags = 32
  
      sql_query_pre = SET NAMES latin1
      sql_query_pre = SET SESSION query_cache_type=OFF
      sql_query_pre = REPLACE INTO sphinx.indexer (idx,server,version,lastrun_at) SELECT 'mrc','localhost','2.0.4',UNIX_TIMESTAMP(NOW()) FROM DUAL
      sql_query_post = UPDATE sphinx.indexer SET fetched_by = UNIX_TIMESTAMP(NOW()) WHERE idx = 'mrc' AND server = 'localhost' AND version = '2.0.4'
      sql_query_post_index = UPDATE sphinx.indexer SET indexed_by = UNIX_TIMESTAMP(NOW()) WHERE idx = 'mrc' AND server = 'localhost' AND version = '2.0.4'
  
      sql_attr_uint = mrc_id
      sql_attr_uint = mrc_parent
      sql_attr_float = mrc_latitude   
      sql_attr_float = mrc_longitude  
  
      sql_query = \
          SELECT mrc_id AS doc_id, \
          mrc_id, \
          mrc_parent, \
          RADIANS(mrc_latitude) as mrc_latitude, \
          RADIANS(mrc_longitude) as mrc_longitude \
          FROM mrc_table \
          WHERE mrc_parent &gt; 0
  
      sql_query_info = SELECT * FROM mrc_table WHERE mrc_id = $id
  
  }
  
  index mrc
  {
      charset_type = sbcs
      docinfo = extern
      mlock = 1
      morphology = none
      source = mrc
      path = /usr/local/var/data/mrc
  }
  </code></pre>
  
  <p>indexer gives me - </p>
  
  <pre><code>indexing index 'member_region_cities'...
  collected 78312 docs, 0.0 MB
  total 78312 docs, 0 bytes
  total 0.656 sec, 0 bytes/sec, 119354.57 docs/sec
  </code></pre>
  
  <p>If I connected to searchd through mysql and do</p>
  
  <pre><code>SELECT * FROM mrc_table;
  </code></pre>
  
  <p>It returns empty.</p>
  
  <p>Theres definitely data in the localhost table, you can see it where the indexer says 'collected 78312'</p>
  
  <p>So why isn't Sphinx putting the data into searchd?</p>
  
  <p>Cheers</p>