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

Fulltext mysql search excludes 3 letter words; native includes them

    XMLWordPrintable

Details

    • Improvement
    • Status: Closed (View Workflow)
    • Minor
    • Resolution: Invalid
    • 3.0.4
    • 3.0.10-RC1
    • Search
    • None
    • PHP Environment: 5.2.6
      Database: MySQL 5.0.67-community

    Description

      With "Min characters indexed by search"=3, 3 letter words are searchable with Fulltext native Search Backend, but not with Fulltext mysql. Both find 4 letter words.

      Problem was verified with a fresh install of phpBB 3.0.4 downloaded from phpbb.com. A second post, containing three 3 letter words, was added to the same forum containing the standard initial post installed automatically.

      A search was performed with the default Fulltext native Search Backend, and all three 3 letter words were found. A Fulltext mysql Search Index was then built, and the Search Backend changed to Fulltext mysql. None of the three 3 letter words were found.

      Attachments

        Issue Links

          Activity

            People

              bantu Andreas Fischer [X] (Inactive)
              adiant adiant [X] (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: