bolt
Search not showing results due to escaped values in database
Details
| Question | Answer |
|---|---|
| Relevant Bolt Version | 5.0.6 |
| Install type | Composer install |
| PHP version | 7.4 |
| Web server | Apache |
Reproduction
If you're filing a bug, please describe how to reproduce it. Include as much relevant information as possible, such as:
Bug summary
We are using query_search to filter a certain listing page, where the query looks like contenttype?anyField--like=query.
This works fine, as long athe query does not contain german umlaute, a "sharps" (ß) or certain special characters like /.
I'm fairly certain, this issue is caused by the encoded values stored in bolt_field_translation. A value containing / would look like ["u-7954\/26"]. For umlaute f\u00fcr is stored instead of für. Changing this values manually in the database makes the records appear in the filter results.
Steps to reproduce
- Create a content type with a simple text field.
- Crate a record containing umlaute or slashes.
- Search for the record in frontend
Expected result
The record should show um in the results.
Actual result
It does not.
Can anybody confirm this issue? I just create a fresh project and can reproduce it right away and was not able to find any workaround.