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

Search $total_match_count allways 0 if "debug.sql_explain: true" enabled

    XMLWordPrintable

Details

    • Bug
    • Status: Confirmed (View Workflow)
    • Minor
    • Resolution: Unresolved
    • 3.3.4
    • None
    • Search
    • Database server: MySQL(i) 10.2.40-MariaDB-cll-lve
      GZip compression: Off
      PHP version: 7.4.25
      Board version: 3.3.5

    Description

      If the "debug.sql_explain: true" is enabled i.e. in:

      config/default/config.yml
      

      # # phpBB's config file (This line is needed because of the packager)
      parameters:
          debug.load_time: true
          debug.sql_explain: true
          debug.memory: true
          debug.show_errors: true
          debug.exceptions: true
      

      and you do a normal search with one or more search results, the result page shows in title:

      Search found 0 match: test

      The variable $total_match_count is allways 0

      Proof:

      config/default/config.yml
      

      # # phpBB's config file (This line is needed because of the packager)
      parameters:
          debug.load_time: true
      #   debug.sql_explain: true
          debug.memory: true
          debug.show_errors: true
          debug.exceptions: true
      

      Search result title:

      Search found 144 match: test

       

      phpBB 3.3.4
      PHP 7.4.9 / 7.4.12

      Attachments

        Issue Links

          Activity

            People

              Unassigned Unassigned
              Dr.Death Dr.Death [X] (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated: