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

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

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Blocker
    • Resolution: Fixed
    • 3.1.0-RC5
    • 3.1.0-RC6
    • Search
    • 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.

      Attachments

        Activity

          People

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

            Dates

              Created:
              Updated:
              Resolved: