Bug #94130
closedIndexing throws error because of special characters like ß
100%
Description
here is the error:
An exception occurred while executing 'INSERT INTO `index_words` (`wid`, `baseword`, `metaphone`) VALUES (?, ?, ?)' with params [246923395, "\x70\x72\x65\x76\x69\x65\x77\x5f\x75\x6b\x76\x76\x61\x30\x31\x5f\x5f\x6b\x6f\x72\x72\x65\x6b\x74\x75\x72\x5f\x5f\x76\x6f\x72\x62\x65\x75\x67\x75\x6e\x67\x73\x5f\x75\x6e\x64\x5f\x76\x65\x72\x62\x65\x73\x73\x65\x72\x75\x6e\x67\x73\x6d\x61\xc3", "268043616"]: Incorrect string value: '\xC3' for column 'baseword' at row 1
the indexing had an error because in this line of code here:
[[https://github.com/TYPO3/TYPO3.CMS/blob/9827a72a8bf71d32e25261638f65190f59d071bc/typo3/sysext/indexed_search/Classes/Indexer.php#L1078]]
$val = substr($val, 0, 60);
the string had a special character at exactly the position 60 and was broken by the cut
after replacing the line with teh following it worked for me again
$val = mb_substr($val, 0, 60);
Updated by Andreas Kienast over 3 years ago
- Status changed from New to In Progress
Updated by Gerrit Code Review over 3 years ago
- Status changed from In Progress to Under Review
Patch set 1 for branch master of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/c/Packages/TYPO3.CMS/+/69151
Updated by Manuel Winkelhofer over 3 years ago
- Related to Bug #94240: Respect multibyte characters in indexed_search search words added
Updated by Gerrit Code Review over 3 years ago
Patch set 1 for branch 10.4 of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/c/Packages/TYPO3.CMS/+/69375
Updated by Andreas Fernandez over 3 years ago
- Status changed from Under Review to Resolved
- % Done changed from 0 to 100
Applied in changeset bcf1e1ec30a0debb50a11abbccdb4817d513b0d0.