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

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

XMLWordPrintable

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

      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

            Unassigned Unassigned
            Dr.Death Dr.Death
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Created:
              Updated: