[PHPBB3-16779] Search $total_match_count allways 0 if "debug.sql_explain: true" enabled

XML

Word

Printable

Type: Bug
Status: Confirmed (View Workflow)
Priority: Minor
Resolution: Unresolved
Affects Version/s: 3.3.4
Fix Version/s: None
Component/s: Search
Labels:
- search
Environment:
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

is related to

PHPBB3-16902 Improve search results count for MySQL