Uploaded image for project: 'phpBB3'
  1. phpBB3
  2. PHPBB3-16258

Sample Sphinx configuration file causes delta index to only include the most recent post

    XMLWordPrintable

Details

    Description

      The sample Sphinx search configuration file in ./docs/sphinx.sample.conf contains 2 errors which result in indexer only updating the delta index with the most recent post and not every post since the last indexing of the main index.

      The first error is at line 44: 

       
       sql_query_pre =

      As per the Sphinx documentation, character encoding must be reset for the delta index configuration, so line 44 should instead read:

      sql_query_pre = SET NAMES 'utf8'

      The second error is at line 64:

        sql_query_pre =

       

      By not specifying a new blank sql_query_post_index value, it repeats the last sql_query_post_index definition for the main index, which sets the SPHINX_TABLE max_doc_id column to the most recent post ID. Every time the delta indexer is run, max_doc_id is set to the most recent post_id in the database and so the delta index will only ever contain the most recent forum post.

      Line 64 should therefore be amended to:

        sql_query_post_index =

       
      These amendments are also consistent with the pro forma sphinx.conf file generated by the ACP Sphinx search module.

      Attachments

        Activity

          People

            Marc Marc [X] (Inactive)
            KYPREO KYPREO [X] (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: