Uploaded image for project: 'phpBB'
  1. phpBB
  2. PHPBB-11438

Sphinx default config does not work properly

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Fixed
    • Icon: Major Major
    • 3.1.0-a1
    • 3.1.0-dev
    • Search
    • None

      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.

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

              Created:
              Updated:
              Resolved: