Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
3.1.0-dev
-
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.