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

Sphinx index() function triggers slow queries that time out replies

    Details

    • Type: Bug
    • Status: Unverified Fix
    • Priority: Blocker
    • Resolution: Fixed
    • Affects Version/s: 3.1.0-RC5
    • Fix Version/s: 3.1.0-RC6
    • Component/s: Search
    • Labels:
      None

      Description

      It seems that the query in https://github.com/phpbb/phpbb/blob/develop-ascraeus/phpBB/phpbb/search/fulltext_sphinx.php#L698 is entirely missing a WHERE clause and simply selecting all posts of all topics joined with all other posts which can be millions of results.

        Activity

        There are no comments yet on this issue.

          People

          • Assignee:
            naderman Nils Adermann
            Reporter:
            naderman Nils Adermann
          • Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved:

              Development