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

Sphinx default config does not work properly

    Details

    • Type: Bug
    • Status: Unverified Fix
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 3.1.0-dev
    • Fix Version/s: 3.1.0-a1
    • Component/s: Search
    • Labels:
      None

      Description

      The first error is Invalid use of group function

      using config file '...\phpBB\store\Sphinx\config\sphinx.conf'...
      indexing index 'index_phpbb_eac599d2e4ab71e6_main'...
      ERROR: index 'index_phpbb_eac599d2e4ab71e6_main': sql_query_pre[1]: Invalid use of group function (DSN=mysql://root:***@localhost:3306/phpbb_git_3.1_softdelete).

      caused by the sql_query_pre from the _main source.

      sql_query_pre = UPDATE phpbb_sphinx SET max_doc_id = MAX(post_id) WHERE counter_id = 1

      Query should be

      sql_query_pre = UPDATE phpbb_sphinx SET max_doc_id = (SELECT MAX(post_id) FROM phpbb_posts) WHERE counter_id = 1

      The second issue (at least on windows), is

      ERROR: unknown key name 'p' in ...\phpBB\store\Sphinx\config\sphinx.conf line 14 col 4.
      FATAL: failed to parse config file '...\store\Sphinx\config\sphinx.conf'

      caused by both, the _main and _delta sources' sql_query.
      The queries should be in one line only, not split up over multiple lines.

      Also the query is imploded by additional \ in every line. They need to be removed.

        Attachments

          Activity

            People

            • Assignee:
              nickvergessen Joas Schilling
              Reporter:
              nickvergessen Joas Schilling
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: