Database insertion error due to invalid character (statistics / keywords)

[tobiasorth]

Keywords for the internal statistics are split at position 128 using substr:

ext-solr/Classes/Domain/Search/Statistics/StatisticsWriterProcessor.php

Line 125 in 074b382

$keywords = substr($keywords, 0, 128);

However, this is not safe for multi byte or mixed byte strings. In some cases this leads to invalid last character in the $keywords variable resulting in a insertion error in the database:
Incorrect string value: '\xE8' for column `xyz`.`tx_solr_statistics`.`keywords` at row 1

Replacing $keywords = substr($keywords, 0, 128); with $keywords = mb_substr($keywords, 0, 128, "utf-8"); resolves this issue.

The following search phrase triggers the error:
欲に弱風イどた模最タネシル)少ルキヘ社影供セス時69九ヱネ転根クルニス割員ク薦推テコケ転楽フ申任化そ能愛ほさぎ集検ち

---

Maintainers notes:

Target Versions:

• release-11.5.x
• release-12.0.x
• main

[dkd-kaehm]

@tobiasorth
Thanks for reporting.
Please transfer your suggestion to the pull-request.