[5.x]: Control Panel search returns all entries regardless of search term after upgrade to 5.5.10

[watarutmnh]

What happened?

Description

After upgrading from Craft CMS 5.5.6.1 to 5.5.10, the search functionality in the control panel is not working properly. When searching for entries using any search term, all entries are returned instead of being filtered according to the search criteria.

Steps to reproduce

1. Log in to the Craft CMS control panel
2. Navigate to the Entries section
3. Enter any search term in the search field

Expected behavior

The search results should only display entries that match the entered search term, filtering out non-matching entries.

Actual behavior

All entries are displayed in the results regardless of the search term used, effectively making the search function non-operational. The system is not filtering or narrowing down the entries based on the search criteria.

Craft CMS version

5.5.10

PHP version

8.4.2

Operating system and version

Linux 6.8.0-1012-aws

Database type and version

MySQL 8.0.40

Image driver and version

GD 8.4.2

Installed plugins and versions

• Amazon S3 | 2.2.1
• Sentry SDK | 3.0.0
• VIte | 5.0.1

[i-just]

Hi, thanks for reaching out! I’m not able to reproduce that. Could you send your composer.json, composer.lock and database export to [email protected] along with the exact search term that triggers this behaviour so that we can try to reproduce and dig deeper?

[tommysvr]

Received files in support. Specific use case was Japanese characters, and it looks like it's due to this change: 9a859d9 (#16430)

Steps to reproduce:

1. Create an entry with the title 山田
2. Search for the same term, all entries are returned
3. Check searchindex in the database and 山田 doesn't exist as a keyword (the title & slug for the newly created elementId is blank)
4. Comment out this line:

   cms/src/helpers/Search.php

   Line 44 in 9a859d9

   $str = preg_replace('/[\x{80}-\x{10FFFF}]/u', '', $str);

5. Resave the entry
6. Search now returns just that entry; searchindex shows the keyword as expected

[watarutmnh]

@tommysvr Thank you for investigating the issue. I have some additional information to share:

The files I sent were from Craft CMS version 5.6.0.2, and I noticed that the line mentioned in the comment:

$str = preg_replace('/[\x{80}-\x{10FFFF}]/u', '', $str);

as already been removed from this version. I attempted the suggested solution, but the issue with multibyte character searches persists.
Would it be possible to investigate further or suggest alternative solutions?

[i-just]

The code that Tommy mentioned is still there in 5.6.0.2, but it’s on line 71. That said, we’ll look into this and the original issue this code was fixing.

[i-just]

I’ve raised a PR for this and #16430. Once approved and released, you’ll need to resave affected elements (for example, running ./craft resave/entries --update-search-index=1 should take care of all the entries).

[watarutmnh]

@i-just Thank you!

[brandonkelly]

Craft 4.14.1 and 5.6.1 are out with that fix. Thanks again for reporting!